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 all the students where the second letter in the first name is ‘i’?

A - select first_name from students where first_name like ‘_i%’;

B - select first_name from students where first_name like ‘%i_’;

C - select first_name from students where first_name like ‘%i%’;

D - select first_name from students where first_name like ‘_i_’;

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

A - TUTORIAL

B - POINT

C - TUTORIALS

D - UTORIALS

Q 3 - 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 the USING clause

A - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h join location l using(subject_code);

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

C - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h, location l using(subject_code);

D - None of the above.

Q 4 - Which of the following is not true about SQL joins?

A - An inner join is a join of two tables returning only matching rows.

B - A left or right outer join returns the results of the inner join as well as the unmatched rows in the left or right table respectively.

C - A full outer join returns results of an inner join as well as the results of a left and right join.

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 - In which of the following cases a DML statement is not executed?

A - When existing rows are modified

B - When some rows are deleted

C - When a table is deleted

D - All of the above

Q 7 - Consider the following schema −

LOCATIONS(subject_code, department_name, location_id, city);

Which code snippet will alter the table LOCATIONS and delete the column named CITY?

A - MODIFY TABLE locations DROP (city varchar2(30));

B - ALTER TABLE locations DROP COLUMN city;

C - ALTER TABLE locations DROP (city);

D - None of the above.

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

A - A NOT NULL constraint specifies that the column cannot have a null value.

B - A UNIQUE constraint specifies that a column or a combination of column must have unique values for all rows.

C - A PRIMARY KEY is same as UNIQUE.

D - A FOREIGN KEY enforces a foreign key relationship between a column and a referenced table.

Q 9 - Which of the following code will retrieve data from the view all_marks_english, created in the previous question?

A - select view all_marks_english;

B - select from all_marks_english;

C - retrieve from all_marks_english;

D - select * from all_marks_english;

Q 10 - A database administrator can

A - Create users.

B - Create privileges.

C - Grant privileges.

D - All of the above.