未知题型
YouexecutedthefollowingcommandtocreateatablespacecalledSALES_DATA：>CREATETABLESPACEsales_dataDATAFILESIZE100MSEGMENTSPACEMANAGEMENTAUTO；WhichtwostatementsaretrueabouttheSALES_DATAtablespace（）
- A.Thedatabaseautomaticallydeterminestheextent-sizingpolicyforthetablespace.
B.Thesegmentsareautomaticallyshrunkwhenthecontentsareremovedfromthem.
C.Theallocationofextentswithinthetablespaceismanagedthroughthedictionarytables.
D.Thespaceutilizationdescriptionofthedatablocksinsegmentsisrecordedinbitmapblocks.
E.Thespaceutilizationdescriptionofthedatablocksinsegmentsismanagedthroughfreelists.MANUAL
A, D
相关考题
-
未知题型
Identifythetwosituationsinwhichyouusethealertlogfileinyourdatabasetocheckthedetails.（）
A.Runningaqueryonatablereturns"ORA-600：InternalError."
B.Insertingavalueinatablereturns"ORA-01722：invalidnumber."
C.Creatingatablereturns"ORA-00955：nameisalreadyusedbyanexistingobject."
D.Insertingavalueinatablereturns"ORA-00001：uniqueconstraint（SYS.PK_TECHP）violated."
E.Insertingarowinatablereturns"ORA-00060：deadlockdetectedwhilewaitingforresource." -
未知题型
YouaretheDatabaseAdministrator（DBA）ofyourcompany.YouexecutethefollowingstatementonanOracle10ginstance：SQL>ALTERSYSTEMSWITCHLOGFILE；Whichtwotasksareperformedwhenthestatementisexecuted？（）
A.TheDBWnprocesswritestothedatafile.
B.Changesinthebackgroundprocessarerecorded.
C.ThelogfileisupdatedwiththecurrentSCNnumber.
D.TheSystemChangeNumber（SCN）isrecordedinthecontrolfile.
E.Thechangestothelistenerconfigurationinthelistener.orafilearerecorded. -
未知题型
WhichtwostatementsaretrueabouttherolesintheOracledatabase？（）
A.Arolecanbegrantedtoitself.
B.RolesareownedbytheSYSuser.
C.Rolescanbegrantedtootherroles.
D.Arolecannotbeassignedexternalauthentication.
E.Arolecancontainbothsystemandobjectprivileges.
