单选题While planning to manage more than one database in your system， you perform the following activities：  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate admi

第1题：

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

• A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
• B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
• C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
• D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
• E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

第2题：

You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

• A、Oracle Flashback uses undo information to construct consistent data. 
• B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
• C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
• D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

第3题：

Case 1：  1. Shut down the database and perform a backup.  2. Restore all the data files.  3. Mount the database.  4. Recover the database.  5. Without applying all the redo log files， open the database using the RESETLOGS option.  6. Back up the database.  Case 2：  1. Shut down the database and perform a backup.  2. Restore only the data files of the tablespace where user error damaged the data.  3. Mount the database. 4. Recover the database.  5. Open the database with the RESETLOGS option.  6. Back up the database.  Case 3：  1. Shut down the database.  2. Restore the data files.  3. Open the database.  4. Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）

• A、 Only case 1
• B、 Only case 2
• C、 Only case 3
• D、 Case 1 and 2
• E、 Case 2 and 3
• F、 Case 1 and 3
• G、 All cases， case 1， case 2， case 3

第4题：

You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

• A、 You will need to open the database with the resetlogs command.
• B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
• C、 You will use the resetlogs version of the create controlfile command.
• D、 You will use the noresetlogs version of the create controlfile command.
• E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

第5题：

You are the network administrator for TestKing. The network consists of a single Active Directory domain named testking.com. All domain controller run Windows Server 2003. employes three database administrators who administer seven databases servers that run Windows Server 2003. The database administrators occasionally restore a database server after a disaster. To restore a server, database administrators need the rights required to perform the following tasks: 1. Back up files and folders 2. Restore files and folders. 3. Restore the System State data. You need to assign the database administrators the rights that they require to perform the specified tasks. For security reasons, you must not assign the administrators more rights than they require to perform the tasks. What should you do?（）

• A、Add the database administrators' user accounts to the Administrators group on each of the database servers.
• B、Add the database administrators' user accounts to the Power Users group on each of the database servers.
• C、Add the database administrators' user accounts to the Backup Operators group on each of the database servers.
• D、Add the database administrators' user accounts to the Backup Operators group on one of the domain controllers.
• E、Add the database administrators' user accounts to the Server Operators group on one of the domain controllers.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

• A、Oracle Migration Assistant
• B、Recovery Manager （RMAN）
• C、Oracle Data Pump Export and Import
• D、conventional Oracle Export and Import
• E、operating system utilities to copy the files to the ASM instance

第14题：

You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）

• A、You performed rollback after commit.
• B、If a log switch occurs in your database.
• C、Thearchiverfails to generate an archived log file.
• D、Instance recovery fails to find one of the redo log files.
• E、A long-running query is unable to get read-consistent image.
• F、If you perform manual undo management operations in auto mode.

第15题：

You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）

• A、Restore all the data files and open the database
• B、Create the data file and perform tablespace recovery
• C、No need to restore any file， just recover the database
• D、Restore only the system data file and recover the database
• E、Restore only lost date file and performtablespacerecovery

第16题：

In a new installation of Oracle Database 11g， you perform these activities：  1：Organize software and data on different subdirectories to avoid poor performance.  2：Use consistent naming conventions for database files.  3：Separate administrative information pertaining to the database in different directories.  Which option corresponds to the type of activities you performed（）

• A、Oracle Managed Files
• B、Oracle Grid Architecture
• C、Optimal Flexible Architecture
• D、Oracle database architecture
• E、Automatic Storage Management

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：