单选题You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?（）AIt will create the tablespace TEMP1 in group G1BIt will create the tablespace TEMP1 in group G3 CIt will not add the tablespace TEMP1 to any groupDIt will create the tablespace TEMP1 in the default groupEIt will throw an error with message 'specified group is not availableFIt will create a new group with a system-generated name and add the tablespace TEMP1 to it.
单选题
You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?（）
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.
参考解析
解析：
暂无解析
相关考题：
单选题View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to（）.A 1 MB B 6 MB C 10 MB D 15 MB E 11 MB
单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）ADBMS_STATS BDBMS_ALERT CDBMS_SPACE DDBMS_MONITOR EDBMS_SERVER_ALERTFDBMS_SPACE_ADMIN
单选题View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to（）.A 1 MB B 6 MB C 10 MB D 15 MB E 11 MB
单选题You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?（）AIt will create the tablespace TEMP1 in group G1BIt will create the tablespace TEMP1 in group G3 CIt will not add the tablespace TEMP1 to any groupDIt will create the tablespace TEMP1 in the default groupEIt will throw an error with message 'specified group is not availableFIt will create a new group with a system-generated name and add the tablespace TEMP1 to it.
单选题You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?（）AIt will create the tablespace TEMP1 in group G1BIt will create the tablespace TEMP1 in group G3 CIt will not add the tablespace TEMP1 to any groupDIt will create the tablespace TEMP1 in the default groupEIt will throw an error with message 'specified group is not availableFIt will create a new group with a system-generated name and add the tablespace TEMP1 to it.
多选题You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）Aset SQL_TRACE=TrueBset UNDO_RETENTION=14400Cset FAST_START_MTTR_TARGET=240Dset LOG_CHECKPOINT_INTERVAL=240Eset DB_FLASHBACK_RETENTION_TARGET=14400Fset the RETENTION GUARANTEE clause for the undo tablespace