多选题You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the p

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

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

第5题：

Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）

• A、System privileges apply only to the PDB in which they are used.
• B、Local users cannot use local system privileges on the schema of a common user.
• C、The granter of system privileges must possess the set container privilege.
• D、Common users connected to a PDB can exercise privileges across other PDBs.
• E、System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

第6题：

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?（）

• A、Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
• B、Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
• C、Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
• D、Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
• E、Re-create the password file in the Oracle Database 12c format.

第7题：

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.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

第15题：

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.

第16题：

Which two are true concerning a multitenant container database with three pluggable database?（）

• A、All administration tasks must be done to a specific pluggable database.
• B、The pluggable databases increase patching time.
• C、The pluggable databases reduce administration effort.
• D、The pluggable databases are patched together.
• E、Pluggable databases are only used for database consolidation.

第17题：

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL > REVOKE create table FROM C # # A_ADMIN;What is the result?（）

• A、It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
• B、It fails and reports an error because the CONTAINER=ALL clause is not used.
• C、It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
• D、It fails and reports an error because the CONTAINER=CURRENT clause is not used.
• E、It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

第18题：

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

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：