单项选择题
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.
单项选择题 You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended?()
单项选择题 Inyourtestdatabase,youfindthatauser’ssessionisexecutingalotofSQLstatements,resultinginthegenerationofalargenumberoftracefiles.Whileinvestigatingthereason,youfindthatSQLtracehasbeenenabledattheinstancelevel.YouwanttodisableSQLtrace,remotely,onlyforthatusersessiontoreducethevolumeoftracedatabeinggenerated.Howdoyouachievethisobjective?()
多项选择题 You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE ?5/24); Which two statements are true? ()