The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ‘6‘ MINUTE)WHERE ename = ‘ALLEN‘;What are the minimum requirements for the statement to execute successfully? （）

题目

The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ‘6‘ MINUTE)WHERE ename = ‘ALLEN‘;What are the minimum requirements for the statement to execute successfully? （）

A. ARCHIVELOG mode must be enabled

B. Row Movement must be enabled for the table

C. FLASHBACK must be set to ON for the database

D. The UNDO_MANAGEMENT parameter must be set to AUTO

E. The UNDO_RETENTION parameter must be set appropriately

相似考题

1.You’re going to have a quiz ( )by another two in the ( )month.A. followed,followedB. followed,followingC. following,followedD. following,following

2.Merry Christmas, George! Here is a card for ________, with ________ best withes.A.you…yourB.you…ourC.us…ourD.us…your

3.ContentResolver用什么方法查询Content Provider提供的内容()A.select()B.retrieve()C.query()D.execute()

4.What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you

参考答案和解析
参考答案：D, E
更多“The EMP table exists in your schema. You want to execute the following query:SELECT ename, ”相关问题

  • 第1题：

    WhichthreevaluesarevalidparametersfortheDO_KEYbuilt－in?()

    A.ENTER

    B.GO_ITEM

    C.VALIDATE

    D.EXIT_FORM

    E.EXECUTE_QUERY


    参考答案：A, D, E

  • 第2题：

    在PL／SQL中定义一个可以存放雇员表(EMP)的员工名称(ENAME)的PL／SQL表类型,应该()

    A.type array arr_type[emp.ename%type] index by binary_integer;

    B.type table arr_type[emp.ename%type] index by binary_integer;

    C.type arr_type is table of emp.ename%type index by binary_integer;

    D.type arr_type is pl_sql table of emp.ename%type index by binary_integer;


    参考答案：C

  • 第3题：

    （ ） – Is Miss White __________ English teacher, Maria?

    – No, she teaches __________ geography.

    A．your；my

    B．you；mine

    C．you；us

    D．your；us


    正确答案：D

  • 第4题：

    对于第7题的两个基本表，有一个SQL语句： SELECT ENO, ENAME FROM EMP WHERE DNO NOT IN (SELECT DNO FROM DEPT WHERE DNAME='金工车间');其等价的关系代数表达式是：______。

    A．πENO,ENAME(σDNAME≠'金工车间'(EMPDEPT))

    B．πENO,ENAME

    C．πENO,ENAME(EMP)-πENO,ENAME (σDNAME='金工车间'(EMPDEPT))

    D．πENO,ENAME (EMP)-πENO,ENAME (σDNAME≠'金工车间'(EMPDEPT))


    正确答案：C

  • 第5题：

    找出emp表中的dept表没有的dept_no 使用Exists方式实现 即改写select * from emp a where a.dept_no not in (select b.dept_no from dept b)


    正确答案：SELECT *   FROM EMP A  WHERE NOT EXISTS  
     (SELECT 1 FROM DEPT B WHERE A.DEPT_NO = B. DEPT_NO) 

  • 第6题：

    定义和emp表的ename具有相同数据类型的变量v_ename，正确的代码是

    A．v_ename ename %type

    B．v_ename emp.ename %type

    C．v_ename emp.ename type

    D．v_ename emp.ename %rowtype


    v_ename emp.ename %type

相关内容