8. Observe the information in the columns:
Which option has the correct match between the memory areas and their contents?
A.1-c, 2-b, 3-d, 4-a
B.1-c, 2-b, 3-d, 4-a
C.1-a, 2-b, 3-c, 4-d
D.1-a, 2-b, 3-d, 4-c
Answer: C
1: The SGA | a. Text and parsed forms of all SQL statements |
2: The cursor state | b. Run-time memory values for the SQL statement, such as rows retrieved |
3: User-session data | c. Security and resource usage information |
4: The stack space | d. Local variables for the process |
A.1-c, 2-b, 3-d, 4-a
B.1-c, 2-b, 3-d, 4-a
C.1-a, 2-b, 3-c, 4-d
D.1-a, 2-b, 3-d, 4-c
Answer: C