单项选择题

In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）

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

单项选择题Inordertofindouthowmanydatabaseobjectsauserhascreated,whichviewwouldtheDBAqueryintheOracledatadictionary?（）

A.DBA_USERS
B.DBA_OBJECTS
C.DBA_TS_QUOTAS
D.DBA_TAB_PRIVS