2.      What are the wildcards used for pattern matching?

             _ for single character substitution and % for multi-character substitution

 

3.      State true or false. EXISTS, SOME, ANY are operators in SQL.

             True

 

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

             True

 

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

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

 

6.      What command is used to get back the privileges offered by the GRANT command?

             REVOKE

 

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

             USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD

 

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

             USER_CONSTRAINTS

Advertisements