网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
多选题Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）AThe procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.BThe procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.CAll the components may be moved into SYSAUX tablespace.DAll the components may be moved from the SYSAUX tablespace.
考题
多选题Which three statements are true about Oracle Data Pump export and import operations?（）AYou can detach from a data pump export job and reattach later.BData pump uses parallel execution server processes to implement parallel import.CData pump import requires the import file to be in a directory owned by the oracle owner.DThe master table is the last object to be exported by the data pump.EYou can detach from a data pump import job and reattach later.
考题
多选题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.
考题
多选题Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）ASystem privileges apply only to the PDB in which they are used.BLocal users cannot use local system privileges on the schema of a common user.CThe granter of system privileges must possess the set container privilege.DCommon users connected to a PDB can exercise privileges across other PDBs.ESystem 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.
考题
多选题Identify two situations in which the alert log file is updated.（）ARunning a query on a table returns ORA-600: Internal Error.BInserting a value into a table returns ORA-01722: invalid number.CCreating a table returns ORA-00955: name us already in used by an existing objects.DInserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.ERebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.
热门标签
最新试卷