You executed the following command to create a tablespace ca

第1题：

You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）

• A、The database is in NOMOUNT state.
• B、The database is in ARCHIVELOG mode and the tablespace is online.
• C、The database is in ARCHIVELOG mode and the tablespace is offline.
• D、The database is in NOARCHIVELOG mode and the tablespace is online.
• E、The database is in NOARCHIVELOG mode and the tablespace is offline.

第2题：

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

• A、run a procedure to check the tablespace space usage
• B、define the warning threshold for the tablespace at 75% in Database Control
• C、create a trigger to be executed when tablespace space usage reaches 75%
• D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
• E、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

第3题：

第4题：

You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）

• A、DB_CREATE_FILE_DEST 
• B、DB_CREATE_ONLINE_LOG_1 
• C、DB_CREATE_ONLINE_LOG_2
• D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed

第5题：

You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）

• A、The database automatically determines the extent-sizing policy for the tablespace.
• B、The segments are automatically shrunk when the contents are removed from them.
• C、The allocation of extents within the tablespace is managed through the dictionary tables.
• D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.
• E、The space utilization description of the data blocks in segments is managed through free lists.

第6题：

You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）

• A、Image of the control file
• B、Location of the control file
• C、Contents of the control file in text format
• D、SQL command to re-create the database
• E、SQL command to re-create the control file
• F、Contents of the control file in binary format

第7题：

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）

• A、The table is moved to the SYSAUX tablespace.
• B、The table is moved to the SYSTEM tablespace.
• C、The table is removed from the database permanently.
• D、The table is renamed and remains in the TBSFD tablespace.

第8题：

You executed the following command to perform a backup of the USERS tablespace：  SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1：  ORA-01123： cannot start online backup； media recovery not enabled  What could be the reason for this error（）

• A、The MTTR Advisor is disabled.
• B、The database is in NOARCHIVELOG mode.
• C、The tablespace is already in backup mode.
• D、The Flash Recovery Area is not configured.

第9题：

Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）

• A、The extents in the undo tablespace retain data until the next full database backup.
• B、The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.
• C、The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.
• D、The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.

第10题：

Note the output of the following query；   SQL> SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table：   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE；   What is the outcome of this command？（）  

• A、 The table uses the default Flashback Data Archive.
• B、 The Flashback Data Archive Is created In the SYSAUX tablespace.
• C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.
• D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.