单选题While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：  a） high availability of data  b） faster primary key access to the table data  c） compact storage for the table  Which ty

第1题：

Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）

• A、 ALTER DATABASE DROP LOGFILE GROUP 1
• B、 ALTER DATABASE CLEAR LOGFILE GROUP 1
• C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
• D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

第2题：

There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

• A、Only bring the tablespace back online.
• B、Only recover the tablespace and then bring the tablespace back online.
• C、Shut down the database， recover the data file and then start up the database.
• D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
• E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

第3题：

Your archive-log destination directory runs out of space. What is the impact of this on the database？（）  

• A、 None. The database will switch over to the stand-by archive-log destination directory.
• B、 A warning message will be written to the alert log of the database，but no adverse impacts to the database will be experienced.
• C、 The database will shut down，and will not restart until you correct the out-of-space situation.
• D、 The database will continue to try to write to the archive-log destination directory for one hour. After one hour，the database will shut down normally.
• E、 Once Oracle has cycled through all online redo logs，it will stop processing any DML or DDL until the out-of-space condition is corrected.

第4题：

The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（） 

• A、 The database will hang.
• B、 The database will be crashed.
• C、 The database will be shut down.
• D、 The LGWR process writes redo log entries to the other redo log member of the Group2 group

第5题：

You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

• A、One tablespace has only one datafile
• B、Many tablespaces can share one datafile
• C、One tablespace can have many datafiles
• D、One datafile can contain many tablespaces

第6题：

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）  

• A、 Yes， if the database is in ARCHIVELOG mode
• B、 Yes， if the database is in NOARCHIVELOG mode
• C、 No， the backup is not usable in any way
• D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

第7题：

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

• A、import the database from the last export
• B、restore all the members in the group from the last backup
• C、drop the lost member from the database， and then add a new member to the group
• D、restore all the database files from the backup， and then perform a complete recovery 
• E、restore all the database files from the backup， and then perform an incomplete recovery

第8题：

You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）  

• A、the value of the UNDO_RETENTION initialization parameter
• B、the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
• C、the online redo log files size
• D、the number of redo log members in a group

第9题：

In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

• A、 when all the online redo log groups are multiplexed and one of the members of a group is missing
• B、 when all the online redo log groups are not multiplexed and one log group is missing
• C、 when all the control files are missing
• D、 when some important tables are deleted from the database and purged from the Recycle Bin

第10题：

Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors：   ORA-00313： open failed for members of log group 1 of thread 1   ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’   You discover that the online redo log file of the current redo group is corrupted.  Which statement should you use to resolve this issue？（）

• A、 SQL>ALTER DATABASE DROP LOGFILE GROUP 1；
• B、 SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1；
• C、 SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；
• D、 SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；