单选题In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）A The CDB must be open.B The CDB must be in the mount stage.C The CDB must be in the nomount

第1题：

第2题：

第3题：

Which three statements are true about using flashback database in a multitenant container database(CDB)?（）

• A、The root container can be flashed back without flashing back the pluggable databases (PDBs).
• B、To enable flashback database, the CDB must be mounted.
• C、Individual PDBs can be flashed back without flashing back the entire cdb.
• D、The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.
• E、A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

第4题：

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATEDATABASE” statement?（）

• A、It will create a multitenant container database (CDB) with only the root opened.
• B、It will create a CDB with root opened and seed read only.
• C、It will create a CDB with root and seed opened and one PDB mounted.
• D、It will create a CDB that must be plugged into an existing cdb.
• E、It will create a CDB with root opened and seed mounted.

第5题：

Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）

• A、If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.
• B、In a PDB plan, subplans may be used with up to eight consumer groups.
• C、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.
• D、If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
• E、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

第6题：

You run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PDBs) 3. Shuts down the CDB instance 4. Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?（）

• A、The seed will be in mount state.
• B、The seed will be opened read-only.
• C、The seed will be opened read/write.
• D、The other PDBs will be in mount state.
• E、The other PDBs will be opened read-only.
• F、The PDBs will be opened read/write.

第7题：

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）

• A、Only 1
• B、Only 2
• C、Only 3
• D、3 and 1
• E、1 and 2

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

第15题：

Which statement is true concerning dropping a pluggable database (PDB)?（）

• A、The PDB must be open in read-only mode.
• B、The PDB must be in mount state.
• C、The PDB must be unplugged.
• D、The PDB data files are always removed from disk.
• E、A dropped PDB can never be plugged back into a multitenant container database (CDB).

第16题：

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?（）

• A、The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.
• B、The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
• C、The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
• D、The statement results in an error because there are open PDBs.

第17题：

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）

• A、Data files that belong to only the root container
• B、Data files that belong to the root container and all the pluggable databases (PDBs)
• C、Data files that belong to only the root container and PDB$SEED
• D、Data files that belong to the root container and all the PDBs excluding PDB$SEED

第18题：

Which three statements are true concerning unplugging a pluggable database (PDB)?（）

• A、The PDB must be open in read only mode.
• B、The PDB must be dosed.
• C、The unplugged PDB becomes a non-cdb.
• D、The unplugged PDB can be plugged into the same multitenant container database (CDB)
• E、The unplugged PDB can be plugged into another cdb.
• F、The PDB data files are automatically removed from disk.

第19题：

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）

• A、The CDB must be open.
• B、The CDB must be in the mount stage.
• C、The CDB must be in the nomount stage.
• D、Alt existing PDBs must be closed.

第20题：

第21题：

第22题：

第23题：

第24题：