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

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


相似考题
参考答案和解析
正确答案: E,A
解析: 暂无解析
更多“多选题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”相关问题
  • 第1题:

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


    参考答案:A

  • 第2题:

    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

  • 第3题:

    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

  • 第4题:

    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

  • 第5题:

    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

  • 第6题:

    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.

    正确答案:A,C,E

  • 第7题:

    多选题
    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
    解析: 暂无解析

  • 第8题:

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


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

  • 第9题:

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


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

  • 第10题:

    单选题
    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
    解析: 暂无解析

  • 第11题:

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


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

  • 第12题:

    多选题
    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
    解析: 暂无解析

  • 第13题:

    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.


    参考答案:B, D, G

  • 第14题:

    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

  • 第15题:

    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.

    正确答案:B,E

  • 第16题:

    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

  • 第17题:

    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

  • 第18题:

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


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

  • 第19题:

    多选题
    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
    解析: 暂无解析

  • 第20题:

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


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

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


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

  • 第23题:

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


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

  • 第24题:

    多选题
    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
    解析: 暂无解析