IBM
C2090-610 · Question #71
C2090-610 Question #71: Real Exam Question with Answer & Explanation
The correct answer is C. SELECT privilege on TABLE1. See the full explanation below for the reasoning.
Question
What is the lowest privilege and/or authority required to execute the following SQL statement? CREATE VIEW view1 AS SELECT * FROM table1 WHERE STATE = 'TX'
Options
- ADBADM authority
- BSYSADM authority
- CSELECT privilege on TABLE1
- DREFERENCES privilege on TABLE1
Community Discussion
No community discussion yet for this question.