Your database contains two temporary tablespaces named TEMP 

第1题：

第2题：

Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement：   SQL>ALTER TABLSPACE temp OFFLINE NORMAL；   What is the result of this statement？（）

• A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.
• B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.
• C、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.
• D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.

第3题：

第4题：

Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)

• A、The data files of the read-only tablespaces in the target database are not duplicated
• B、The read-only tablespaces in the target database are still defined in new the database
• C、The read-only tablespaces in the target database are changed to online after duplication
• D、The data files of the read-only tablespaces in the target database get duplicated
• E、The read-only tablespaces in the target database are not defined in the new database

第5题：

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

• A、 The database writer writes to a trace file， indicating that the temporary file is not found.
• B、 The database prompts for a database recovery.
• C、 The database opens normally.
• D、 The database gets mounted and throws an error indicating that the temporary file requires recovery.

第6题：

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）

• A、Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
• B、The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
• C、The command will, create a common user whose description is contained in the root and each pdb.
• D、The schema for the common user C # # A_ADMIN can be different in each container.
• E、The command will create a user in the root container only because the container clause is not used

第7题：

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

• A、The database is in mount state.
• B、One of the tablespaces is offline.
• C、One of the tablespaces is read only.
• D、The database operates in ARCHIEVELOG mode. 
• E、The database operates in NOARCHIEVELOG mode.

第8题：

第9题：

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

第10题：

Which tablespaces are mandatory in an Oracle database for it to be operational（）

• A、Undo tablespace
• B、USERS tablespace
• C、SYSAUX tablespace
• D、SYSTEM tablespace
• E、Temporary tablespace