SQL Online Quiz

Q 1 - 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 display names of all the students whose honours subject is English, or honours subject is Spanish and percentage of marks more than 80?

A - select first_name, last name from students where (honours_subject = “English” or honours_subject = “Spanish” ) and percentage_of_marks > 80;

B - select first_name, last name from students where honours_subject = “English” or honours_subject = “Spanish” and percentage_of_marks > 80;

C - select first_name, last name from students where honours_subject = “English” and honours_subject = “Spanish” or percentage_of_marks > 80;

D - select first_name, last name from students where (honours_subject = “English”) and honours_subject = “Spanish” and percentage_of_marks > 80;

Q 2 - What is returned by SUBSTR(‘TUTORIALS POINT’, -1, 1)?

A - T

B - NULL

C - 0

D - N

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 true about subqueries?

A - Subqueries could be used for Top-N analysis.

B - Subqueries can be of two types – single-row subquery and multiple-row subquery.

C - The outer and inner queries can get data from different tables.

D - All of the above.

Q 6 - Which of the following comparison operators could be used in a multiple row query?

A - IN operator

B - ANY operator

C - ALL operator

D - All of the above

Q 7 - Which of the following is not true about the ALTER TABLE statement?

A - It can add a new row.

B - It can add a new column.

C - It can modify existing columns.

D - It can define a default value for the new column.

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 minimal code would create a sequence named loc_seq as a primary key of the LOCATIONS table?

A - create sequence loc_seq;

B - create sequence loc_seq on locations;

C - create loc_seq;

D - None of the above.

Q 10 - Which of the following code would create a role named student_admin?

A - CREATE student_admin;

B - GRANT student_admin;

C - CREATE ROLE student_admin;

D - ROLE student_admin;