OCA OCP Oracle Certification Exam Braindumps

6.Which compiler directive is used to check the purity level of functions?
A.PRAGMA PURITY_LEVEL
B.PRAGMA SERIALLY_REUSEABLE
C.PRAGMA RESTRICT_REFERENCES
D.PRAGMA RESTRICT_PURITY_LEVEL
E.PRAGMA RESTRICT_FUNCTION_REFERENCE
Correct:C
7.Which system privilege must you have to manually recompile a stored procedure owned by another application developer?
A.ALTER PROCEDURE
B.ALTER ANY PROCEDURE
C.ALTER ALL PROCEDURE
D.COMPILE ANY PROCEDURE
Correct:B
8.You are creating a stored procedure in the SQL*Plus environment. The text of the procedure is stored in a script file. You run the script file to compile the procedure. What happens if the procedure contains syntax errors?
A.Neither the source code, nor the errors are stored in the database.
B.Both the source code and the compilation errors are stored in the database.
C.Compilation errors are appended to the script file that contains the source code.
D.The source code is stored in the database, and the errors are stored in an output file.
E.Only the compilation errors are written to the database, and source code remains in the script file.
Correct:B
9.Which procedure of the dbms_output supplied package would you use to append text to the current line of the output buffer?
A.GET
B.GET_LINE
C.PUT_TEXT_LINE
D.PUT
Correct:D
10.The number of cascading triggers is limited by which database initialization parameter?
A.CASCADE_TRIGGER_CNT
B.OPEN_CURSORS
C.OPEN_TRIGGERS
D.OPEN_DB_TRIGGERS
Correct:B