单项选择题
You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?()
A.LOGICAL_READS_PER_SESSION
B.CONNECT_TIME
C.COMPOSITE_LIMIT
D.CPU_PER_SESSION
E.PRIVATE_SGA
点击查看答案
相关考题
-
单项选择题
Inasituationwherenomultiplexingofredologstakesplace,whathappenswhenOraclecannotreaddatafromtheonlineredologgroupforarchiving?()
A.Nothing happens
B.Oracle will automatically switch redo logs when detected
C.Oracle eventually won't allow new records to be added to the database
D.The instance crashes -
单项选择题
YouareanalyzinghowOracleprocessesuserstatements.SQLandPL/SQLparseinformationisstoredinwhichofthefollowingdatabasememoryareas?()
A.Library cache
B.Row cache
C.Dictionary cache
D.Large area
E.Buffer cache -
单项选择题
Youaredesigningthephysicaldatabaselayoutonyourhostmachine.WhatistherelationshipbetweentablespacesanddatafilesintheOracledatabase?()
A.One tablespace has only one datafile
B.Many tablespaces can share one datafile
C.One tablespace can have many datafiles
D.One datafile can contain many tablespaces
