多选题Which three statements are true about using flashback database in a multitenant container database(CDB)?（）AThe root container can be flashed back without flashing back the pluggable databases (PDBs).BTo enable flashback database, the CDB must be mounted.CIndividual PDBs can be flashed back without flashing back the entire cdb.DThe DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.EA CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
多选题
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.
参考解析
解析：
暂无解析
相关考题：
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.
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:Which two statements are true?() A. The C # # ROLE1 role is created in the root database and all the PDBs.B. The C # # ROLE1 role is created only in the root database because the container clause is not used.C. Privileges are granted to the C##A_ADMIN user only in the root database.D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.E. The statement for granting a role to a user fails because the CONTAINER clause is not used.
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:Which two statements are true?() A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.C. The command will, create a common user whose description is contained in the root and each pdb.D. The schema for the common user C # # A_ADMIN can be different in each container.E. The command will create a user in the root container only because the container clause is not used
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.
Which three statements are true concerning the multitenant architecture?() A. Each pluggable database (PDB) has its own set of background processes.B. A PDB can have a private temp tablespace.C. PDBs can share the sysaux tablespace.D. Log switches occur only at the multitenant container database (CDB) level.E. Different PDBs can have different default block sizes.F. PDBs share a common system tablespace.G. Instance recovery is always performed at the CDB level.
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).
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.
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?（）A. Mount the container database (CDB) and restore the control file from the control file auto backup.B. Recover and open the CDB in NORMAL mode.C. Mount the CDB and then recover and open the database, with the RESETLOGS option.D. Open all the pluggable databases.E. Recover each pluggable database.F. Start the database instance in the nomount stage and restore the control file from control file auto backup.
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 containerB. 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$SEEDD. Data files that belong to the root container and all the PDBs excluding PDB$SEED
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.
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).
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.
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 containerB、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$SEEDD、Data files that belong to the root container and all the PDBs excluding PDB$SEED
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.
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.
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 1B、Only 2C、Only 3D、3 and 1E、1 and 2
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.
单选题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?（）AThe shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.BThe shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.CThe shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.DThe statement results in an error because there are open PDBs.
多选题Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?（）AMount the container database (CDB) and restore the control file from the control file auto backup.BRecover and open the CDB in NORMAL mode.CMount the CDB and then recover and open the database, with the RESETLOGS option.DOpen all the pluggable databases.ERecover each pluggable database.FStart the database instance in the nomount stage and restore the control file from control file auto backup.
多选题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?（）AThe seed will be in mount state.BThe seed will be opened read-only.CThe seed will be opened read/write.DThe other PDBs will be in mount state.EThe other PDBs will be opened read-only.FThe PDBs will be opened read/write.
多选题Which three statements are true concerning unplugging a pluggable database (PDB)?（）AThe PDB must be open in read only mode.BThe PDB must be dosed.CThe unplugged PDB becomes a non-cdb.DThe unplugged PDB can be plugged into the same multitenant container database (CDB)EThe unplugged PDB can be plugged into another cdb.FThe PDB data files are automatically removed from disk.
多选题Which three statements are true concerning the multitenant architecture?（）AEach pluggable database (PDB) has its own set of background processes.BA PDB can have a private temp tablespace.CPDBs can share the sysaux tablespace.DLog switches occur only at the multitenant container database (CDB) level.EDifferent PDBs can have different default block sizes.FPDBs share a common system tablespace.GInstance recovery is always performed at the CDB level.
单选题Which statement is true concerning dropping a pluggable database (PDB)?（）AThe PDB must be open in read-only mode.BThe PDB must be in mount state.CThe PDB must be unplugged.DThe PDB data files are always removed from disk.EA dropped PDB can never be plugged back into a multitenant container database (CDB).
多选题Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）ASystem privileges apply only to the PDB in which they are used.BLocal users cannot use local system privileges on the schema of a common user.CThe granter of system privileges must possess the set container privilege.DCommon users connected to a PDB can exercise privileges across other PDBs.ESystem 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.
单选题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?（）AThe CDB must be open.BThe CDB must be in the mount stage.CThe CDB must be in the nomount stage.DAlt existing PDBs must be closed.
多选题You want to flash back a test database by five hours.You issue this command:SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）AThe database must have multiplexed redo logs for the flashback to succeed.BThe database must be MOUNTED for the flashback to succeed.CThe database must use block change tracking for the flashback to succeed.DThe database must be opened in restricted mode for the flashback to succeed.EThe database must be opened with the RESETLOGS option after the flashback is complete.FThe database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
多选题In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?（）AThe C # # ROLE1 role is created in the root database and all the PDBs.BThe C # # ROLE1 role is created only in the root database because the container clause is not used.CPrivileges are granted to the C##A_ADMIN user only in the root database.DPrivileges are granted to the C##A_ADMIN user in the root database and all PDBs.EThe statement for granting a role to a user fails because the CONTAINER clause is not used.