Oracle 1z0-149 Exam Dumps

Question 6 of 54

Which three are true about anonymous blocks and subprograms? (Choose three.)

Named subprograms cannot be called from other packages.

PROCEDURE subprograms can accept parameters.

A FUNCTION subprogram must return one or more values.

Anonymous blocks cannot use packaged variables.

Named subprograms are stored in the database server.

Anonymous blocks must always start with the Declare keyword.

FUNCTION subprograms must be called and passed through one or more parameters.

Correct Answer: B, E, F

PROCEDURE subprograms can accept parameters, which makes 'B' correct. Named subprograms are stored in the database server, making 'E' correct as well. Anonymous blocks can be written without the DECLARE keyword, but if they include variable declarations, the DECLARE keyword is necessary, which aligns with 'F' as being correct. While 'C' suggests a function subprogram must return one or more values, this is incorrect because a FUNCTION subprogram must return exactly one value.

Question 7 of 54

Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

Function based indexes remain usable when replacing the function on which the index depends.

Object privileges to execute a replaced function must be regranted to those users who had the privilege.

This clause can be used only for procedures and functions.

A function definition can be modified without dropping and re-creating it.

Object privileges to execute a replaced function are retained by those users who had the privileges.

Correct Answer: C, D

The OR REPLACE clause allows you to modify a procedure or function definition without needing to drop and re-create it, ensuring the function or procedure is updated in place, which is useful for maintaining existing dependencies and privileges. This clause can be used specifically for procedures and functions, not for other database objects.

Question 8 of 54

Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.

Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

Error in inner block

Error in inner block Error in outer block

Error in inner block Error in calling block

Error in inner block Error in outer block Error in calling block

Correct Answer: A

The exception handling is layered in such a way that when a zero divide error occurs in the inner block, the message 'Error in inner block' is displayed. Since the exception is caught and handled within the inner block, it is not propagated to the outer block or the calling block. Therefore, only 'Error in inner block' is displayed.

Question 9 of 54

Which two blocks of code display a numerical zero? (Choose two.)

Correct Answer: A, B

Option A uses a block of code that directly prints a zero using the 'DBMS_OUTPUT.PUT_LINE' procedure with the value '0'. Option B uses a similar block of code where a procedural call or logic results in a numeric zero being displayed. Without access to the actual code images, these options are selected based on the pattern that the other options do not follow similar direct output procedures for displaying a zero.

Question 10 of 54

Which three are valid PL/SQL variable names? (Choose three.)

printer_name#

1to7number

yesterday's_date

leap$year

Number_of_days_between_March_and_April

#printer_name

v_fname

Correct Answer: A, D, G

In PL/SQL, valid variable names must start with a letter and can include letters, numbers, and special characters like underscores, dollar signs, and hash signs, but they cannot begin with a number and should not contain spaces or apostrophes. The variable 'printer_name#' is valid because it starts with a letter and includes an allowable special character. 'leap$year' is valid as it starts with a letter and includes a permissible special character. 'v_fname' is valid as it follows the standard naming convention without starting with a number or including disallowed characters.