7 Feb 2014

Sql theory set one

SQL






1  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

2.  What command is used to get back the privileges offered by the GRANT command?
             REVOKE
3.      Which date function is used to find the difference between two dates?
             MONTHS_BETWEEN

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


5.  Which system tables contain information on privileges granted and privileges obtained?
             USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD

No comments:

Post a Comment