Examine the following commands and their output: View the exhibit and examine the Flashback Version Query that was executed after the preceding commands. What could be the possible cause for the query not displaying any row?()
A、 Flashback logging is not enabled for the database.
B、 The changes made to the table are not committed.
C、 Supplemental logging is not enabled for the database.
D、 The database is not configured in ARCHIVELOG mode.
相关问题推荐
-
Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
ARedo logs
BControl file
CThe latest backup of only the damaged data file
DThe latest backup of all the data file in the USERS tablespace
ETemporary files of temporary tablespace
FArchive Logs since the latest backup to point of failure
-
Which command will result in a trace file being created with the create controlfile command contained in it?()
A、 alter database backup controlfile
B、 alter database backup controlfile to trace
C、 alter database controlfile backup
D、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
E、 alter database begin controlfile backup
-
You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task?()
ASYSTEM
BSYSAUX
CUNDO
DUSERS
ETEMP
FThis restore is not possible
-
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?()
ADatabase datafiles
BControl files
CArchived redo logs
DOnline redo logs
EFlashback logs
-
Which two statements are true regarding hot patching?()
AIt requires relinking of the Oracle binary.
BIt does not require database instance shutdown.
CIt can detect conflicts between two online patches.
DIt is available for installing all patches on all platforms.
EIt works only in a single database instance environment.