IBM
C2090-610 · Question #71
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'
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
How the community answered
(28 responses)- A4% (1)
- B14% (4)
- C75% (21)
- D7% (2)
Community Discussion
No community discussion yet for this question.