单项选择题
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）
A.All the instances, including the ASM instance, are shut down in the ABORT mode
B.The ASM instance is shut down, but the other instances are still running
C.The ASM instance is still functional, but the other instances are shut down
D.All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
E.HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode
F.HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode
相关考题
-
多项选择题
WhichtwostatementsregardingtheFLASHBACK_TRANSACTION_QUERYviewarecorrect?（）
A.You can find information about only active transactions from the view
B.You can find information about read only transactions from the view
C.You require the SELECT ANY TRANSACTION system privilege to access the view
D.You can find information about both active and committed transactions from the view
E.You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view -
单项选择题
Youwanttoperformthedatabasebackupwhenuseractivityonyoursystemislow,suchasbetween12:00a.m.and2:00am.Whichcommandterminateswithanerrorifthebackupisnotcompleteattheendofthespecifiedduration?（）
A.RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE
B.RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE
C.RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE
D.RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE -
单项选择题
YouhavethreetemporarytablespacegroupsnamedG1,G2,andG3inyourdatabase.Youarecreatinganewtemporarytablespaceasfollows:CREATETEMPORARYTABLESPACETEMP1TEMPFILE/u1/data/temp1.dbf SIZE10MTABLESPACEGROUP;Whichstatementregardingtheabovecommandiscorrect?（）
A.It will create the tablespace TEMP1 in group G1
B.It will create the tablespace TEMP1 in group G3
C.It will not add the tablespace TEMP1 to any group
D.It will create the tablespace TEMP1 in the default group
E.It will throw an error with message 'specified group is not available
F.It will create a new group with a system-generated name and add the tablespace TEMP1 to it.
