未知题型
Evaluatethefollowingcommandanditsoutput：SQL>SELECT*FROMdba_temp_free_space；TABLESPACE_NAMETABLESPACE_SIZEALLOCATED_SPACEFREE_SPACELMTEMP250609664101048576149561088Whichtwostatementscorrectlyinterprettheoutput？（）
A.FREE_SPACEindicatesonlythespacethatiscurrentlyunallocated.
B.ALLOCATED_SPACEindicatesonlythespacecurrentlyallocatedandinuse.
C.FREE_SPACEindicatesonlythespacethatiscurrentlyallocatedandavailableforreuse.
D.ALLOCATED_SPACEindicatesboththespacecurrentlyallocatedandused，andthespacethat isavailableforreuse.
E.FREE_SPACEindicatesboththespacethatiscurrentlyallocatedandavailableforreuse，andthespacethatiscurrentlyunallocated.
- A.FREE_SPACEindicatesonlythespacethatiscurrentlyunallocated.
B.ALLOCATED_SPACEindicatesonlythespacecurrentlyallocatedandinuse.
C.FREE_SPACEindicatesonlythespacethatiscurrentlyallocatedandavailableforreuse.
D.ALLOCATED_SPACEindicatesboththespacecurrentlyallocatedandused，andthespacethat
E.
F.FREE_SPACEindicatesboththespacethatiscurrentlyallocatedandavailableforreuse，andthespacethatiscurrentlyunallocated.
D, E
相关考题
-
未知题型
Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile？（）
A.DB_CREATE_FILE_DEST
B.DB_RECOVERY_FILE_DEST
C.DB_RECOVERY_FILE_DEST_SIZE
D.DB_ONLINE_LOG_DEST_n -
未知题型
YouexecutedthefollowingcommandtocreateatablespacecalledSALES_DATA：>CREATETABLESPACEsales_dataDATAFILESIZE100MSEGMENTSPACEMANAGEMENTAUTO；WhichtwostatementsaretrueabouttheSALES_DATAtablespace（）
A.Thedatabaseautomaticallydeterminestheextent-sizingpolicyforthetablespace.
B.Thesegmentsareautomaticallyshrunkwhenthecontentsareremovedfromthem.
C.Theallocationofextentswithinthetablespaceismanagedthroughthedictionarytables.
D.Thespaceutilizationdescriptionofthedatablocksinsegmentsisrecordedinbitmapblocks.
E.Thespaceutilizationdescriptionofthedatablocksinsegmentsismanagedthroughfreelists.MANUAL -
未知题型
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."
