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
单项选择题YouareaddingredologstotheOracledatabase.CreatinganewredologaddsinformationtowhichofthefollowingOracleresources?()
A.Shared pool B.Control file C.SGA D.PGA