单项选择题

A.Library cache B.Row cache C.Session UGA D.Buffer cach……

Records from the data dictionary information are stored in which of the following database memory areas?（）

A.Library cache
B.Row cache
C.Session UGA
D.Buffer cache

<上一题目录下一题>

热门试题

单项选择题Ifyouwantedtofindthenameandlocationofyourcontrolfiles,youcouldfindthatinformationineachofthefollowinglocationsexceptone.Whichisit?（）

A.V_CONTROLFILE_RECORD_SECTION
B.V_CONTROLFILE
C.V$PARAMETER
D.init.ora file

单项选择题InordertoenableremoteadministrationofusersandtablespacesonanOracledatabase,whichofthefollowingtypesoffilesmustexistinthedatabase?（）

A.Password file
B.Initialization file
C.Datafile
D.Control file
E.Nothing - SYSDBA privileges are not required for these actions

单项选择题Youaretryingtoaltertheinitialsegmentsizegiventoatableinadictionary-managedtablespace.Whichofthefollowingkeywordswouldbeusedaspartofthisprocess?（）

A.DROP TABLE
B.ALTER TABLE
C.RESIZE
D.COALESCE

单项选择题Yourapplicationregularlyissuesthefollowingstatement:SELECT*FROMBANK_ACCTWHEREACCT_BALANCEBETWEEN1000and10000;Whichofthefollowingdatabaseobjectswouldbeinappropriateforusewiththisstatement?（）

A.Materialized views
B.Indexes
C.Index-organized tables
D.Hash clusters

单项选择题Youareattemptingtoincreasethecheckpointintervalonyourdatabase.Eachofthefollowingchoiceswillaffectthedurationand orfrequencyofcheckpoints,exceptone.Whichisit?（）

A.Size of redo logs
B.Number of datafiles
C.LOG_CHECKPOINT_INTERVAL
D.LOG_CHECKPOINT_TIMEOUT