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
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
...
...
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 1 year, 8 months agoalelejaja
Most Recent 2 weeks agowi11111
10 months, 1 week agoTheOracleWasTaken
10 months, 2 weeks agoCMjer
1 year, 1 month agoCyberP
1 year ago