The following OBJECT PRIV'S can be granted on tables, views and sequences---
UPDATE: tables, views.
REFERENCES: tables, views
ALTER: tables, sequences.
SELECT: tables, views, sequences
D incorrect for Oracle - only for IBM hierarchial dbms
Per Oracle doc
REFERENCES
Table or materialized view
Enables a user to create a foreign key dependency on a table or materialized view.
The REFERENCES privilege on a parent table implicitly grants SELECT privilege on the parent table.
CE,
according to this site:
https://docs.oracle.com/database/121/TTSQL/privileges.htm#TTSQL338
A. INSERT can be granted only on tables and sequences. (FALSE, table + synonym)
B. DELETE can be granted on tables, views, and sequences. (FALSE, only table)
C. SELECT can be granted on tables, views, and sequences. (TRUE)
D. ALTER can be granted only on tables and sequences. (FALSE, ALTER is system priv. not object)
E. REFERENCES can be granted only on tables. (TRUE, tables + materialised views, which are different than 'normal' views)
But answer E mentioned only on Table so E is clearly wrong :D
It didnt mention and "materialised views" it said Tables "only" which is wrong.
So i think C & D is correct.
upvoted 2 times
...
...
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
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.
holdfaststrongly
Highly Voted 2 years ago826cb95
Most Recent 5 days, 22 hours agoragdoll_raincoat
3 months agoalelejaja
4 months, 3 weeks agowi11111
1 year, 2 months agoTheOracleWasTaken
1 year, 2 months agoCMjer
1 year, 5 months agoCyberP
1 year, 4 months ago