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 TRUNC(789.8389, 2)?

A - 789.84

B - 789.83

C - 78

D - 789.00

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 - Which of the following is true about a group function?

A - Group functions operate on sets of rows to produce multiple results per group.

B - DISTINCT keyword makes a group function consider duplicate values.

C - Group functions ignore null values.

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 multiple-row subqueries?

A - Multiple row subqueries return multiple rows from the outer SELECT statement.

B - Multiple row subqueries return multiple rows from the inner SELECT statement.

C - Multiple row subqueries use multiple-row comparison operators.

D - All of the above.

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

A - The COMMIT statement ends the current transaction and makes all data changes permanent.

B - The ROLLBACK statement ends the transaction and discards all the pending data changes.

C - Each DML statement is automatically committed.

D - All are true.

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 code will create an index named

stu_marks_ind on the columns student_code and percentage_of_marks of the STUDENTS table.

Now which will delete the index stu_marks_ind.

Which of the following code will delete an index stu_marks_ind on the columns student_code and percentage_of_marks of the STUDENTS table?

A - drop index stu_marks_ind;

B - delete index stu_marks_ind;

C - drop stu_marks_ind;

D - drop index stu_marks_ind on students;

Q 10 - Which of the following is true about a role?

A - A role is a named group of related privileges.

B - It can be it can be created and assigned to a user.

C - It can be revoked from a user.

D - All of the above.