SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
SELECT last_name FROM EMP WHERE last name ='*A%'
SELECT last_name FROM EMP WHERE last name ='_A%';
SELECT last_name FROM EMP WHERE last name LIKE '*A%'
第1题:
The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?()
第2题:
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?()
第3题:
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?()
第4题:
Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? ()
第5题:
The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement? ()
第6题:
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?()
第7题:
The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.
第8题:
SELECT last_name FROM EMP WHERE last_name LIKE ‘_A%’;
SELECT last_name FROM EMP WHERE last name =’*A%’
SELECT last_name FROM EMP WHERE last name =’_A%’;
SELECT last_name FROM EMP WHERE last name LIKE ‘*A%’
第9题:
The two statements produce identical results.
The second statement returns a syntax error.
There is no need to specify DESC because the results are sorted in descending order by default.
The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
第10题:
The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.
第11题:
SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
SELECT last_name FROM EMP WHERE last name ='*A%'
SELECT last_name FROM EMP WHERE last name ='_A%';
SELECT last_name FROM EMP WHERE last name LIKE '*A%'
第12题:
The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.
第13题:
Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?()
第14题:
The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?()
第15题:
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? ()
第16题:
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? ()
第17题:
The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement?()
第18题:
The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?()
第19题:
SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;
SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
第20题:
SELECT COUNT(*) FROM employees WHERE last_name='Smith';
SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';
SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
第21题:
The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.
第22题:
The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.
第23题:
SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
SELECT last_name FROM EMP WHERE last name ='*A%'
SELECT last_name FROM EMP WHERE last name ='_A%';
SELECT last_name FROM EMP WHERE last name LIKE '*A%'
第24题:
SELECT &1, &2 FROM &3 WHERE last_name = '&8';
SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';
SELECT &1, &2 FROM &3 WHERE last_name = '&8';
SELECT &1, '&2' FROM EMP WHERE last_name = '&8';