최신Oracle Database 11g: Program with PL/SQL - 1Z0-144무료샘플문제

A. It fails because no value is assigned to the v_myage variable.

B. It executes and displays null.

C. It executes and the condition returns true.

D. It executes and control goes to the else statement.

A. It gives an error because the AVG function cannot be used in a PL/SQL block

B. It gives an error because decode cannot be used in a PL/SQL block.

C. It executes successfully.

D. It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block.

E. It gives an error because both the AVG and decode functions cannot be used in a PL/SQL block.

A. It gives an error and all the data manipulation language (DML) statements are rolled back

B. It executes successfully and all the rows are updated.

C. It gives an error but saves the inserted rows and the update to the first row.

D. It gives an error but saves the inserted rows; however, no rows are updated.

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 only the data type and constraint from the CUST_NAME variable resulting in an error

D. The SAME_NAME variable inherits the data type, constraint, and default value from the CUST_NAME variable.

A. A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.

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 can be called only as part of a SQL statement, whereas a procedure can be called only as a PL7SQL statement.

D. A function may return one or more values to the calling environment, whereas a procedure must return a single value to its calling environment.

A. It gives an error because the usage of the host variables is invalid.

B. It gives an error because the data type of the return clause is invalid.

C. It is created successfully.

D. It gives an error because the return clause condition is invalid.

A. It does not execute because you cannot declare an exception with a similar name in the subblock.

B. The PAST_DUE exception raised by the enclosing block is not propagated to the outer block and it is handled by the WHEN OTHERS exception handler

C. The PAST_DUE exception raised in the subblock causes the program to terminate abruptly because there is no exception handler in the subblock.

D. The exception raised in the code is handled by the exception handler for the PAST_DUE exception.

A. line 4

B. line 5

C. line 3

D. line 2

A. The cursor needs to be closed after the iteration is complete.

B. The PL/SQL creates a record variable with the fields corresponding to the columns of the cursor result set.

C. The implicit open, fetch, exit, and close of the cursor happen.

D. The record type must be explicitly declared to control the loop.

A. The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY procedure cannot call the stand-alone increase function.

B. Both blocks compile successfully but the CALC_SAL procedure gives an error on execution.

C. The CALC_SAL procedure gives an error on compilation because the amt variable should be declared in the RAISE_SALARY procedure.

D. Both blocks compile and execute successfully when called.