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

The EMP table has these columns:<br /> ENAME VARCHAR2(35)<br /> SALARY NUMBER(8,2)<br /> HIRE_DATE DATE<br /> Management wants a list of names of employees who have been with the company for more than five years.<br /> 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;

查看正确答案
更多“ The EMP table has these columns:<br /> ENAME VARCHAR2(35)<br /> SALARY NUMBER(8,2)<br /> HIRE_DATE DATE<br /> Management wants a list of names of employees who have been with the company for more than five years.<br /> Which SQL statement displays the required results?（）”相关的问题
第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;  B、B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;  C、C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;  D、D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;  

点击查看答案
第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;  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) &gt; 20000  E、E. None of the statements produce an error; all are valid.  

点击查看答案
第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题
[单选题] 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));  

点击查看答案
第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);  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));  

点击查看答案
第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  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.  

点击查看答案
第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;  B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;  C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;  D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;  

点击查看答案
第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;  B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;  C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;  D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;  

点击查看答案
第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.  B、Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.  C、Data is never redacted for the EMP_V.SAL column.  D、Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.  E、Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.  

点击查看答案
第10题
[多选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER\ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.  B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.  C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.  D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.  E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.  F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.  

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

请使用微信扫码支付

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