The UNION SQL clause can be used with _____________

Related MCQs

• View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
• The UPDATE SQL clause can _____________
• SQL applies predicates in the                 clause after groups have been formed, so aggregate functions may be used.
• ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is
• If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________
• ‘AS’ clause is used in SQL for
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• Which SQL function is used to count the number of rows in a SQL query?
• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• What is the purpose of the SQL AS clause?