多项选择题
Which two statements are correct regarding the Flashback Versions Query feature？（）
A. You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
B. You can use this feature to identify the versions of V$ views.
C. You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
D. You can use this feature for a table only if row movement is enabled for the table.
E. You can use this feature to identify the versions of external and fixed tables.
相关考题
-
多项选择题
YouexecutedthefollowingFLASHBACKTABLEcommand：FLASHBACKTABLEempTOTIMESTAMP（’11：45’，’hh12：mi’）；Whichtwostatementsarecorrect？（）
A. The FLASHBACK TABLE statement will not be written to the alert log file.
B. The EMP table that was dropped by mistake from the database will be restored.
C. The changes made to the EMP table since the specified time will be undone.
D. The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
E. The FLASHBACK TABLE statement will be executed within a single transaction.
F. The list of transactions that have modified the EMP table since the specified time will be displayed. -
单项选择题
EverySunday，consistentbackupsareperformedonyourdatabase.Becauseofausererror，you performedanincompleterecoveryonTuesdayandopenedthedatabasewiththeRESETLOGSoption.AusererroroccursagainonThursday，whichnecessitatesanincompleterecovery.Sunday’sbackupisthemostrecentbackupavailable.Whatwouldyoudointhisscenario？（）
A. recovery cannot be performed because a backup was not performed after the last incomplete recovery
B. restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
C. restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday
D. restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday -
单项选择题
Thelossofthecontrolfileforcedyoutore-createthecontrolfile.Afterre-creatingitandopeningthedatabase，youfindthatsomeofthedatafilesarenamedasMISSINGnnnnn，wherennnnnisafive-digitnumberstartingwith0.Whatcouldbethepossiblereason？（）
A. These are the data files that are corrupted.
B. There is no SYSAUX tablespace in your database
C. There is a read-only tablespace in your database.
D. These are the data files that cannot be recovered.
