Exam 1z0-071 topic 1 question 27 discussion

Not F because ALL_TABLES shows only those tables the user already has access to, so no special privileges are needed beyond access. Also, the question says 'You must have..' ✅ D. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in DBA_TABLES. True. To query DBA_TABLES, you need appropriate system privileges, like SELECT_CATALOG_ROLE.

AF is the right answer anyday. USER_TABLE - dictionary view which has list of tables owned by the user ALL_TABLE - dictionary view which has list of tables owned by the user + tables which user has grants for. DBA_TABLE - All tables in database(but you should have dba privelege to see them)

AD , the right answers. The data dictionary views that begin with DBA_ are restricted. These views can be accessed only by users with the SELECT_ANY_TABLE privilege. This privilege is assigned to the DBA role when the system is initially installed. https://docs.oracle.com/cd/A57673_01/DOC/server/doc/SRF73/ch2a.htm

if you don't have dba role then you will get message that DBA_TABLES doesn't exist. DBA_TABLES is a data dictionary view

I tried D and it doesn't work for me!!!! But its probably A. idk about the 2nd option

AD to view dba_table should have privilege.

i am for AF

AD. Tried on ORA 19. GRANT SELECT ANY_TABLE to gives access to DBA_TABLES F is incorrect because querying ALL_TABLES you can always do but only see those tables you have the rights to view, which would be a subset of DBA_TABLES

AF cannot grant dba_tables privilege

A, F are correct

Don't get USER_TABLE and ALL_TABLE views confused. A) USER_TABLES displays all tables owned by the current user. (True) E) ALL_TABLES displays all tables owned by the current user. (False) The ALL_TABLES view contains description of tables accessible to the user.