单选题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

题目内容(请给出正确答案)

单选题

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?（）

It will create the tablespace TEMP1 in group G1

It will create the tablespace TEMP1 in group G3

It will not add the tablespace TEMP1 to any group

It will create the tablespace TEMP1 in the default group

It will throw an error with message 'specified group is not available

It will create a new group with a system-generated name and add the tablespace TEMP1 to it.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?（）A The tablespace must be locally managed.B The tablespace must have only one temp file.C The tablespace must be made nondefault and offline.D The tablespace can remain as the default but must have no active sort operations.

点击查看答案
第2题

单选题You issued the following command on the temporary tablespace LMTEMP in your database： SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M； Which requirement must be fulfilled for this command to succeed？（）AThe tablespace must be locally managed.BThe tablespace must have only one temp file.CThe tablespace must be made nondefault and offline.DThe tablespace can remain as the default but must have no active sort operations.

点击查看答案
第3题

单选题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.

点击查看答案
第4题

单选题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 G1B It will create the tablespace TEMP1 in group G3 C It will not add the tablespace TEMP1 to any groupD It will create the tablespace TEMP1 in the default groupE It will throw an error with message 'specified group is not availableF It will create a new group with a system-generated name and add the tablespace TEMP1 to it.

点击查看答案
第5题

单选题You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？（）Aflash back the databaseBimport the temporary tablespace from the last exportCrestore all the data files and temporary files from the last full database backup and perform a recoveryDnot perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

点击查看答案
第6题

单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）A Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfilesB Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSC Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileD Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

点击查看答案
第7题

单选题Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）ADROP TABLESPACE temp1；BDROP TABLESPACE temp1 INCLUDING CONTENTS；CDROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；DDROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

点击查看答案

单选题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

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容