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 col

题目

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

相似考题

1.You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;Which is true about the result of this command?（）A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

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

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

4.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?（）A. It executes successfully and creates an UNDO tablespace in hr_pdb.B. It falls and reports an error because there can be only one undo tablespace in a cdb.C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.E. It executes successfully but neither tablespace nor the data file is created.

更多“In your multitenant container database (CDB) containing pluggable databases (PDB), users c ”相关问题

  • 第1题：

    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

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

    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

  • 第4题：

    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

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

相关内容