SQL Interview Questions and Answers

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

USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD

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

USER_CONSTRAINTS.

15. What is the difference between TRUNCATE and DELETE commands?

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

True.

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

True.

18. What will be the output of the following query?

SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL;?
TROUBLETHETROUBLE.

SQL Interview Questions And Answers