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:
- Q136. Examine this configuration: PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully
- Các công cụ quản trị Oracle Net Services
- Q143 Which statement is true about database links?
- Quản lý ứng dụng trong môi trường Oracle Multitenant Application Root Application PDB
- Q107. Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c?
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?
