单选题Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?()APlace the root container in ARHCHIVELOG mode.BTake the user data tablespace offline.CPlace the root container in the nomount stage.DEnsure that HR_PDB is open.

单选题
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?()
A

Place the root container in ARHCHIVELOG mode.

B

Take the user data tablespace offline.

C

Place the root container in the nomount stage.

D

Ensure that HR_PDB is open.


参考解析

解析: 暂无解析

相关考题:

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?()A. It succeeds because the PDB_ADMIN user has the required privileges.B. It fails because common users are unable to use the SET CONTAINER statement.C. It fails because local users are unable to use the SET CONTAINER statement.D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

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.

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command?()A. Place the root container in ARHCHIVELOG mode.B. Take the user data tablespace offline.C. Place the root container in the nomount stage.D. Ensure that HR_PDB is open.

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 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.

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.

Identify two correct statements about multitenant architectures.() A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.B. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.C. Multiple CDBs share certain PDB resources.D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.E. Patches are always applied at the CDB level.F. A PDB can have a private undo tablespace.

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

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?()A. It collects data from SGA and compares it with a preserved snapshot.B. It collects data from SGA, analyzes it, and provides a report.C. It collects data from SGA and compares it with the latest snapshot.D. It collects data from both SGA and PGA, analyzes it, and provides a report

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 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).

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.

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.

单选题What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATEDATABASE” statement?()AIt will create a multitenant container database (CDB) with only the root opened.BIt will create a CDB with root opened and seed read only.CIt will create a CDB with root and seed opened and one PDB mounted.DIt will create a CDB that must be plugged into an existing cdb.EIt will create a CDB with root opened and seed mounted.

多选题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.

单选题You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?()AIt succeeds because the PDB_ADMIN user has the required privileges.BIt fails because common users are unable to use the SET CONTAINER statement.CIt fails because local users are unable to use the SET CONTAINER statement.DIf fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

多选题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.

单选题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?()AOnly 1BOnly 2COnly 3D3 and 1E1 and 2

单选题Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: SQL CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?()AIt executes successfully and creates an UNDO tablespace in hr_pdb.BIt falls and reports an error because there can be only one undo tablespace in a cdb.CIt fails and reports an error because the CONTAINER=ALL clause is not specified in the command.DIt fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.EIt executes successfully but neither tablespace nor the data file is created.

单选题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?()AData files that belong to only the root containerBData files that belong to the root container and all the pluggable databases (PDBs)CData files that belong to only the root container and PDB$SEEDDData files that belong to the root container and all the PDBs excluding PDB$SEED

多选题Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?()ASchema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.BThe C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.CThe command will, create a common user whose description is contained in the root and each pdb.DThe schema for the common user C # # A_ADMIN can be different in each container.EThe command will create a user in the root container only because the container clause is not used

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

多选题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.

多选题Identify two correct statements about multitenant architectures.()AMultitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.BMultiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.CMultiple CDBs share certain PDB resources.DMultiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.EPatches are always applied at the CDB level.FA PDB can have a private undo tablespace.

多选题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 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.