网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “Identify three valid methods of opening, pluggable databases (PDBs).（）A、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the rootB、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdbC、ALTER PLUGGABLE DATABASE PDB OPEN issued from the seedD、ALTER DATABASE PDB OPEN issued from the rootE、ALTER DATABASE OPEN issued from that pdbF、ALTER PLUGGABLE DATABASE PDB OPEN issued from another pdbG、ALTER PLUGGABLE DATABASE OPEN issued from that pdb” 相关考题
考题
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?()
A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root containerB. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 containerC. BACKUP DATABASE while connected to the PDB1 containerD. BACKUP DATABASE while connected to the boot containerE. BACKUP PLUGGABLE database PDB1 while connected to PDB2
考题
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?()
A.SYSTEMB.SYSAUXC.EXAMPLED.UNDOE.TEMPF.USERS
考题
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.
考题
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.
考题
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, 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.
考题
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）A、SYSTEMB、SYSAUXC、EXAMPLED、UNDOE、TEMPF、USERS
考题
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A、’SQL ALTER DATABASE OPEN’；B、SQL ALTER DATABASE ’OPEN’；C、OPEN DATABASE；D、DATABASE OPEN
考题
Which command is used to open the database after an incomplete recovery？（）A、 alter database openB、 alter database open repairlogC、 alter database open resetlogsD、 alter database open resetlogE、 alter database resetlogs open
考题
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 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.
考题
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
考题
After the recovery is complete， which command should you execute？（）A、ALTER DATABASE OPEN；B、ALTER DATABASE CLEAR LOGFILE；C、ALTER DATABASE OPEN RESETLOGS；D、ALTER DATABASE OPEN NORESETLOGS；
考题
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.
考题
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 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.
考题
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
考题
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
考题
多选题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.
考题
多选题Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）ABACKUP PLUGGABLE DATABASE PDB1 while connected to the root containerBBACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 containerCBACKUP DATABASE while connected to the PDB1 containerDBACKUP DATABASE while connected to the boot containerEBACKUP PLUGGABLE database PDB1 while connected to PDB2
考题
单选题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 command is used to open the database after an incomplete recovery？（）A
alter database openB
alter database open repairlogC
alter database open resetlogsD
alter database open resetlogE
alter database resetlogs open
考题
单选题You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A
STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B
STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C
STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D
STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
考题
多选题Identify three valid methods of opening, pluggable databases (PDBs).（）AALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the rootBALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdbCALTER PLUGGABLE DATABASE PDB OPEN issued from the seedDALTER DATABASE PDB OPEN issued from the rootEALTER DATABASE OPEN issued from that pdbFALTER PLUGGABLE DATABASE PDB OPEN issued from another pdbGALTER PLUGGABLE DATABASE OPEN issued from that pdb
考题
多选题Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）AIf 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.BIn a PDB plan, subplans may be used with up to eight consumer groups.CIf a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.DIf no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.EIf 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.
考题
多选题You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）ASYSTEMBSYSAUXCEXAMPLEDUNDOETEMPFUSERS
热门标签
最新试卷
