Set - 3

Question 11 :

What operator performs pattern matching?

Answer :

LIKE operator.


Question 12 :

What is the use of the DROP option in the ALTER TABLE command?

Answer :

It is used to drop constraints specified on the table.


Question 13 :

What operator tests column for the absence of data?

Answer :

IS NULL operator.


Question 14 :

What are the privileges that can be granted on a table by a user to others?

Answer :

Insert, update, delete, select, references, index, execute, alter, all.


Question 15 :

Which function is used to find the largest integer less than or equal to a specific value?

Answer :

FLOOR.