网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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 enabledB. Row Movement must be enabled for the tableC. FLASHBACK must be set to ON for the databaseD. The UNDO_MANAGEMENT parameter must be set to AUTOE. The UNDO_RETENTION parameter must be set appropriately ” 相关考题
考题
You’re going to have a quiz ( )by another two in the ( )month.
A. followed,followedB. followed,followingC. following,followedD. following,following
考题
Merry Christmas, George! Here is a card for ________, with ________ best withes.
A.you…yourB.you…ourC.us…ourD.us…your
考题
WhichthreevaluesarevalidparametersfortheDO_KEYbuilt－in?()
A.ENTERB.GO_ITEMC.VALIDATED.EXIT_FORME.EXECUTE_QUERY
考题
对于第7题的两个基本表，有一个SQL语句： SELECT ENO, ENAME FROM EMP WHERE DNO NOT IN (SELECT DNO FROM DEPT WHERE DNAME='金工车间');其等价的关系代数表达式是：______。A．πENO,ENAME(σDNAME≠'金工车间'(EMPDEPT))B．πENO,ENAMEC．πENO,ENAME(EMP)-πENO,ENAME (σDNAME='金工车间'(EMPDEPT))D．πENO,ENAME (EMP)-πENO,ENAME (σDNAME≠'金工车间'(EMPDEPT))
考题
在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;
考题
找出emp表中的dept表没有的dept_no 使用Exists方式实现 即改写select * from emp a where a.dept_no not in (select b.dept_no from dept b)
考题
（ ） – Is Miss White __________ English teacher, Maria?– No, she teaches __________ geography.A．your；myB．you；mineC．you；usD．your；us
考题
定义和emp表的ename具有相同数据类型的变量v_ename，正确的代码是A．v_ename ename %typeB．v_ename emp.ename %typeC．v_ename emp.ename typeD．v_ename emp.ename %rowtype
热门标签
最新试卷
