Which SQL statement returns a numeric value?（）A、SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;B、SELECT ROUND(hire_date) FROM EMP;C、SELECT sysdate-hire_date FROM EMP;D、SELECT TO_NUMBER(hire_date + 7) FROM EMP;
Which SQL statement returns a numeric value?（）
- A、SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
- B、SELECT ROUND(hire_date) FROM EMP;
- C、SELECT sysdate-hire_date FROM EMP;
- D、SELECT TO_NUMBER(hire_date + 7) FROM EMP;
相关考题：
以下语句错误的是( )A.select sal+1 from emp;B.select sal*10,sal*deptno from emp;C.不能使用运算符号D.select sal*10,deptno*10 from emp;
以下语句不正确的是( )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
以下说法错误的是( )A.SELECT max(sal),deptno,job FROM EMP group by sal;B.SELECT max(sal),deptno,job FROM EMP group by deptno;C.SELECT max(sal),deptno,job FROM EMP;D.SELECT max(sal),deptno,job FROM EMP group by job;
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? （）A. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);B. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;C. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;D. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);E. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;
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;
取出工资在2000到3000元(包括上下限)之间的员工() A.select * from emp wher sal in (2000,3000);B.select * from emp wher sal like (2000,3000);C.select * from emp wher sal = (2000,3000);D.select * from emp wher sal between 2000 and 3000;
列出EMP表中,从事每个工种(JOB)的员工人数() A.select job from emp;B.select job,count(*) from emp;C.select distinct job,count(*) from emp;D.select job,count(*) from emp group by job;E.select job,sum(empno) from emp group by job;
限制从EMP表中只选出前5条记录的查语句为()。 A.SELECT TOP 5 * FROM EMPB.SELECT DISTINCT 5 * FROM EMPC.SELECT * FROM EMP WHERE ROWNUM6D.SELECT * FROM EMP WHERE ROWNUM=5
查询出EMP表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）A、select * from emp where hiredate='19820101';B、select * from emp where hiredate=to_char('19820101','YYYYMMDD');C、select * from emp where to_date(hiredate,'YYYYMMDD')='19820101';D、select * from emp where to_char(hiredate,'YYYYMMDD')='19820101';
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.Which SQL statement would you use to create the view EMP_VU?（）A、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);B、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;C、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;D、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);E、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;
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;
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;
The HR user creates a view with this command： SQL CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）A、HR can grant the privilege to JIM but without GRANT OPTION.B、HR can grant the privilege to JIM because HR is the owner of the view.C、SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.D、HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';B、SELECT last_name FROM EMP WHERE last name ='*A%'C、SELECT last_name FROM EMP WHERE last name ='_A%';D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'
取出工资在2000到3000元（包括上下限）之间的员工（）A、select * from emp wher sal in (2000,3000);B、select * from emp wher sal like (2000,3000);C、select * from emp wher sal = (2000,3000);D、select * from emp wher sal between 2000 and 3000;
查询出所有名字以’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_';
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;
The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A、Alice onlyB、Alice and ReenaC、Alice, Reena, and TimberD、Sue, Alice, Reena, and Timber
限制从EMP表中只选出前5条记录的查语句为（）。A、SELECT TOP 5 * FROM EMPB、SELECT DISTINCT 5 * FROM EMPC、SELECT * FROM EMP WHERE ROWNUM6D、SELECT * FROM EMP WHERE ROWNUM=5
列出EMP表中，从事每个工种（JOB）的员工人数（）A、select job from emp;B、select job,count(*) from emp;C、select distinct job,count(*) from emp;D、select job,count(*) from emp group by job;E、select job,sum(empno) from emp group by job;
单选题The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）ArandomlyBascending by dateCdescending by dateDascending alphabeticallyEdescending alphabetically
单选题The HR user creates a view with this command： SQL CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）AHR can grant the privilege to JIM but without GRANT OPTION.BHR can grant the privilege to JIM because HR is the owner of the view.CSCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.DHR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
单选题You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? （）ACREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);BCREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;CCREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;DCREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);ECREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;
单选题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.
单选题Which SQL statement returns a numeric value?（）ASELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;BSELECT ROUND(hire_date) FROM EMP;CSELECT sysdate-hire_date FROM EMP;DSELECT TO_NUMBER(hire_date + 7) FROM EMP;
( 难度：中等)以下哪些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;