ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam
Go to Exam

Exam 1z0-071 topic 1 question 27 discussion

Actual exam question from Oracle's 1z0-071
Question #: 27
Topic #: 1
[All 1z0-071 Questions]

Which two statements are true about *_TABLES views? (Choose two.)

  • A. USER_TABLES displays all tables owned by the current user.
  • B. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in USER_TABLES.
  • C. All users can query DBA_TABLES successfully.
  • D. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in DBA_TABLES.
  • E. ALL_TABLES displays all tables owned by the current user.
  • F. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in ALL_TABLES.
Show Suggested Answer Hide Answer
Suggested Answer: AF 🗳️
by holdfaststrongly at Sept. 21, 2022, 2:40 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Lee_jong_suk
1 year, 1 month ago
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)
upvoted 1 times
JONBONESJONES
5 months, 4 weeks ago
F is incorrect because if i have only my owntables and no access to others. i dont need ANY TABLE privileges to see my own table in all tables
upvoted 1 times
...
...
Hrishi41
1 year, 4 months ago
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
upvoted 2 times
jm9999
1 year, 3 months ago
granting select any table to my user did not allow him to query dba_tables
upvoted 4 times
...
...
HassanMkhlalati
1 year, 4 months ago
Selected Answer: AF
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
upvoted 2 times
...
TheOracleWasTaken
1 year, 6 months ago
I tried D and it doesn't work for me!!!! But its probably A. idk about the 2nd option
upvoted 1 times
...
Shrimathi
1 year, 6 months ago
AD to view dba_table should have privilege.
upvoted 2 times
...
zouve
1 year, 7 months ago
Selected Answer: AF
i am for AF
upvoted 3 times
...
Rik92
2 years ago
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
upvoted 4 times
...
dexdinh91
2 years ago
Selected Answer: AF
AF cannot grant dba_tables privilege
upvoted 3 times
thejivsniper
2 years ago
Explain all answers
upvoted 1 times
...
...
Viviana3184
2 years, 3 months ago
A, F are correct
upvoted 1 times
...
holdfaststrongly
2 years, 4 months ago
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.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago