单选题You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG；  Where is the information that the database is now in ARCHIVELOG mode stored？（）A SPFILEB archive logC control fileD system tablespace

第1题：

You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；  Which statement is true about this command（）

• A、The command must be issued in MOUNT state.
• B、The command succeeds only if the data file is offline.
• C、The command must be issued when the database is in the archivelog mode.
• D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

第2题：

In which two cases would you perform only consistent backup？（）

• A、You are working on a database where downtime is not tolerated.
• B、You are working on a database where downtime can be tolerated.
• C、You are working on a database that operates in ARCHIVELOG mode.
• D、You are working on a database that operates in NOARCHIVELOG mode.
• E、You are working on a database where all the tablespaces are locally managed.
• F、You are working on a database where control files and redo log files are multiplexed.
• G、You are working on a database where control files and redo log files are not multiplexed.

第3题：

You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）

• A、 Open the database in read-only mode.
• B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
• C、 Enable the block change tracking feature.
• D、 Execute the ALTER DATABASE FLASHBACK ON statement.

第4题：

You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG；  Where is the information that the database is now in ARCHIVELOG mode stored？（）

• A、SPFILE
• B、archive log
• C、control file
• D、system tablespace

第5题：

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.

第6题：

Which two statements are true regarding the database in ARCHIVELOG mode？（）

• A、You have to shut down the database to perform the backups.
• B、Archiving information is written to the data files and redo log files.
• C、You can perform complete database backups without closing the database.
• D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
• E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

第7题：

You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）

• A、Execute the ALTER DATABASE ARCHIVELOG statement
• B、Select ARCHIVELOG option in the database control and restart the database to apply the changes.
• C、Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
• D、Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.

第8题：

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）  

• A、 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
• B、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.
• C、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.
• D、 If you restart the database，the database will not be opened.

第9题：

You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

• A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
• B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
• C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
• D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

第10题：

Which two database operations can be performed at the MOUNT stage of database startup？（）

• A、renaming of data files
• B、dropping the database user
• C、renaming of control files
• D、multiplexing of control files
• E、configuring the database in ARCHIVELOG mode