OCSecA 1Z0-147 Oracle

OCSecA 1Z0-147 Oracle

www.it-pruefungen.ch hilft Ihnen mit hochwertigenUnterlagen und Software, die Fragen und Antworten Zertifizierungsprüfung zu bestehen. Mit Hilfe der www.it-pruefungen.ch sind Sie sicher, die Zertifizierung mit einem hohen Punkt zu bestehen und den Erfolg im IT-Bereich erobern.

1Z0-147 Oracle9i program with pl/sql Vorbereitung für IT-Prüfung hat eine Reihe von spezialisierten Zertifizierungsprüfung im Zusammenhang mit einem bestimmten Gebiet, und so ist die Wahl der richtigen Training Produkt ist sehr wichtig.

OCSecA 1Z0-147 Oracle

QUESTION 1
You want to create procedures, functions and packages Which privilege do you need?
A. EXECUTE CODE object privilege
B. CREATE ANY CODE object privilege
C. CREATE PACKAGE system privilege
D. CREATE PROCEDURE system privilege
E. CREATE FUNCTION, CREATE PROCEDURE, CREATE PACKAGE system privileges

Answer: D

Explanation/Reference:
The privilege CREATE PROCEDURE gives the grantee the right to create procedures, functions, and packages within their schema. This privilege does not give the right to drop or alter the program constructs.
Incorrect Answers
A, B & C are not valid object or system privileges.

QUESTION 2
You have created a stored procedure DELETE_TEMP_TABLE that uses dynamic SQL to remove a table in your schema. You have granted the EXECUTE privilege to user A on this procedure. When user A executes the DELETE_TEMP_TABLE procedure, under whose privileges are the operations performed by default?
A. SYS privileges
B. Your privileges
C. Public privileges
D. User A’s privileges
E. User A cannot execute your procedure that has dynamic SQL.

Answer: B

Explanation/Reference:
When you create a procedure, it will be executed under the privileges of the creator, unless the procedure has the following statement AUTHID CURRENT_USER. If you specify AUTHID CURRENT_USER, the privileges of the current user are checked at run time, and external references are resolved in the schema of the current user. Like this example
SQL> CREATE OR REPLACE PROCEDURE delete_temp_table(v_table varchar2)
2 AUTHID CURRENT_USER
3 IS
4 BEGIN
5 EXECUTE IMMEDIATE ‘DROP TABLE ‘||V_TABLE;
6 END;
7 /
Procedure created.
If the procedure is create in this way then the EXECUTE IMMEDIATE statement will be execute under the privilege of the user who executes the procedure, but if we skip line 2 then the procedure will be executed under the privilege of the owner of the procedure.
Incorrect Answers
A: SYS privilege has nothing with is.
C: What is the public privileges? There is nothing called public privileges.
D: This will be true if the procedure contains the AUTHID CURRENT_USER.
E: There is no problem in having a dynamic SQL statement in Procedure.

QUESTION 3
When creating a function, in which section will you typically find the RETURN keyword?
A. HEADER only
B. DECLARATIVE
C. EXECUTABLE and HEADER
D. DECLARATIVE,EXECUTABLE and EXCEPTION HANDLING

Answer: C

OCSecA 1Z0-147 Oracle