单项选择题
Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()
A. use DBMS_IJOB package
B. use Oracle Scheduler
C. use DBMS_JOB package
D. use Oracle Data Pump Export and Import
相关考题
-
单项选择题
Amediafailurehasoccurred.Thishasresultedinallthemembersofthenextloggroupbeingrenderedinaccessibletothelogwriterprocess(LGWR)atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase?()
A. The database allows only queries; no other statements are allowed.
B. The database re-creates the missing redo log files automatically.
C. The database continues to function normally with the existing files.
D. The database returns an error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically. -
单项选择题
TheEMPLOYEEStableisstoredintheUSERStablespace.YouneedtocheckiftheEMPLOYEEStableisaffectedbytheblockcorruptionfoundintheUSERStablespace.Whichoptionwouldyouuse?()
A. the RMAN LIST command
B. the DBNEWID utility
C. the RMAN REPORT command
D. the RMAN BLOCKRECOVER command
E. the RMAN CROSSCHECK command
F. the ANALYZE command -
单项选择题
YouareworkingonanOracleDatabase10gdatabasethatoperatesintheARCHIVELOGmode.At06:00p.m.,youdiscoveredthatatableintheSYSTEMtablespacethatdoesnotbelongtothedatadictionarywasdroppedat03:00p.m.Whatwouldyoudotorecoverthetable?()
A. use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
B. restore the entire database from the most recent backup and open it
C. recover the table by using the Flashback Table feature
D. perform point-in-time recovery to recover the table
