1z0-071 Exam QuestionsBrowse all questions from this exam

1z0-071 Exam - Question 235


Which three are true about granting object privileges on tables, views, and sequences? (Choose three.)

Show Answer
Correct Answer: ACE

UPDATE can be granted only on tables and views, because it is necessary to modify data within these objects. SELECT can be granted on tables and views, enabling reading of data from these structures. REFERENCES can be granted only on tables and views to allow the creation of foreign key constraints referencing these objects. DELETE cannot be granted on sequences, as it pertains to removing data, which is not applicable to sequences. ALTER can be granted on both tables and sequences for changing their structure or properties, and INSERT is applicable primarily to tables and views but not sequences.

Discussion

2 comments
Sign in to comment
ArslanAltafOptions: ACE
May 6, 2024

ACE is correct

Misi_OracleOptions: ACE
May 9, 2024

A. TRUE B. FALSE. Only Table C. True. Can also be granted on sequences D. False. Trick question as alter is system privilege. Alter can be granted on both table and sequences. E. TRUE F. False. Insert can be granted to table and synonym