多选题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 generat

第1题：

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.

第2题：

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.

第3题：

第4题：

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.

第5题：

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.

第6题：

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.

第7题：

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.

第8题：

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.

第9题：

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 clause
• D、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

第10题：

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 tablespace
• B、 index tablespace
• C、 read-only tablespace
• D、 temporary tablespace