单选题When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）A Online B Pending online C Offline D Stale

第1题：

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  

• A、 The database will not start.
• B、 The database will start but will not retain the undo data in the undo segment.
• C、 The database will start， and the undo segment will contain the undo data for at least one hour.
• D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.

第2题：

If you create your database using Oracle Managed Files （OMF）， what is true？（）

• A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
• B、You must define directories for two online redo log groups and three copies of the control file. 
• C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
• D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

第3题：

You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）

• A、The tablespace would require recovery to go back online.
• B、A checkpoint is taken on all data files that are associated with the SALES tablespace.
• C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error.
• D、The new status of the SALES tablespace is recorded in the control file when the database instance is closed.

第4题：

Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）  

• A、 Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.
• B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.
• C、 Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.
• D、 The database will open with the file in hot backup mode. You can restart the backup at any time.
• E、 The datafile in hot backup mode will be corrupted and you will have to recover it.

第5题：

Which two statements are true regarding transactions in an Oracle database（）

• A、Multiple transactions can use the same undo segment.
• B、A transaction is assigned an undo segment when it is started.
• C、More than one transaction cannot share the same extent in the undo tablespace.
• D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

第6题：

When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）

• A、Online 
• B、Pending online 
• C、Offline 
• D、Stale

第7题：

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 NOARCHIVELOG mode and the tablespace is online.
• C、 The database is in NOARCHIVELOG mode and the tablespace is offline.
• D、 The database is in ARCHIVELOG mode and the tablespace is offline.
• E、 The database is in ARCHIVELOG mode and the tablespace is online.

第8题：

Which two tasks can be performed when WLST is in OFFLINE mode?（）

• A、modifying the configuration of an online domain
• B、modifying the configuration of an offline domain
• C、viewing runtime performance data in ONLINE mode
• D、viewing runtime performance data in OFFLINE mode
• E、creating and extending domains

第9题：

In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（）  

• A、 The datafiles have an ONLINE status.
• B、 The datafiles have an OFFLINE status.
• C、 The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.
• D、 The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
• E、 The datafiles are in STANDBY mode.

第10题：

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）

• A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
• B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
• C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
• D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.