MCQs
Total Questions : 10
Answer: Option A. -> Rows returned by sub query
"Temporary Tables are output format of any query on Mysql.
Answer: Option A. -> {-3, -2, -1, 1, 2, 3}
"ORDER BY clause sort the emp_id in the result set.
Answer: Option A. -> GROUP BY
"GROUP BY is used with aggregate functions.
Answer: Option B. -> Null
Answer: Option A. -> Aggregate functions
Answer: Option A. -> {9, 7, 6, 4, 3, 1, 2}
Answer: Option B. -> No error
Answer: Option A. -> Show only columns (person_id, Fname, lname) and rows related to these columns
"SELECT clause is used to show all rows and columns that are mention with the query.
Answer: Option B. -> emp_id, Status, emp_pi, last_name
Status, emp_pi, last_name are "column aliases and Keyword "AS is optional.
Answer: Option B. -> Only those columns which are mention with SELECT" clause
"WHERE clause is used to filter out unwanted rows and "SELECT clause is used to select columns from table.