Q120. Which two are true about gathering optimizer statistics?

Posted on 29/10/2024 by Tran Anh

Q120. Which two are true about gathering optimizer statistics? (Choose two.)

A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
D. System statistics can be gathered only while connected to CDB$ROOT.
E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Xem thêm:

Copy và đồng bộ file giữa 2 server tự động cập nhật file có thay đổi thông qua crontab với tiện ích rsync
Data Encryption là gì?
Managing constraints | Sử dụng Constraints trong SQL
Q155 For which two purposes can you use this command?
Managing Database Transactions | Sử dụng Transactions trong SQL

Bài viết cùng chủ đề:

Q172. PDB1 and PBD2 are pluggable databases in CDB1 Examine these commands: CDB1 is then restarted Which three are true?
Q171. Which two are true about RMAN Multisection backups when a very large data file is divided int four sections?
Q170. You must migrate a NON-CDB Oracle 11g Database to a CDB without first performing an upgrade to the NON-CDB User-defined objects are stored in several tablespaces in the NON-CDB
Q169. Examine the command for creating pluggable database PDB2 in container database CDB2
Q168 After a system crash, an instance restart and an attempted opening of the PDBs result in
Q167. Which two are true about automatic block repair?
Q166. For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command?
Q165. Which two are true about server-generated alerts?
Q164. Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?
Q163. Which three are true about Recovery Manager (RMAN) in Oracle Database and later releases?
Q162. Which three methods can be used for heap table data migration after upgrading a database?
Q161. Which three are true about opatchauto?
Q160. Which three are true about Automatic Workload Repository (AWR)?
Q159. Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB?
Q158. Which three are true in Oracle 19c and later releases?
Q157. Which two are true about RMAN duplexed backup sets?

0 0 đánh giá

Đánh giá bài viết

Theo dõi

0 Góp ý

Phản hồi nội tuyến

Xem tất cả bình luận

Q120. Which two are true about gathering optimizer statistics?

Bài viết cùng chủ đề:

Q172. PDB1 and PBD2 are pluggable databases in CDB1 Examine these commands: CDB1 is then restarted Which three are true?

Q171. Which two are true about RMAN Multisection backups when a very large data file is divided int four sections?

Q170. You must migrate a NON-CDB Oracle 11g Database to a CDB without first performing an upgrade to the NON-CDB User-defined objects are stored in several tablespaces in the NON-CDB

Q169. Examine the command for creating pluggable database PDB2 in container database CDB2

Q168 After a system crash, an instance restart and an attempted opening of the PDBs result in

Q167. Which two are true about automatic block repair?

Q166. For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command?

Q165. Which two are true about server-generated alerts?

Q164. Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?

Q163. Which three are true about Recovery Manager (RMAN) in Oracle Database and later releases?

Q162. Which three methods can be used for heap table data migration after upgrading a database?

Q161. Which three are true about opatchauto?

Q160. Which three are true about Automatic Workload Repository (AWR)?

Q159. Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB?

Q158. Which three are true in Oracle 19c and later releases?

Q157. Which two are true about RMAN duplexed backup sets?

Phần mềm bản quyền

Update sản phẩm

Thêm mới sản phẩm

Đặt hàng, thanh toán

Bài viết cùng chủ đề:

Q172. PDB1 and PBD2 are pluggable databases in CDB1 Examine these commands: CDB1 is then restarted Which three are true?

Q171. Which two are true about RMAN Multisection backups when a very large data file is divided int four sections?

Q170. You must migrate a NON-CDB Oracle 11g Database to a CDB without first performing an upgrade to the NON-CDB User-defined objects are stored in several tablespaces in the NON-CDB

Q169. Examine the command for creating pluggable database PDB2 in container database CDB2

Q168 After a system crash, an instance restart and an attempted opening of the PDBs result in

Q167. Which two are true about automatic block repair?

Q166. For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command?

Q165. Which two are true about server-generated alerts?

Q164. Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?

Q163. Which three are true about Recovery Manager (RMAN) in Oracle Database and later releases?

Q162. Which three methods can be used for heap table data migration after upgrading a database?

Q161. Which three are true about opatchauto?

Q160. Which three are true about Automatic Workload Repository (AWR)?

Q159. Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB?

Q158. Which three are true in Oracle 19c and later releases?

Q157. Which two are true about RMAN duplexed backup sets?

Đăng nhập

Đăng ký