未知题型
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
B, C
相关考题
-
未知题型
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." -
未知题型
YouaretheDatabaseAdministrator(DBA)ofyourcompany.YouexecutethefollowingstatementonanOracle10ginstance:SQL>ALTERSYSTEMSWITCHLOGFILE;Whichtwotasksareperformedwhenthestatementisexecuted?()
A.TheDBWnprocesswritestothedatafile.
B.Changesinthebackgroundprocessarerecorded.
C.ThelogfileisupdatedwiththecurrentSCNnumber.
D.TheSystemChangeNumber(SCN)isrecordedinthecontrolfile.
E.Thechangestothelistenerconfigurationinthelistener.orafilearerecorded.
