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 SUBSTR(‘TUTORIALS POINT’, 1, 9)?

A - TUTORIAL

B - POINT

C - TUTORIALS

D - UTORIALS

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

A - The join condition is not separated from other search conditions in a query.

B - The ON clause makes code difficult to understand.

C - The join condition for natural join is basically an equijoin of all columns with same name.

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 - Which of the following is not true about single-row subqueries?

A - Single row subqueries return one row from the inner SELECT statement.

B - Single row subqueries return one row from the outer SELECT statement.

C - Single row subqueries use single-row comparison operators.

D - All of the above.

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

A - You can update some rows in a table based on values from another table.

B - If you try to update a record related to an integrity constraint, it raises an error.

C - You can modify multiple columns.

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 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 is not true about a sequence?

A - They are used for generating sequential numbers.

B - Sequences are created by the CREATE SEQUENCE statement.

C - You cannot modify a sequence.

D - None of the above.

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

A - CREATE

B - GRANT

C - REVOKE

D - ROLE