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

题目
多选题
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).()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 ”相关问题
  • 第1题:

    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.


    参考答案:C, D, E

  • 第2题:

    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


    参考答案:B

  • 第3题:

    You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?()

    • A、SYSTEM
    • B、SYSAUX
    • C、EXAMPLE
    • D、UNDO
    • E、TEMP
    • F、USERS

    正确答案:A,B,E

  • 第4题:

    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.

    正确答案:A,B,C,D,E

  • 第5题:

    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.

    正确答案:D

  • 第6题:

    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.

    正确答案:C,D,E

  • 第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

    正确答案:C

  • 第8题:

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


    正确答案: B,D
    解析: 暂无解析

  • 第9题:

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


    正确答案: A,F
    解析: 暂无解析

  • 第10题:

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


    正确答案: C
    解析: 暂无解析

  • 第11题:

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


    正确答案: C
    解析: 暂无解析

  • 第12题:

    多选题
    You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?()
    A

    SYSTEM

    B

    SYSAUX

    C

    EXAMPLE

    D

    UNDO

    E

    TEMP

    F

    USERS


    正确答案: A,E
    解析: 暂无解析

  • 第13题:

    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.


    参考答案:C, D, F

  • 第14题:

    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.


    参考答案:D

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

    正确答案:B

  • 第16题:

    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

    正确答案:B

  • 第17题:

    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.

    正确答案:B,D,E

  • 第18题:

    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

    正确答案:A,E,G

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

    正确答案:A

  • 第20题:

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


    正确答案: D,A
    解析: 暂无解析

  • 第21题:

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

    B

    BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

    C

    BACKUP DATABASE while connected to the PDB1 container

    D

    BACKUP DATABASE while connected to the boot container

    E

    BACKUP PLUGGABLE database PDB1 while connected to PDB2


    正确答案: E,C
    解析: 暂无解析

  • 第22题:

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


    正确答案: E
    解析: 暂无解析

  • 第23题:

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


    正确答案: C,E
    解析: 暂无解析