Which one of the following sorts rows in SQL?

Related MCQs

• In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
• Which SQL function is used to count the number of rows in a SQL query?
• 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?
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;
• Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns?
• A           is a query that retrieves rows from more than one table or view:
• The phrase “greater than at least one” is represented in SQL by            
• Which of the following consists of a row of column headings, together with zero or more rows of data values?
• Which of the following retains duplicate rows in the result of a query or in an Aggregate expression?