易搜题 > 资格证大类 > 计算机编程 > 问题详情
问题详情

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)?() 

    A

     Redo logs 

    B

     Control file

    C

     The latest backup of only the damaged data file

    D

     The latest backup of all the data file in the USERS tablespace

    E

     Temporary files of temporary tablespace

    F

     Archive 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?() 

    A

     SYSTEM

    B

     SYSAUX

    C

     UNDO

    D

     USERS

    E

     TEMP

    F

     This restore is not possible

  • Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?() 

    A

     Database datafiles

    B

     Control files

    C

     Archived redo logs

    D

     Online redo logs

    E

     Flashback logs

  • Which two statements are true regarding hot patching?()

    A

     It requires relinking of the Oracle binary.

    B

     It does not require database instance shutdown.

    C

     It can detect conflicts between two online patches.

    D

     It is available for installing all patches on all platforms. 

    E

     It works only in a single database instance environment.

联系客服 会员中心
TOP