Multiple choice technology databases

This is the name of the database object containing information about all comments on table....

  1. USER_COMMENTS

  2. USER_ALL_COMMENTS

  3. USER_TAB_ALL

  4. USER_TAB_COMMENTS
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

USER_TAB_COMMENTS is the Oracle data dictionary view that stores comments on tables and views owned by the current user. It contains columns for TABLE_NAME, TABLE_TYPE, and COMMENTS. The other options (USER_COMMENTS, USER_ALL_COMMENTS, USER_TAB_ALL) are not valid Oracle system views. Comments can be added using COMMENT ON TABLE table_name IS 'text'.

Keep practicing — related questions