You want to use the automatic management of backup and recov

第1题：

You want to use Windows 2000 backup to perform a weekly backup of the user data on a Windows 2000 Professional computer. You want to ensure that the registry， boot files and COM plus objects are also backed up. What should you do？（）

• A、Configure the Windows backup to backup the system partition.
• B、Configure the Windows backup to backup the System State Data.
• C、Create a script written in MS Visual Basic scripting addition language to run rdisk.exe/s before the back up starts.
• D、Create a batch file to run rdisk.exe/s before the backup starts.

第2题：

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.

第3题：

You want the size of the tablespace to increase when it is full. Which option would you use？（）

• A、use automatic extent allocation
• B、disable threshold for the tablespace
• C、use freelists to manage the free space
• D、use automatic segment space management
• E、create the tablespace as a bigfile tablespace
• F、use the RESIZE clause while creating the tablespace
• G、enable AUTOEXTEND for at least one of the data files in the tablespace

第4题：

You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）

• A、the XML script
• B、the PL/SQL script
• C、the DBMS_SCHEDULER package
• D、Enterprise Manager to schedule the backup

第5题：

Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

• A、backup of offline tablespaces
• B、backup of read­only tablespaces
• C、backup of system­critical tablespaces
• D、backup of online， locally managed tablespaces
• E、backup of read/write dictionary­managed tablespaces

第6题：

Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

• A、You need to perform the restore and recover operations manually, because the backup was made manually. 
• B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
• C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
• D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

第7题：

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

• A、The DBMS_JOB package
• B、The BACKUP_JOB package
• C、The DBMS_BACKUP_RESTORE package
• D、The calendar tool in the Operating System （OS）
• E、The backup scheduler in Enterprise Manager （EM）
• F、The DBMS_BACKUP_SCHEDULER packager inline mode

第8题：

You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

• A、 You must use automatic undo management in the database.
• B、 You must configure OMF in your database.
• C、 You must configure ASM for storing the datafiles.
• D、 You must multiplex the online redo log file.

第9题：

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

第10题：

For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

• A、 Automatic PGA Memory Management
• B、 Automatic SGA Memory Management
• C、 Automatic Shared Memory Management
• D、 Automatic Memory Management
• E、 Manual SGA Memory Management
• F、 None of the above