多选题You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）ASYSTEMBSYSAUXCEXAMPLEDUNDOETEMPFUSERS

第1题：

第2题：

You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database. 

• A、a， b， f， g
• B、c， f， g
• C、a， d， f， g
• D、a， f， g
• E、a， e， g

第3题：

You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）

• A、flash back the database
• B、import the temporary tablespace from the last export
• C、restore all the data files and temporary files from the last full database backup and perform a recovery
• D、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

第4题：

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.

第5题：

One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）

• A、drop and re­create the read­only tablespaces
• B、rename the read­only data files to their correct file names
• C、change the tablespace status from read/write to read­only
• D、re­create the read­only tablespace because it is automatically removed

第6题：

Identify three valid methods of opening, pluggable databases (PDBs).（）

• A、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
• B、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdb
• C、ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
• D、ALTER DATABASE PDB OPEN issued from the root
• E、ALTER DATABASE OPEN issued from that pdb 
• F、ALTER PLUGGABLE DATABASE PDB OPEN issued from another pdb
• G、ALTER PLUGGABLE DATABASE OPEN issued from that pdb

第7题：

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

• A、Reregistering the target database in recovery catalog
• B、Transporting the new tablespaces to the recovery catalog database
• C、Syncronizing the recovery catalog with the target database control file
• D、Performing a fresh backup of the target database to include the new data files in the catalog database

第8题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now you get an order from your company CIO， you have to identify whether a database integrity check （DBCC CHECKDB） was run for a particular database.  Which log file should you examine？（）

• A、log.trc 
• B、default.trc 
• C、ERRORLOG 
• D、SQLAGENT

第9题：

第10题：

第11题：

第12题：

第13题：

At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）

• A、 Start the database in OPEN mode， and create a new index tablespace.
• B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.
• C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.
• D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.

第14题：

You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）

• A、SYSTEM
• B、SYSAUX
• C、EXAMPLE
• D、UNDO
• E、TEMP
• F、USERS

第15题：

You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）

• A、 Reregistering the target database in recovery catalog
• B、 Transporting the new tablespaces to the recovery catalog database
• C、 Syncronizing the recovery catalog with the target database control file
• D、 Performing a fresh backup of the target database to include the new data files in the catalog database

第16题：

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）

• A、Use Oracle Managed Files (OMF).
• B、Specify the SEED FILE_NAME_CONVERT clause.
• C、Specify the PDB_FILE_NAME_CONVERT initialization parameter.
• D、Specify the DB_FILE_NAMECONVERT initialization parameter.
• E、Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

第17题：

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?（）

• A、Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDb.
• B、Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
• C、Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
• D、Take the USERDATA tablespace offline in ACCOUNTS_PDb.

第18题：

You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

• A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.
• B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.
• C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.
• D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

第19题：

You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）

• A、 Create an INSERT trigger to assign the default value to each item in the table. 
• B、 Create a CHECK constraint to validate the data and to assign the default value to each item in the table. 
• C、 Create an UPDATE trigger to update the default value for each new item in the table. 
• D、 Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.

第20题：

第21题：

第22题：

第23题：