Inf3707 - Exam Prep 2022 Review With 100% Correct Verified Answers

Which of the following is false regarding the WHERE clause? A. The WHERE can compare values in columns, literal, arithmetic expressions, or functions. B. The WHERE clause contains column name C. Column aliases can be used in the WHERE clause. D. The WHERE clause cannot contain list of values or constants. {Ans: C, D.}Which of the following symbols is used for a column alias containing spaces? 1. Single quotation marks (' ') 2. Pipe (| |) 3. Double quotation marks (" ") 4. Percentage signs (% %) {Ans: 3. Double quotation marks (" ")}Determine the output of the below query SELECT 'Tutorial''s Point compiles technical tutorials' FROM DUAL; A. Tutorial''s Point compiles technical tutorials B. Tutorial's Point compiles technical tutorials C. 'Tutorial''s Point compiles technical tutorials' D. Raises exception "ORA-01756: quoted string not properly terminated" {Ans: B. Tutorial's Point compiles technical tutorials}Which of the following data type is assigned to Substitution variables? A. VARCHAR2 B. DATE C. NO DATA TYPE D. NUMBER {Ans: C. Substitution variables do not have the data type of their own but comply with the column's data type with whom they are used.}Write a SELECT query to list down unique departments from