Oracle Database 11g: Program with PL/SQL - 1Z0-144 FREE EXAM DUMPS QUESTIONS & ANSWERS

A. It gives an error because the INSERT SELECT construct cannot be used with the FORALL B. It gives an error because the SQL%ROWCOUNT attribute cannot be used with BULK COLLECT. C. It executes successfully but the output statements show different values. D. It executes successfully and both output statements show the same values.

A. setting the SMTP_OUT_SERVER initialization parameter B. setting the UTL_FILE_DIR initialization parameter C. running the UTLMAIL.SQL and prvtmail.plb scripts D. granting read and WRITE privileges to control the type of access to files in the operating system E. using the CREATE DIRECTORY statement to associate an alias with an operating system directory

A. All the triggers that are created on a table cannot be disabled simultaneously. B. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database. C. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation. D. Any user who has the alter privilege on a table can create a trigger using that table.

A. The execution is successful even if there is no employee with EMPLOYEE_ID 115. B. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found. C. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found. D. The execution fails because of the misplaced else clause.

A. All the exceptions in the code are trapped by the exception handler. B. All the "no data found" errors in the code are trapped by the exception handler. C. An exception handler in the code traps the "no data found" error after executing the handler code and the program flow returns to the next line of code. D. The PL/SQL program does not execute because an exception is not declared in the declare section.

A. A function can be called only as part of a SQL statement, whereas a procedure can be called only as a PL7SQL statement. B. A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure can be called only as a PL/SQL statement. C. A function may return one or more values to the calling environment, whereas a procedure must return a single value to its calling environment. D. A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.

A. A package body can exist without the package specification. B. A package must have both specification and body. C. A package specification can exist without the package body. D. When a packaged public variable is called for the first time in a session, the entire package is loaded into memory.

A. Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers B. Triggers fired by DML statements cannot cascade simultaneously. C. A trigger can contain a maximum of 32 lines of code. D. Each trigger can be of a maximum size of 32 K E. Both DML and DDL statements can cascade any number of triggers, F. Each trigger can be of any size.

A. King 17-JUN-87 24000 B. King current sysdate 24000 C. King 17-JUN-87 1500 D. King current sysdate 1500