单项选择题
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-c,2-b,3-c,4-a
C.1-a,2-b,3-c,4-d
D.1-a,2-b,3-d,4-c
相关考题
-
单项选择题
You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database: 1:SGA is allocated. 2:Control file is read. 3:Redo log files are read. 4:Instance recovery is started. 5:Background processes are started. 6:Data files are checked for consistency. 7:Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()
A.7,1,5,2,3,6,4
B.1,2,3,7,5,6,4
C.7,1,4,5,2,3,6
D.1,7,5,4,2,3,6 -
单项选择题
NotethefollowingpointsdescribingvariousutilitiesinOracleDatabase11g: 1:Itenablesthehigh-speedtransferofdatafromonedatabasetoanother. 2:Itprovidesacompletesolutionforthebackup,restoration,andrecoveryneedsoftheentiredatabase. 3:ItenablestheloadingofdatafromanexternalfileintoanOracledatabase. 4:ItprovidesatapebackupmanagementfortheOracleecosystem.WhichpointdescribesOracleSecureBackup()
A.1
B.2
C.3
D.4
E.1,2,and 4
F.1,2,3,and 4 -
单项选择题
ThedatabaseinstanceiscurrentlyusingSPFILE.ViewtheExhibitandexaminetheerrorthatyoureceivedwhilerunningtheDBStructureIntegritycheck. Givenbelowarethestepstorecoverfromtheerrorinrandomorder: 1:Shutdowntheinstance,ifnotalreadydone. 2:Copyoneoftheremainingcontrolfilestoanewlocation. 3:ChangethevalueoftheCONTROL_FILESinitializationparametertocorrespondtothenewlocationofthecontrolfiles. 4:StartupthedatabaseinstancetotheNOMOUNTstage. 5:Recoverthedatabasetothepointoffailureofthecontrolfile. 6:Openthedatabase. Identifythecorrectsequenceofsteps()
A.1,2,4,3,5,6
B.2,4,3,5,6;1 not required
C.4,5,6,2,3;1 not required
D.5,2,3,4;1 and 6 not required
