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 with honours_subject ‘Eng01’?

A - select student_code, first_name, last_name from students where honours_subject = ‘Eng01’;

B - select student_code, first_name, last_name from students where honours_subject is ‘Eng01’;

C - select student_code, first_name, last_name where honours_subject = ‘Eng01’

    from students;

D - select student_code, first_name, last_name from students;

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 Natural Joins?

A - Natural join is based on all columns in two tables having same name

B - It selects rows from the two tables having different values in the matched columns.

C - If columns having same names have different data types, it returns error.

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

A - The INSERT INTO statement is used for inserting new rows to a table

B - You cannot insert rows with NULL values to a table.

C - You may insert a new row containing values for each column.

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 a FOREIGN KEY constraint?

A - It is a referential integrity constraint.

B - It establishes a relationship between a primary key or a unique key in the same table or a different table.

C - A foreign key value cannot be null.

D - A foreign key value must match an existing value in the parent table.

Q 9 - Which of the following code will create an index named stu_marks_ind on the columns student_code and percentage_of_marks of the STUDENTS table?

A - It’s not possible to create an index on two columns.

B - create index stu_marks_ind from students(student_code, percentage_of_marks);

C - create index stu_marks_ind on students(student_code, percentage_of_marks);

D - create index stu_marks_ind (student_code, percentage_of_marks) on students;

Q 10 - Which of the following statements allows William to change his database user account password to bill?

A - create user william identified by bill;

B - alter user william identified by bill

C - create user william password bill;

D - alter user william password bill;