Oracle
1Z0-074 · Question #25
In an Oracle 12c Release 2 database, USER1 has CREATE SESSION, CREATE PROCEDURE, and CREATE FUNCTION privileges. Examine these commands: SYS executes this command: SQL> SELECT add_num(1,2) FROM…
The correct answer is C. TESTDBA is created with the SYSDBA privilege only. Explanation/Reference:
New Features for Security
Question
In an Oracle 12c Release 2 database, USER1 has CREATE SESSION, CREATE PROCEDURE, and CREATE FUNCTION privileges. Examine these commands:
SYS executes this command:
SQL> SELECT add_num(1,2) FROM DUAL; What is the result?
Exhibit
Options
- BThe message "The result is 3" only is displayed
- CTESTDBA is created with the SYSDBA privilege only
- DOnly "3" is displayed
- ETESTDBA is created will the SYSDBA privilege and the message "The result is 3" is displayed
How the community answered
(31 responses)- B13% (4)
- C74% (23)
- D3% (1)
- E10% (3)
Explanation
Explanation/Reference:
Topics
#PL/SQL privileges#CREATE PROCEDURE#function execution#privilege management
Community Discussion
No community discussion yet for this question.