1Z1-144 무료 덤프문제 온라인 액세스

Examine the following package specification.
SQL>CREATE OR REPLACE PACKAGE emp_pkf IS PROCEDURE search_emp (empdet NUMBER); PROCEDURE search_emp (empdet DATE); PROCEDURE search_emp (empdet NUMBER); RETURN VERCHAR2 PROCEDURE search_emp (empdet NUMBER); RETURN DATE END emp_pkg / The package is compiled successfully
Why would it generate an error at run tune?

• A.Because all the functions and procedures In the package cannot have the same number of parameters with the same parameter name
• B.Because function cannot differ only in return type.
• C.Because function cannot be overload
• D.Because the search EMP (EMPDET NUMBER) procedure and the SEARCH_DEPT (EMPDET NUMBER) cannot have identical parameter names and data types

Which statements are true about database triggers? (Choose all that apply.)

• A.They can invoke only PL/SQL procedures
• B.They are implicitly fired by an event that must occur within an application
• C.They can include SQL and PL/SQL or calls to Java procedures.
• D.They are implicitly fired when a triggering event occurs, depending on which user is connected

Examine the following PL/SQL code;

The execution of the code produces errors. Identify the error in the code.

• A.The open cursor is missing
• B.The fetch clause is missing
• C.The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.
• D.The exit when condition is missing

Which two statements are true about the PL/SQL initialization parameters? (Choose two.)

• A.To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l.
• B.Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled
• C.Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations.
• D.The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance.

Which statements are true about PL/SQL procedures? (Choose all that apply.)

• A.Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.
• B.A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java.
• C.Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time.
• D.Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.