搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

The EMP table exists in your schema. You want to execute the following query:<br /> SELECT ename, sal<br /> FROM emp<br /> AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL &#39;6&#39; MINUTE)<br /> WHERE ename = &#39;ALLEN&#39;;<br /> 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:<br /> SELECT ename, sal<br /> FROM emp<br /> AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL &#39;6&#39; MINUTE)<br /> WHERE ename = &#39;ALLEN&#39;;<br /> What are the minimum requirements for the statement to execute successfully? （）”相关的问题
第1题
[单选题] You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema. You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table: SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP; What would be the outcome of the precedent statement?（）

A、It retrieves the latest version of the table from the recycle bin  B、It retrieves the oldest version of the table from the recycle bin  C、It retrieves the version of the table for which undo information is available  D、It returns an error because the table name is not specified as per the names in the OBJECT_NAME column  

点击查看答案
第2题
[单选题] You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table: SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP; What would be the outcome of the precedent statement?（）

A、It retrieves the latest version of the table from the recycle bin  B、It retrieves the oldest version of the table from the recycle bin  C、It retrieves the version of the table for which undo information is available  D、It returns an error because the table name is not specified as per the names in the OBJECT_NAME column  

点击查看答案
第3题
[多选题] Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）

A、An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.  B、The SQL* Loader data file myfile1.dat has the column names for the EMP table.  C、The SQL* Loader operation fails because no record terminators are specified.  D、Field names should be the first line in the both the SQL* Loader data files.  E、The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.  

点击查看答案
第4题
[多选题] You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）

A、The FLASHBACK TABLE statement will not be written to the alert log file.  B、The changes made to the EMP table since the specified time will be undone.  C、The EMP table that was dropped by mistake from the database will be restored.  D、The FLASHBACK TABLE statement will be executed within a single transaction.  E、The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.   F、The list of transactions that have modified the EMP table since the specified time will be displayed.  

点击查看答案
第5题
[] View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table：   ALTER TABLE emp   ADD CONSTRAINT emp_id_pk  PRIMARY KEY （emp_id）   USING INDEX emp_id_idx；   Which statement is true regarding the effect of the command？（） View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table：

A、A. The PRIMARY KEY is created along with a new index.  B、B. The PRIMARY KEY is created and it would use an existing unique index.  C、C. The PRIMARY KEY would be created in a disabled state because it is using an existing index.  D、D. The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.  

点击查看答案
第6题
[多选题] You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）

A、 The FLASHBACK TABLE statement will not be written to the alert log file.  B、 The EMP table that was dropped by mistake from the database will be restored.  C、 The changes made to the EMP table since the specified time will be undone.  D、 The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.  E、 The FLASHBACK TABLE statement will be executed within a single transaction.  F、 The list of transactions that have modified the EMP table since the specified time will be displayed.  

点击查看答案
第7题
[] Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（） Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）

A、A. SELECT * FROM emp_dept_vu;  B、B. SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;  C、C. SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;  D、D. SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000  E、E. None of the statements produce an error; all are valid.  

点击查看答案
第8题
[单选题] Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）

A、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);  B、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));  C、CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));  D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));  

点击查看答案
第9题
[单选题] Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? （）

A、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);  B、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));  C、CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));  D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));  

点击查看答案
第10题
[单选题] 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 A  B、Exhibit B  C、The query returns no rows  D、The query fails because the outer query is retrieving more than one column  E、The query fails because both the inner and outer queries are retrieving data from the same table.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服