网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS 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, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN'; What are the minimum requirements for the statement to execute successfully? （）AARCHIVELOG mode must be enabledBRow Movement must be enabled for the tableCFLASHBACK must be set to ON for the databaseDThe UNDO_MANAGEMENT parameter must be set to AUTOEThe UNDO_RETENTION parameter must be set appropriately” 相关考题
考题
以下语句不正确的是( )A.select * from emp;B.select ename,hiredate,sal from emp;C.select * from emp order deptno;D.select * from where deptno=1 and sal
考题
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 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
考题
The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
考题
对于第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))
考题
A user executes a query on the EMP table， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal * ERROR at line 1： ORA/x7f01157： cannot identify/lock data file 201 /x7f see DBWR trace file ORA/x7f01110： data file 201： ’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）A、The tempfile belonging to the default temporary tablespace is missing.B、The database is opened in restricted mode， so queries are not allowed.C、The default temporary tablespace required to execute the query is offline.D、The default temporary tablespace required to execute the query is dropped.E、The default temporary tablespace required to execute the query is readonly.
考题
A user executes a query on the EMPtable， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL SELECT ename FROM emp WHERE deptno=10 ORDER BY sal； SELECT ename FROM emp WHERE deptno=10 ORDER BY sal ERROR at line 1： ORA-01157： cannot identify/lock data file 201 - see DBWR trace file ORA-01110： data file 201：’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）A、 The tempfile belonging to the default temporary tablespace is missing.B、 The database is opened in restricted mode， so queries are not allowedC、 The default temporary tablespace required to execute the query is offline.D、 The default temporary tablespace required to execute the query is dropped.E、 The default temporary tablespace required to execute the query is read-only.
考题
Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"? （）A、No change is required to achieve the desired results.B、SELECT ename, sal, 12* (sal+100) FROM emp;C、SELECT ename, sal, (12* sal)+100 FROM emp;D、SELECT ename, sal +100,*12 FROM emp;
考题
查询出所有名字以’S’开始的员工（）A、select * from emp where ename in 'S%';B、select * from emp where ename='S%';C、select * from emp where ename like 'S%';D、select * from emp where ename like 'S_';
考题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQ EMP_NAME and JOB_ID: As specified by the user during run time, throughsubstitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）A、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);B、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did IN (20,50));C、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);D、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);E、INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);
考题
The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A、SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;B、SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;C、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;D、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
考题
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（）A、LOCK TABLE emp IN SHARE MODE；B、LOCK TABLE emp IN EXCLUSIVE MODE；C、UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；
考题
The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS 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
考题
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）A、LOCK TABLE emp IN SHARE MODE；B、LOCK TABLE emp IN EXCLUSIVE MODE；C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
考题
The EMP table exists in your schema. You want to execute the following query： SELECT ename， sal FROM emp AS 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
考题
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command： SQL SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）A、LOCK TABLE emp IN SHARE MODE;B、LOCK TABLE emp IN EXCLUSIVE MODE;C、DELETE FROM emp WHERE job=’MANAGER’;D、INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;E、SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
考题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQEMP_NAME and JOB_ID: As specified by the user during run time, through substitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）A、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);B、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did IN (20,50));C、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);D、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);E、INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);
考题
多选题The EMP table exists in your schema. You want to execute the following query： SELECT ename， sal FROM emp AS OF TIMESTAMP （SYSTIMESTAMP - INTERVAL ’6’ MINUTE） WHERE ename = ’ALLEN’； What are the minimum requirements for the statement to execute successfully？（）AARCHIVELOG mode must be enabledBRow Movement must be enabled for the tableCFLASHBACK must be set to ON for the databaseDThe UNDO_MANAGEMENT parameter must be set to AUTOEThe UNDO_RETENTION parameter must be set appropriately
考题
单选题Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）A
No change is required to achieve the desired results.B
SELECT ename, sal, 12*(sal+100) FROM emp;C
SELECT ename, sal, (12*sal)+100 FROM emp;D
SELECT ename, sal+100,*12 FROM emp;
考题
单选题The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）A
The materialized view should have a complete refresh performed after the online table redefinition is completed.B
The materialized view should have a fast refresh performed after the online table redefinition is completed.C
The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.D
The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
考题
单选题The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A
SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;B
SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;C
SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;D
SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
考题
单选题查询出所有名字以’S’开始的员工（）A
select * from emp where ename in 'S%';B
select * from emp where ename='S%';C
select * from emp where ename like 'S%';D
select * from emp where ename like 'S_';
考题
单选题EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）A
Exhibit AB
Exhibit BC
The query returns no rowsD
The query fails because the outer query is retrieving more than one columnE
The query fails because both the inner and outer queries are retrieving data from the same table.
考题
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command： SQL SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）ALOCK TABLE emp IN SHARE MODE;BLOCK TABLE emp IN EXCLUSIVE MODE;CDELETE FROM emp WHERE job=’MANAGER’;DINSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;ESELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
考题
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（）ALOCK TABLE emp IN SHARE MODE；BLOCK TABLE emp IN EXCLUSIVE MODE；CUPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；DINSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；
考题
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）ALOCK TABLE emp IN SHARE MODE；BLOCK TABLE emp IN EXCLUSIVE MODE；CUPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？DINSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
考题
( 难度：中等)以下哪些Mysql语句是正确的？A.select * from emp; B.select ename,hiredate,sal from emp; C.select * from emp order deptno; D.select * from where deptno=1 and sal＜300;E.select * from where deptno=1 group by sal;
热门标签
最新试卷
