单项选择题
Observe the information in the columns:
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
Which option has the correct match between the memory areas and their contents()
A.1-c, 2-b, 3-d, 4-a
B.1-b, 2-c, 3-d, 4-a
C.1-a, 2-b, 3-c, 4-d
D.1-a, 2-b, 3-d, 4-c
相关考题
-
单项选择题
Identify the memory component from which memory may be allocated for:() 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager (RMAN) backup and restore operations
A.Large Pool
B.Redo Log Buffer
C.Database Buffer Cache
D.Program Global Area (PGA) -
单项选择题
Inyourdatabaseinstance,theusersessionsareconnectedtothedatabaseserverfromtheremotemachines.Youwanttoachievethefollowingfortheseusers: 1.Theuseraccountmustbelockedafterfourunsuccessfulloginattempts. 2.Theusermustbepromptedtochangethepasswordatregularintervals. 3.Theusermaynothavemorethanthreesimultaneoussessions. 4.Theusersessionmustautomaticallybeloggedoffifmorethan10minuteselapsedtimeused. Howwouldyouaccomplishtheabove()
A.By assigning profiles for the users
B.By implementing Fine-Grained Auditing (FGA)
C.By granting a secure application role to the users
D.By implementing the Database Resource Manager plan -
单项选择题
Note the following points describing various utilities in Oracle Database 1g:1. It enables the high-speed transfer of data from one database to another. 2. It provides a complete solution for the backup, restoration, and recovery needs of the entire database.3. It enables the loading of data from an external file into an Oracle database.4. It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup()
A.1
B.2
C.3
D.4
E.1, 2, and 4
F.1, 2, 3, and 4
