Q22. Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance?
Q22. Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance?
- A. Sorts and Hash Joins use PGA memory.
- B. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
- C. The entire PGA is located in the System Global Area (SGA) when using shared servers.
- D. PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
- E. The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
Xem thêm:
- SET AUTOTRACE ON Execution Plan – thông tin statics của câu lệnh sau khi thực thi trong sqlplus
- Các pha tắt database và instance – shutdown database
- So sánh Redo Log Bất đồng bộ và Đồng bộ trong Oracle Data Guard
- AAPanel là gì? Cài đặt AAPanel như thế nào?
- INTERVAL data types – Sử dụng kiểu dữ liệu INTERVAL trong Oracle Database
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?
