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

The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.<br /> Which two statements about the results of the query shown in the Exhibit are correct? （）(Choose two.)<br /> <img src="https://nimg.ppkao.com/2018-08/ppweb/2018080117074551346.png?sign=3b290294f8feff0ebb6967dbaa2f2ef2&t=62d33e07" />

A、The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300.

B、The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.

C、The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.

D、The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.

查看正确答案
更多“ The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.<br /> Which two statements about the results of the query shown in the Exhibit are correct? （）(Choose two.)<br /> <img src="https://nimg.ppkao.com/2018-08/ppweb/2018080117074551346.png?sign=3b290294f8feff0ebb6967dbaa2f2ef2&t=62d33e07" />”相关的问题
第1题
[] Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: Which statement ensures that a value is displayed in the calculated columns for all employees?（） Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: Which statement ensures that a value is displayed in the calculated columns for all employees?（）

A、A. SELECT last_name, 12*salary* commission_pct FROM emp;&nbsp;&nbsp;B、B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;&nbsp;&nbsp;C、C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;&nbsp;&nbsp;D、D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;&nbsp;&nbsp;

点击查看答案
第2题
[] 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;&nbsp;&nbsp;B、B. SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;&nbsp;&nbsp;C、C. SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;&nbsp;&nbsp;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&nbsp;&nbsp;E、E. None of the statements produce an error; all are valid.&nbsp;&nbsp;

点击查看答案
第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.&nbsp;&nbsp;B、The SQL* Loader data file myfile1.dat has the column names for the EMP table.&nbsp;&nbsp;C、The SQL* Loader operation fails because no record terminators are specified.&nbsp;&nbsp;D、Field names should be the first line in the both the SQL* Loader data files.&nbsp;&nbsp;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.&nbsp;&nbsp;

点击查看答案
第4题
[单选题] 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);&nbsp;&nbsp;B、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));&nbsp;&nbsp;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));&nbsp;&nbsp;D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));&nbsp;&nbsp;

点击查看答案
第5题
[单选题] 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);&nbsp;&nbsp;B、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));&nbsp;&nbsp;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));&nbsp;&nbsp;D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));&nbsp;&nbsp;

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

点击查看答案
第7题
[单选题] Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）

A、SELECT last_name, 12*salary* commission_pct FROM emp;&nbsp;&nbsp;B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;&nbsp;&nbsp;C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;&nbsp;&nbsp;D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;&nbsp;&nbsp;

点击查看答案
第8题
[单选题] Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees? （）

A、SELECT last_name, 12*salary* commission_pct FROM emp;&nbsp;&nbsp;B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;&nbsp;&nbsp;C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;&nbsp;&nbsp;D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;&nbsp;&nbsp;

点击查看答案
第9题
[多选题] You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）

A、Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.&nbsp;&nbsp;B、Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.&nbsp;&nbsp;C、Data is never redacted for the EMP_V.SAL column.&nbsp;&nbsp;D、Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.&nbsp;&nbsp;E、Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.&nbsp;&nbsp;

点击查看答案
第10题
[] User&ensp;SCOTT&ensp;executes&ensp;the&ensp;following&ensp;command&ensp;on&ensp;the&ensp;EMP&ensp;table&ensp;but&ensp;has&ensp;not&ensp;issued&ensp;COMMIT，&ensp;ROLLBACK，&ensp;or&ensp;any&ensp;data&ensp;definition&ensp;language&ensp;（DDL）&ensp;command：&ensp;SQL>&ensp;SELECT&ensp;ename&ensp;FROM&ensp;emp&ensp; 2&ensp;WHERE&ensp;job=&rsquo;CLERK&rsquo;&ensp;FOR&ensp;UPDATE&ensp;OF&ensp;empno；&ensp; SCOTT&ensp;has&ensp;opened&ensp;another&ensp;session&ensp;to&ensp;work&ensp;with&ensp;the&ensp;database&ensp;instance.&ensp; Which&ensp;three&ensp;operations&ensp;wouldwait&ensp;when&ensp;issued&ensp;in&ensp;SCOTT&rsquo;s&ensp;second&ensp;session（） User&ensp;SCOTT&ensp;executes&ensp;the&ensp;following&ensp;command&ensp;on&ensp;the&ensp;EMP&ensp;table&ensp;but&ensp;has&ensp;not&ensp;issued&ensp;COMMIT，&ensp;ROLLBACK，&ensp;or&ensp;any&ensp;data&ensp;definition&ensp;language&ensp;（DDL）&ensp;command：&ensp;SQL>&ensp;SELECT&ensp;ename&ensp;FROM&ensp;emp&ensp; 2&ensp;

A、A.LOCK&ensp;TABLE&ensp;emp&ensp;IN&ensp;SHARE&ensp;MODE；&nbsp;&nbsp;B、B.LOCK&ensp;TABLE&ensp;emp&ensp;IN&ensp;EXCLUSIVE&ensp;MODE；&nbsp;&nbsp;C、C.UPDATE&ensp;emp&ensp;SET&ensp;sal=sal*1.2&ensp;WHERE&ensp;job=MANAGER；&nbsp;&nbsp;D、D.INSERT&ensp;INTO&ensp;emp（empno，ename）&ensp;VALUES&ensp;（1289，&rsquo;Harry&rsquo;）；&nbsp;&nbsp;E、E.SELECT&ensp;ename&ensp;FROM&ensp;emp&ensp;WHERE&ensp;job=&rsquo;CLERK&rsquo;&ensp;FOR&ensp;UPDATE&ensp;OF&ensp;empno；&nbsp;&nbsp;

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

请使用微信扫码支付

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