A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least num

第1题：

You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）

• A、Clone 
• B、Copy 
• C、Template 
• D、Terminal 

第2题：

A staff member reports that they cannot access the shared folder on the network； however， other staff members are reporting that they can access the shared folder. Which of the following is the BEST way to identify the problem？（）

• A、The administrator should monitor all traffic between the staff member and the server.
• B、The administrator should reconfigure the RAID configuration to allow more space.
• C、The administrator should map a drive using the net use command.
• D、The administrator should allow the staff member to use a USB drive.

第3题：

In which two environments would intra-partition parallelism be used? （）

• A、Single database partition, single processor  
• B、Single database partition, multiple processors  
• C、Multiple database partitions, single processor  
• D、Multiple database partitions, multiple processors

第4题：

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.

第5题：

You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

• A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
• C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

第6题：

You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， SupportCenter， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）

• A、Use a flashback query to retrieve the rows that were deleted
• B、Useconventialincremental export and then import the affected object
• C、Shutdown the database inNORMALmode and restart the database instance
• D、Use DBMS_META package to reconstruct the object using undo segments
• E、UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data
• F、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

第7题：

You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)

• A、Backup compression should be enabled
• B、Parallelism for the channel should be set to 2
• C、All the files must be backed up as backup sets
• D、The backup may be stored either on disk or on media with media manager

第8题：

You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）

• A、The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
• B、The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
• C、The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
• D、The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

第9题：

第10题：

第11题：

第12题：

第13题：

An administrator has added a new device to a system and wants to determine if it has been correctly added to the ODM database. Which command would the system administrator use？（）

• A、odmget
• B、odmadd
• C、odmshow
• D、odmcreate

第14题：

An administrator has made several topology and resource group changes on one node in a running cluster.During verification and synchronization， using the "Emulate" option， many errors are reported. Theadministrator decided the best course of action was to roll back the changes. Prior to the changes beingmade， a cluster snapshot was taken. Which of the following actions will roll back the changes with the least disruption？（）

• A、Perform a synchronization from a node without the changes.
• B、Apply the cluster snapshot on both nodes while the cluster is running.
• C、"Restore HACMP Configuration Database from Active Configuration" on the node where the changes weremade
• D、Stop the cluster using the option "Unmanage Resource Groups" and apply the cluster snapshot on thenode where the changes were made

第15题：

You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： 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

第16题：

A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（）  

• A、 Do nothing.
• B、 Restart the database.
• C、 Perform recovery on the database.
• D、 Restore the alert log from the last backup.

第17题：

While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

• A、configure the database to run in ARCHIVELOG mode
• B、configure the Flash Recovery Area to enable automatic database backup
• C、schedule the database backup using DBMS_JOB package after creating the database
• D、schedule the database backup using Recovery Manager （RMAN）commands after creating the database
• E、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

第18题：

A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）

• A、Data Pump
• B、Oracle Net Manager
• C、Oracle Enterprise Manager
• D、Oracle Universal Installer （OUI）
• E、Database Configuration Assistant （DBCA）

第19题：

You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）

• A、Backup compression should be enabled
• B、Parallelism for the channel should be set to 2
• C、All the files must be backed up as backup sets
• D、The backup may be stored either on disk or on media with media manager

第20题：

Which statement is true while creating subplans using Resource Manager？（）

• A、 The subplan must belong to the consumer group， SYS_GROUP.
• B、 The total CPU usage at any given level must be less than 100%.
• C、 The subplans can be used to restrict the degree of parallelism for a user.
• D、 You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.

第21题：

第22题：

第23题：