网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）
- A、This clause is not valid for a temporary or undo tablespace.
- B、If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.
- C、The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.
- D、The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.
参考答案
更多 “Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）A、This clause is not valid for a temporary or undo tablespace.B、If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.C、The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.D、The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.” 相关考题
考题
You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? ()
A. It stores only the temporary table but not its indexes.B. It stores both the temporary table as well as its indexes.C. It must be a nondefault temporary tablespace for the database.D. It can be a default or nondefault temporary tablespace for the database.E. It must be the default temporary tablespace of the user who issues the command.
考题
At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A、 Start the database in OPEN mode， and create a new index tablespace.B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
考题
Which two statements are true regarding undo tablespaces（）A、The database can have more than one undo tablespace.B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
考题
Which two statements are true regarding the ORDER BY clause? （）A、The sort is in ascending by order by default.B、The sort is in descending order by default.C、The ORDER BY clause must precede the WHERE clause.D、The ORDER BY clause is executed on the client side.E、The ORDER BY clause comes last in the SELECT statement.F、The ORDER BY clause is executed first in the query execution.
考题
Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）A、The operation would fail if tbs_1 were a read-only tablespace.B、The operation would fail if tbs_1 were a read/write tablespace.C、The operation would fail if tbs_1 were the default tablespace for the database.D、If the above operation were successful， media recovery would be required to bring the tablespace online.E、If the above operation were successful， instance recovery would be required to bring the tablespace online.
考题
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.
考题
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?（）A、The data is decrypted during SORT and JOIN operations.B、The data remains encrypted when it is read into memory.C、The data remains encrypted when it is stored in the redo logs.D、The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
考题
Which two statements are true regarding the ORDER BY clause? （）A、It is executed first in the query execution B、It must be the last clause in the SELECT statement C、It cannot be used in a SELECT statement containing a HAVING clauseD、You cannot specify a column name followed by an expression in this clause E、You can specify a combination of numeric positions and column names in this clause
考题
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte？（）A、This clause is not valid for a temporary or undotablespace.B、If thetablespaceis in the NOLOGGING mode， no operation on thetablespacewill generate redo.C、Thetablespacewill be IntheNOLOGGING mode by default， if not specified while creating atablespace.D、Thetablespace-level logging attribute can be overridden by logging specification at the table， index， materialized view， materialized view log， and partition levels.
考题
Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）A、 undo tablespaceB、 index tablespaceC、 read-only tablespaceD、 temporary tablespace
考题
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）A、This clause is not valid for a temporary or undo tablespace.B、If the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.C、The tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.D、The tablespacelevel logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.
考题
Which two statements are true regarding the USING and ON clauses in table joins?（）A、Both USING and ON clauses can be used for equijoins and nonequijoins B、Amaximum of one pair of columns can be joined between two tables using the ON clause C、The ON clause can be used to join tables on columns that have different names but compatible data types D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
考题
You issued the following command： CREATE GLOBAL TEMPORARY TABLE admin_work_area （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1； An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command？（） A、 It stores only the temporary table but not its indexes.B、 It stores both the temporary table as well as its indexes.C、 It must be a nondefault temporary tablespace for the database.D、 It can be a default or nondefault temporary tablespace for the database.E、 It must be the default temporary tablespace of the user who issues the command.
考题
Examine the commands executed in a DBA session：SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding the MRKT tablespace（）A、No more data files can be added to the tablespace.B、Segment space is managed by free lists in the tablespace.C、A user created without being assigned a default tablespace uses this tablespace.D、The tablespace can be dropped with the current setting with segments present in 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.
考题
The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）A、Undo data becomes obsolete after 1，000 seconds.B、Undo data gets refreshed after every 1，000 seconds.C、Undo data will be stored permanently after 1，000 seconds.D、Committed undo data would be retained for 1，000 seconds if free undo space is available.E、Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.
考题
单选题ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language （DML） statements on the encrypted data in the tables？（）A
The data is decrypted during SORT and JOIN operations.B
The data remains encrypted when it is read into memory.C
The data remains encrypted when it is stored in the redo logs.D
The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
考题
多选题Which two statements are true regarding the ORDER BY clause? （）AThe sort is in ascending by order by default.BThe sort is in descending order by default.CThe ORDER BY clause must precede the WHERE clause.DThe ORDER BY clause is executed on the client side.EThe ORDER BY clause comes last in the SELECT statement.FThe ORDER BY clause is executed first in the query execution.
考题
多选题Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）AThis clause is not valid for a temporary or undo tablespace.BIf the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.CThe tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.DThe tablespacelevel logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.
考题
单选题Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）A
undo tablespaceB
index tablespaceC
read-only tablespaceD
temporary tablespace
考题
多选题Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）AThis clause is not valid for a temporary or undo tablespace.BIf the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.CThe tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.DThe tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.
考题
多选题Which two statements are true regarding undo tablespaces（）AThe database can have more than one undo tablespace.BThe UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.CUndo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.DAn undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
考题
单选题The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）A
Undo data becomes obsolete after 1，000 seconds.B
Undo data gets refreshed after every 1，000 seconds.C
Undo data will be stored permanently after 1，000 seconds.D
Committed undo data would be retained for 1，000 seconds if free undo space is available.E
Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.
考题
单选题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.
考题
单选题Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）A
The operation would fail if tbs_1 were a read-only tablespace.B
The operation would fail if tbs_1 were a read/write tablespace.C
The operation would fail if tbs_1 were the default tablespace for the database.D
If the above operation were successful， media recovery would be required to bring the tablespace online.E
If the above operation were successful， instance recovery would be required to bring the tablespace online.
考题
多选题Which two statements are true regarding the ORDER BY clause? （）AIt is executed first in the query executionBIt must be the last clause in the SELECT statementCIt cannot be used in a SELECT statement containing a HAVING clauseDYou cannot specify a column name followed by an expression in this clauseEYou can specify a combination of numeric positions and column names in this clause
考题
单选题You are attempting to create an Oracle-Managed Files （OMF） tablespace in a production database with the following statement and receive the following error message： CREATE TABLESPACE tbsl； ORA-02199： missing DATAFILE/TEMPFILE clause oerr ora 2199 02199， 00000， “missing DATAFILE/TEMPFILE clause” *Cause： A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause. *Action： specify DATAFILE/TEMPFILE clause. What is the corrective action to create the OMF based tablespace？（）A
AB
BC
CD
D
热门标签
最新试卷
