You are working as a Database Administrator. Despite having 

第1题：

You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）

• A、The database performance would be enhanced.
• B、The redo log files would be get filled more frequently.
• C、The overall database performance would be degraded.
• D、The mean time to recover （MTTR） would be increased.

第2题：

You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

• A、You can perform consistent backups only.
• B、You can perform a complete database backup without shutting down the database instance.
• C、You can back up data files only when all data files have the same SCN recorded in the control file.
• D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

第3题：

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

• A、 Flashback logs are not archived.
• B、 Flashback logs are maintained in redo log files.
• C、 Flashback logs are maintained in the Flash Recovery Area.
• D、 Flashback logs are used to maintain Flashback Database related errors.
• E、 Flashback logs need to be cleared manually after you disable Flashback Database.

第4题：

You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

• A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
• B、 Before the instance starts， you receive an error about the missing redo log files of a group.
• C、 The instance starts and the database opens with an error message written to the alert log file.
• D、 The instance starts and the database opens because two redo log groups still exist.
• E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

第5题：

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

• A、to enable operating system authentication for a remote client
• B、to restrict the scope of administration to identical operating systems
• C、to allow the start up and shut down of the database from a remote client
• D、to enable the administration of the operating system from a remote client
• E、to disable the administration of the operating system from a remote client

第6题：

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）

• A、 V$FLASHBACK_DATABASE_LOG
• B、 V$FLASHBACK_DATABASE_STAT
• C、 V$DATABASE
• D、 V$UNDOSTAT

第7题：

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.

第8题：

You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1：   DROP FLASHBACK ARCHIVE fla1；   What is the effect of this command？（）

• A、 The Flashback Archive FLA1 is dropped only if it is empty.
• B、 The tablespace having Flashback Archive is dropped.
• C、 The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
• D、 The Flashback Data Archive and historical data are dropped.

第9题：

You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）

• A、 SYSDATE should not be used with TIMESTAMP.
• B、 The database must have multiplexed redo log files.
• C、 The database must be in the MOUNT state to execute the command.
• D、 The database must be opened with the RESETLOGS option after the flashback operation.
• E、 The entire database needs to be restored from the most recent backup before the flashback operation.

第10题：

You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single site named KingSite1.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging  solution.Company.com has recently configured the mailbox server as members of a database availability group （DAG） with a public folder database. During the course of the business week you receive instruction from Company.com to create a new Active Directory site and install Exchange server in the site whilst ensuring the public folders are stored on servers in both sites. What should you do？（）

• A、You should consider having clustered continuous replication （CCR） configured on two servers in the new site.You should then have the replication settings for all public folder databases modified.
• B、You should consider having the standby continuous replication （SCR） configured on a server in the new site.You should then have the Enable-StorageGroupCopy cmdlet run from a server in the new site.
• C、You should consider having a public folder database created on a server in the new site.You should then have the replication settings for all public folders modified.
• D、You should consider having a public folder database created on a server in the new site.You should then have the set-DatabaseAvailabilityGroup cmdlet run from a server in the new site.