单选题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 

第1题：

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

第2题：

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

第3题：

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.

第4题：

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.

第5题：

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

第6题：

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

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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 number of hardware components (servers, processors)? （）

• A、one server having at least two processors  
• B、two servers having one processor and one logical database partition  
• C、one server having four processors and two logical database partitions  
• D、two servers each having four processors and two logical database partitions

第14题：

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.

第15题：

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.

第16题：

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）

第17题：

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

第18题：

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.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：