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 whose first name starts with the character ‘A’?

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

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

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

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

Q 2 - What is returned by INSTR(‘TUTORIALS POINT’, ‘P’)?

A - 11

B - 10

C - POINT

D - TUTORIALS

Q 3 - Consider the following schema −

 STUDENTS(student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks); 

Which query will display the names and honours subjects of all students and if a student has not yet been given a honours subject yet, then it should display ‘No Honours Yet’.

A - select first_name, last name, nvl(honours_subject, ‘No Honours Yet’) from students;

B - select first_name, last name, nvl2(honours_subject, ‘No Honours Yet’) from students;

C - select first_name, last name, honours_subject, from students;

D - select first_name, last name, nullif(honours_subject, ‘No Honours Yet’) from students;

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 the ON clause

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

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

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

D - None of the above.

Q 5 - Which of the following is not true about the COUNT function?

A - COUNT(*) returns the number of rows in the table.

B - COUNT(exp) returns the number of rows with non-null values for the exp.

C - COUNT(DISTINCT exp) returns the number of unique, non-null values in the column.

D - All are true.

Q 6 - Which of the following is not true about removing rows from a table?

A - You can use a subquery in a DELETE statement.

B - Specific rows are deleted based on the WHERE clause condition.

C - A statement like, DELETE , would cause deletion of the table from the database.

D - All of the above.

Q 7 - Which of the following is true about the SQL transaction control statements?

A - They ensure data consistency.

B - They allow preview of data changes before making permanent changes in data.

C - They group logically related operations.

D - All are true.

Q 8 - 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 code will create a simple view named all_marks_english that contains the names and percentage of marks of the students in the honours_subject ‘Eng01’?

A - create view all_marks_english as select first_name, last_name, percentage_of_marks from students where honours_subject = ‘Eng01’;

B - create view all_marks_english as ( first_name, last_name, percentage_of_marks from students where honours_subject = ‘Eng01’);

C - select view all_marks_english as select first_name, last_name, percentage_of_marks from students where honours_subject = ‘Eng01’;

D - None of the above.

Q 9 - Which of the following code will delete a view named all_marks_english?

A - delete view all_marks_english;

B - drop view all_marks_english;

C - delete all_marks_english;

D - drop all_marks_english;

Q 10 - Which statement is used for allocating system privileges to the users?

A - CREATE

B - GRANT

C - REVOKE

D - ROLE