网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
考题
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
考题
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;
考题
列出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?（）A
randomlyB
ascending by dateC
descending by dateD
ascending alphabeticallyE
descending alphabetically
考题
单选题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
考题
单选题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 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;
考题
单选题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?（）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;
考题
( 难度：中等)以下哪些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;
热门标签
最新试卷
