Which SQL statement is used to return only different values?

Related MCQs

• Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
• 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?
• Which SQL function is used to count the number of rows in a SQL query?
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• What SQL structure is used to limit column values of a table?
• With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?
• With SQL, how can you return the number of not null records in the “Persons” table?
• 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;
• What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
• The statement in SQL which allows to change the definition of a table is