Oracle
1Z0-074 · Question #25
1Z0-074 Question #25: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #25. The question stem and answer options stay visible for context.
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
Unlock 1Z0-074 to see the answer
You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.