Where is Miss Smith?（）.._第1考题试题答案

第1题

[单选题] Examine the description of the EMPLOYEES table: Which statement produces the number of different departments that have employees with last name Smith?（）

A、SELECT COUNT(*) FROM employees WHERE last_name='Smith'; B、SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith'; C、SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith'; D、SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith'; E、SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';

点击查看答案

第2题

[单选题] 下列哪个语句查出雇员表（employees）里的雇员名字（ename）是‘SMITH’的信息，并且给雇员名字（ename）列定义一个别名Name（）。

A、select employeesno，ename Name，job from employees where ename=‘SMITH’ B、select employeesno，ename ‘Name’，job from employees where ename=SMITH C、select employeesno，ename “Name”，job from employees where ename=‘SMITH’ D、select employeesno，ename ‘Name’，job frome mployees wheree name=‘SMITH’

点击查看答案

第3题

[单选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?（）

A、UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180; B、UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180; C、UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180; D、UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180;

点击查看答案

第4题

[] Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（） Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（）

A、A.A B、B.B C、C.C D、D.D E、E.E

点击查看答案

第5题

[单选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid?（）

A、UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180; B、UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180; C、UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180; D、UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;

点击查看答案

第6题

[单选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid? （）

A、UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180; B、UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180; C、UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180; D、UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;

点击查看答案

第7题

[] Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（） Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）

A、A. SELECT COUNT (*) FROM employees WHERE last _name='smith'; B、B. SELECT COUNT (dept_id) FROM employees WHERE last _name='smith'; C、C. SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith'; D、D. SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith'; E、E. SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';

点击查看答案

第8题

[] Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith? （） Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith? （）

A、A. SELECT COUNT (*) FROM employees WHERE last _name='smith'; B、B. SELECT COUNT (dept_id) FROM employees WHERE last _name='smith'; C、C. SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith'; D、D. SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith'; E、E. SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';

点击查看答案

第9题

[] Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（） Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）

A、A.SELECT COUNT(*) FROM employees WHERE last_name='Smith'; B、B.SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith'; C、C.SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith'; D、D.SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith'; E、E.SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';

点击查看答案

Where is Miss Smith?（）

请使用微信扫码支付