Set - 2

Question 21 :

Why does the following command give a compilation error?

Answer :

DROP TABLE &TABLE_NAME; Variable names should start with an alphabet. Here the table name starts with an '&' symbol.


Question 22 :

Which system tables contain information on privileges granted and privileges obtained?

Answer :

USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD


Question 23 :

Which system table contains information on constraints on all the tables created?obtained?

Answer :

USER_CONSTRAINTS.


Question 24 :

What is the difference between TRUNCATE and DELETE commands?

Answer :

True


Question 25 :

State true or false. !=, <>, ^= all denote the same operation?

Answer :

True.