SELECT department_idDep, COUNT(last_name) FROM employees GROUP BY Dep

From employees

Where department_id=10) union

16. Which command is used to view the structured of the table LOCATIONS?(DESCRIBER

LOCATIONS)

17.Which of the following SQL statements will not generate an error?

SELECT department_idDep, COUNT(last_name) FROM employees GROUP BY Dep

18.Consider the EMPLOYEES table. Which of the following SQL statements is correct to display the last name of the employee with its hire date providing the Employee and Hire Date aliases (case is important)?

SELECT last_name “Employee”, hire_date “Hire Date” FROM employees;

19.What will be the result of the following SQL statement? Select TRUNC(68.548, -1) From dual; 60?

20. There can be more than one condition in a query ВЕРНО

21.Which following is a concatenation operator? (||)

22.Asubquery must be enclosed in____(Parentheses)

23.Which SQL statement is used to extract data from a database ? (SELECT)

24. Use the____ operator to return all rows multiple tables and eliminate any duplicate rows. (UNION)

25.which keyword is used to eliminate duplicate rows in the result? (DISTINCT)

26.Consider the EMPLOYEES table. Which of the following statements displays the hire date in format ‘January,19 1998 ’? SELECT TO_CHAR

(hire_date,’fmMonth, DD YYYY’) FROM employees

27.Which of the following statements about aliases is NOT true? (Aliases always require double quotation marks)

28.Consider the EMPLOYEES table. Which of the following statements displays the hire date in the format ‘Nineteenth of January, 1998’? SELECT TO_CHAR(hire_date,’fmDdspth ”of” MONTH, YYYY’) FROM employees

29.To obtain a list of last names that students and instructors share, you use the MINUS set operator (FALSE)

30. Which of the following queries determines which enrolled students have no grades at all.