[单项选择] In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.  Which method must you use to recover the lost data？（）  
A.  Complete Recovery with online redo log
B.  Complete Recovery with archived redo log
C.  Tablespace Point-in-Time Recovery （TSPITR）
D.  Incomplete Recovery with system change number （SCN）

[单项选择] A database administrator wants a unique IP address for each of three instances of a database.  Normally，all instances run on a large production node，but they may fallover to different standby nodes according to the dynamic node priority configuration.  What is the best way to obtain unique addresses for each of the three database instances？（）
A.  There is no way since this cannot be configured with HACMP
B.  Use IP Replacement address takeover and define all service addresses on the same NIC
C.  Use IP Aliasing for address takeover and define each alias in a separate resource group
D.  Use EtherChannel to map the three alias IP addresses to the common service address defined to HACMP

[单项选择] Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA/x7f01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）
A. flash back the corrupted blocks
B. use the DBMS_REPAIR package
C. use the RMAN TSPITR command
D. use the RMAN BLOCKRECOVER command
E. use the RESTORE DATABASE and RECOVER DATABASE commands
F. investigate the time at which the corruption occurred and perform a point­in­time recovery

[多项选择] You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.  Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（） 
A.  SYSTEM
B.  SYSAUX
C.  UNDO
D.  USERS
E.  TEMP
F.  This restore is not possible

[单项选择] A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member.  A LGWR Input/output （I/O） fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.   1） Restore the corrupted redo log group. 2） Restore from a whole database backup.  3） Perform incomplete recovery.  4） Relocate by renaming the member of the damaged online redo log group to a new location.  5） Open the database with the RESETLOGS option.  6） Restart the database instance.  7） Issue a checkpoint and clear the log.   Identify the option with the correct sequential steps to accomplish the task efficiently（）.  
A.  1，3，4，and 5
B.  7，3，4. and 5
C.  2，3，4，and 5
D.  7，4，3，and 5
E.  Only 6 is required

[单项选择] You work with a database named DB1， which is located on a SQL Server 2005 computer. You discover that a table scan on Table1 in DB1 causes a slow query. Table1 is a very large table that is used frequently. You ascertain that the query contains the following statement. SELECT col1， col2 FROM table1 WHERE col3 =  You need to provide maximum query performance. Table1 must remain available to users. What should you do？（）
A. Update all statistics on Table1 in DB1.
B. Use the CREATE STATISTICS statement in DB1 to create missing statistics on col3of Table1.
C. Set the priority boost server option to 1.
D. Execute the following statement.USE DB1GOCREATE INDEX index1 ON table1（col3）INCLUDE（col1， col2） WITH （ONLINE = ON）GO

[单项选择] You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）
A.  It must be executed from the Oracle Database 11g environment.
B.  It must be executed only after the SYSAUX tablespace has been created.
C.  It must be executed from the environment of the database that is being upgraded.
D.  It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E.  It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

[单项选择] Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS.  The database is still running.  Which answer properly describes the rder of the steps that you would use to recover from this error？（）   a. Shut down the database.  b. Take the users_01.dbf datafile offline with the alter database command.  c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database.  h. Bring the users_01.dbf datafile online with the alter database command. 
A. a， c， f， g
B. b， c， f， h
C. a， b， c， f， g
D. a， b， c， f， g， h
E. b， c， f， e， g

[单项选择] Your production database uses an Automatic Storage Management （ASM） instance to manage its files.  You want to add a new disk group to the ASM instance to manage the increased data load.  What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
A. mount the new disk group in the ASM instance
B. restart the ASM instance and the production database instance
C. register the new disk groups in the production database instance
D. restart the ASM instance without restarting the production database instance
E. include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

[多项选择] You work as a database administrator for Certkiller .com. Your listener process， L1，is currently listening to three databases：CertK INDB04，Certkiller DB05 and Certkiller DB06. Using Database Configuration Assistant （DBCA） you create one more database，Certkiller DB07，and enable dynamic registration.  Which two commands of Listener Control Utility （lsnrct1） would you use to determine whether the dynamic registration occurred for the database， Certkiller DB07， with the L1 listener process？（）
A. SHOW L1
B. SPAWN L1
C. STATUS L1
D. SERVICES L1
E. STATUS LISTENER
F. SERVICES LISTENER
G. SHOWcurrent_listener