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 - What is returned by SUBSTR(‘TUTORIALS POINT’, -1, 1)?

A - T

B - NULL

C - 0

D - N

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 MAX and MIN functions?

A - Both can be used for any data type.

B - MAX returns the maximum value.

C - MIN returns the minimum value.

D - All are true.

Q 5 - A subquery can be placed in which of the SQL clauses?

A - The WHERE clause

B - The HAVING clause

C - The FROM clause

D - All of the above.

Q 6 - Which of the following is not true about modifying rows in a table?

A - Existing rows in a table are modified using the UPDATE statement.

B - You can update more than one row at a time.

C - All the rows in a table are modified if you omit the WHERE clause.

D - None 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 creating constraints?

A - Constraints are defined using the CREATE CONSTRAINT statement.

B - They are created at the same time when the table is created.

C - They could be created after the table is created.

D - All the constraints are stored in data dictionary.

Q 9 - Which of the following statement is used to modify a sequence?

A - ALTER SEQUENCE

B - SELECT SEQUENCE

C - DROP SEQUENCE

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.