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 and percentage of marks more than 80, 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” or honours_subject = “Spanish” and percentage_of_marks > 80);

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

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 true about SQL joins?

A - The join condition is not separated from other search conditions in a query.

B - The ON clause makes code difficult to understand.

C - The join condition for natural join is basically an equijoin of all columns with same name.

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 - 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 will correctly display name of all the students who got more marks than the student ‘0215/15’?

A -

select first_name, last_name from students 

where percent_of_marks > 
	(select percentage_of_marks from students
		where student_code = ‘0215/15’);

B -

select first_name, last_name from students 
having percent_of_marks > 
	(select percentage_of_marks from students
		where student_code = ‘0215/15’);

C -

select first_name, last_name from students 
using percent_of_marks > 
	(select select percentage_of_marks from students
		where student_code = ‘0215/15’);

D - None 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 code will successfully delete the table LOCATIONS from the database?

A - DROP TABLE locations;

B - DELETE TABLE locations;

C - TRUNCATE TABLE locations;

D - None of the above.

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;