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 the distinct honours subjects in the STUDENTS table?

A - select honours_subject from students;

B - select distinct honours_subject from students;

C - select all honours_subject from students;

D - select * from students;

Q 2 - Which of the following is not true about single row functions?

A - They operate on single rows only and return one result per row.

B - They accept arguments that could be a column or any expression.

C - They cannot be nested.

D - They may modify the data type.

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 - Consider the following schema −

HONOURS_SUBJECT(subject_code, subject_name, department_head);

LOCATIONS(subject_code, department_name, location_id, city);

Select the right query for retrieving records from the tables HONOURS_SUBJECT and LOCATIONS with a right outer join

A - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h on right outer join location l where(h.subject_code = l.subject_code);

B - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h outer join location l on(subject_code);

C - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h right outer join location l on(h.subject_code = l.subject_code);

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 is true about inserting news rows to a table?

A - You must list values in the default order of the columns in the table.

B - You can also list the columns in the INSERT clause.

C - You can use the INSERT statement to add rows from one table to another.

D - All of the above.

Q 7 - Which statement allows conditional update, or insertion of data into a table simultaneously?

A - INSERT statement

B - MERGE statement

C - UPDATE statement

D - None of the above

Q 8 - Which of the following is not true about use of a database view?

A - It restricts data access.

B - It makes queries easy.

C - It provides data independence.

D - It prevents different views of same data.

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 is a system privilege?

A - Creating new users

B - Removing users

C - Removing tables

D - All of the above.