单项选择题

Observe the information in the columns： 1. The SGA a. T……

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

单项选择题You executed the following command to perform a backup of the USERS tablespace：SQL> ALTER TABLESPACE users BEGIN BACKUP；ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）

A.The MTTR Advisor is disabled.
B.The database is in NOARCHIVELOG mode.
C.The tablespace is already in backup mode.
D.The Flash Recovery Area is not configured

单项选择题The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code， which is the primary key.As part of the archival process， the company wants to transfer therows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of theyear. Along with existing products， the company deals with many new products during every quarter. Whichmethod is best suited for this quarterly data transfer（）

A.Using the MERGE command
B.Using the SQL*Loader utility
C.Using the correlated UPDATE command
D.Using the INSERT command to perform bulk operation