E is correct only if we assume that user doesn't insert ord_no explicitly. If he does than he doesn't need the select privilege on the sequence.
In my oppinion only C is correct.
• During table creation, the sequence must exist and you must have select privilege on it for it to be used as a column default.
• The users performing inserts against the table must have select privilege on the sequence, as well as insert privilege on the table.
A is wrong. in the sequence code there is cycle. it means once it has reach the maxvalue start all over from 1. i.e duplicate.
upvoted 1 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.
yaya32
6 months agozangado
7 months, 1 week agoogi33
2 months, 1 week agojm9999
9 months, 3 weeks agoShrimathi
11 months, 3 weeks agox33
8 months, 3 weeks ago