Prüfungsfragen und antworten 1Z0-147 Oracle

SAP ABAP,zertifizierung-portal.de,SAP Certified Associate,SAP Certified Development Associate,SAP Application Associate,SAP-Certifications,SAP Certified Application Associate,SAP Certified Application Professional,SAP Certified Development Professional, SAP Certified Technology Associate, SAP Certified Technology Professional

1Z0-147 Oracle9i program with pl/sql Die rasante Entwicklung im Bereich der Informationstechnik macht es zwingend, sich regelmäßig fortzubilden. Weisen Sie Ihr IT-Können nach, absolvieren Sie Ihre Prüfung. Bei Ihrer Zertifizierungsvorbereitung werde Ihnen zertifizierung-portal.de sehr gut helfen.

Prüfungsfragen und antworten 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

Prüfungsfragen und antworten 1Z0-147 Oracle