单项选择题

The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）

A.ALTER USER DEFAULT ROLE ALL
B.ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1
C.ALTER USER DEFAULT ROLE NONE
D.ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1

<上一题目录下一题>

热门试题

单项选择题YouaredefiningareasonyourOracledatabase.Whichofthefollowingprofileareascanbeusedtocontroltheresourceusagefortheotherfour?（）

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

单项选择题Duringregulardatabaseoperation,whichbackgroundprocesswilltakesmallerblocksoffreespaceinadictionary-managedtablespaceandmovethingsaroundtomakebiggerpiecesoffreespace?（）

A.DBW0
B.LGWR
C.ARCH
D.SMON
E.PMON