单项选择题
There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（）
A. the DBNEWID utility
B. the DBVERIFY utility
C. the ANALYZE command
D. the RMAN REPORT command
E. the RMAN CROSSCHECK command
F. the CHECK_OBJECT procedure of the DBMS_REPAIR package
相关考题
-
多项选择题
ThelossofwhichtwotypesoffilesmayrequirearecoverywiththeRESETLOGSoption？（）
A. control files
B. password file
C. archived log files
D. system-critical data files for which all the redo entries are present
E. non-system-critical data files for which all the redo entries are present -
多项选择题
YouwanttousetheSQLTuningAdvisortogeneraterecommendationsforbadlywrittenSQLstatementsinyourdevelopmentenvironment.Whichthreesourcescanyouselectfortheadvisortoanalyze？（）
A. Top SQL
B. snapshots
C. SQL Tuning sets
D. index access path
E. optimizer statistics
F. materialized view logs -
单项选择题
YouaremanaginganOracleDatabase10gdatabasethatusesOracleManagedFiles（OMF）.Youenabledtheblockchangetrackingfeatureforthedatabase.Whichstatementregardingthechangetrackingfileistrue？（）
A. One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.
B. One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.
C. One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.
D. One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
