单项选择题
You executed the following query：
SELECT operation， undo_sql， table_name FROM flashback_transaction_query；
Which statement is correct regarding the query output？（）
A. It would return information regarding only the last committed transaction.
B. It would return only the active transactions in all the undo segments in the database.
C. It would return only the committed transactions in all the undo segments in the database.
D. It would return both active and committed transactions in all the undo segments in the database.
E. It would return information regarding the transactions that began and were committed in the last 30 minutes.
相关考题
-
多项选择题
YouareworkingonanOracleDatabase10gdatabase.YouenabledtheFlashbackDatabasefeature.Whichtwostatementsregardingflashbacklogsaretrue？（）
A. Flashback logs are not archived.
B. Flashback logs are maintained in redo log files.
C. Flashback logs are maintained in the Flash Recovery Area.
D. Flashback logs are used to maintain Flashback Database related errors.
E. Flashback logs need to be cleared manually after you disable Flashback Database. -
单项选择题
You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file and all the archived logs are accessible. Which option would you choose？（）
A. flash back the corrupted blocks
B. use the DBMS_REPAIR package
C. use the RMAN TSPITR command
D. use the RMAN BLOCKRECOVER command
E. use the RESTORE DATABASE and RECOVER DATABASE commands
F. investigate the time at which the corruption occurred and perform a point-in-time recovery -
多项选择题
Thecurrenttimezoneforoneoftheusersessionsissettothedatabaselocaltimezone.Foroneapplication，theusersessionrequiresthetimezonetobesettothelocaloperatingsystemtimezonewithoutaffectingotherusersessions.Whichtwosolutionscouldtheuserimplementtoachievethisobjective？（）
A. use the ALTER SYSTEM command to change the time zone
B. use the ALTER SESSION command to change the time zone
C. use the ALTER DATABASE command to change the time zone
D. set the value for the operating system variable ORA_SDTZ on the client machine
E. set the value for the operating system variable ORA_SDTZ on the database server machine
