Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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
4 months, 1 week agozangado
5 months, 2 weeks agoogi33
2 weeks, 3 days agojm9999
7 months, 3 weeks agoShrimathi
10 months agox33
7 months ago