1Z0-144 無料問題集「Oracle Database 11g: Program with PL/SQL」

（A）Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers

（B）A trigger can contain a maximum of 32 lines of code.

（C）Each trigger can be of a maximum size of 32 K

（D）Triggers fired by DML statements cannot cascade simultaneously.

（E）Each trigger can be of any size.

（F）Both DML and DDL statements can cascade any number of triggers,

（A）the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler

（B）an exception that the developer determines as abnormal, are in the declarative section and raised explicitly

（C）an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit

（D）the exceptions that are explicitly raised by the program and can be caught by the exception handler

（A）Procedure A is invalidated and recompiles when invoked the next time.

（B）Procedure B is invalidated and recompiled again when invoked.

（C）Procedure A is invalidated and recompiled immediately.

（D）There is no effect on procedure A and it runs successfully.

（A）The SQLERRM function

（B）The RAISE_APPLICATION_ERROR procedure

（C）A user-defined exception used with a raise statement

（D）The PRAGMA EXCEPTION_INIT function

（A）It gives an error because the return clause condition is invalid.

（B）It gives an error because the usage of the host variables is invalid.

（C）It gives an error because the data type of the return clause is invalid.

（D）It is created successfully.

（A）You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.

（B）The dynamic SQL statement retrieves rows into records.

（C）You do not know how many columns a select statement will return, or what their data types will.

（D）The SELECT list is not known until run time.

（A）Both Output statements show different values.

（B）It gives an error because the V_CUSTOMER variable have different types in the nested blocks

（C）Both output statements show exactly the same values.

（D）It gives an error because the nested blocks are not labeled.

（A）Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.

（B）Only the wrap utility can obfuscate multiple programs at a time.

（C）The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View

（D）SQL' Plus cannot process the obfuscated source files.

（E）The Import and Export utilities accept wrapped files.

（A）It executes successfully and generates a warning.

（B）It executes successfully.

（C）It generates a run-time exception.

（D）It does not execute because of syntax error

（A）The SAME_NAME variable inherits only the data type and default value from the CUST_NAME variable.

（B）The SAME_NAME variable inherits only the data type from the CUST_NAME variable.

（C）The SAME_NAME variable inherits the data type, constraint, and default value from the CUST_NAME variable.

（D）The SAME_NAME variable inherits only the data type and constraint from the CUST_NAME variable resulting in an error