SQL Online Quiz

Q 1 - Which of the following is not true about SQL statements?

A - SQL statements are not case sensitive.

B - SQL statements can be written on one or more lines.

C - Keywords cannot be split across lines.

D - Clauses must be written on separate lines.

Q 2 - Consider the following schema −

STUDENTS(student_code, first_name, last_name, email, 
         phone_no, date_of_birth, honours_subject, percentage_of_marks);

Which of the following query would correctly display the students’ first name, last name, honours subject and date of birth, born between July 1^st 1996, and 30^th June 1999.

A - select first_name, last name, honours_subject, date_of_birth from students where date_of_birth between ’30-JUN-1999’ and ’01-JUL-1996’;

B - select first_name, last name, honours_subject, date_of_birth from students where date_of_birth in (’30-JUN-1999’ , ’01-JUL-1996’);

C - select first_name, last name, honours_subject, date_of_birth from students where date_of_birth like ’30-JUN-1999’ and ’01-JUL-1996’;

D - select first_name, last name, honours_subject, date_of_birth from students where date_of_birth between ’01-JUL-1996’ and ’30-JUN-1999’;

Q 3 - Which of the following is not true about the COALESCE function?

A - It takes multiple alternate values.

B - It returns the first non-null expression in the parameter list.

C - It returns the first value in the parameter list if it is null.

D - None of the above.

Q 4 - Which of the following is not true about the ON clause?

A - ON clause is used to specify conditions or specify columns to join.

B - ON clause makes the query easy to understand.

C - ON clause does not allow three way joins.

D - None of the above.

Q 5 - Which of the following is not true about single-row subqueries?

A - Single row subqueries return one row from the inner SELECT statement.

B - Single row subqueries return one row from the outer SELECT statement.

C - Single row subqueries use single-row comparison operators.

D - All of the above.

Q 6 - Which of the following is not true about multiple-row subqueries?

A - Multiple row subqueries return multiple rows from the outer SELECT statement.

B - Multiple row subqueries return multiple rows from the inner SELECT statement.

C - Multiple row subqueries use multiple-row comparison operators.

D - All of the above.

Q 7 - Which of the following is true about the SQL transaction control statements?

A - They ensure data consistency.

B - They allow preview of data changes before making permanent changes in data.

C - They group logically related operations.

D - All are true.

Q 8 - Which of the following is not true about complex views?

A - They derive data from more than one table.

B - They contain no functions or grouping.

C - You cannot perform DML operations through a complex view.

D - All of the above are true.

Q 9 - Which of the following is not true about the Pseudocolumns that return the sequence values?

A - NEXTVAL returns the next available sequence value.

B - CURRVAL gets the current sequence value.

C - PREVVAL gets the previous sequence value.

D - None of the above.

Q 10 - Which of the following is not true about database synonyms?

A - Synonyms are used for shortening lengthy object names.

B - A synonym is just an alternative name.

C - Synonyms can be created for tables, views, sequences, procedures and other database objects.

D - None of the above.