问题

Examine the following commands and their output:SQL> SELECT ename sal FROM emp WHERE e

Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View 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.

参考答案

您可能感兴趣的试题

听力原文：The man packed to serve as the top US commander in the Middle East faced an equal

答案解析
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?（）

答案解析
Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’ ‘CUSTOMERS’ ‘PUBLISH’ ‘false’);Which three statements are true about the effect of this command?()

答案解析
An AIX system has a rootvg plus a separate volume group for database application. Which of the following commands are sued to backup the entire system?()

答案解析
Which of the following sequence of commands extracts the third image from a tape that was created using the backup command?()

答案解析
Multiple RMAN sessions are connected to the database instance.Examine the following output

答案解析

Examine the following commands and their output:SQL&gt; SELECT ename sal FROM emp WHERE e

Examine the following commands and their output:SQL> SELECT ename sal FROM emp WHERE e