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

第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题：

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题：

第4题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

• A、 online redo log files
• B、 alert log files
• C、 control file
• D、 datafiles associated with the SYSTEM tablespace

第5题：

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?（）

• A、By default, EM express is available for a database after database creation.
• B、You can use EM express to manage multiple databases running on the same server.
• C、You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D、You cannot start up or shut down a database Instance by using EM express.
• E、You can create and configure pluggable databases by using EM express.

第6题：

Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’；   Which two statements are true regarding the backup created using this command？（）

• A、 The copy of the datafile created is stored in the RMAN repository.
• B、 The copy of the datafile created can be viewed using the LIST BACKUP command.
• C、 The copy of the datafile created using this COPY command can be placed only on the disk.
• D、 The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
• E、 The copy of the datafile created can be used for recovering the database using the user-managed recovery method.

第7题：

You are working on a new Oracle Database 11g server， where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.  Some of the requirements set for your database creation task are：  1：Configure the database to operate in shared server mode.  2：Disable automatic maintenance tasks such as optimizer statistics collection.  3：Configure a naming method to help the remote user connect to the database instance.  4：Use Automatic Storage Management （ASM） for storing the database files.  5：Configure daily database backup to flash recovery area.  6：Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）

• A、4 and 6
• B、2，3，4，and 6
• C、1，2，4，5，and 6
• D、1，2，3，4，5，and 6

第8题：

You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are： 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management （ASM） for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）

• A、4 and 6
• B、2，3，4，and 6
• C、1，2，4，5，and 6
• D、1，2，3，4，5，and 6

第9题：

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

第10题：

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

• A、 The time when the last flashback operation in your database was performed.
• B、 The time when the first flashback operation in your database was performed.
• C、 A list of flashback operations performed in your database using SCN and time.
• D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.