Oracle Database 19c: Program with PL/SQL - 1Z0-149 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

A. The actual parameters must be specified in the same order as the formal parameters are declared. B. The subprogram invocations must be changed when the formal parameter list acquires new required parameters. C. Any optional parameters can be omitted in the invocation call. D. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception. E. Only trailing optional parameters can be omitted in the invocation call.

Discussion 0

Correct Answer: A,C Vote an answer

Question 2

Which three are true about DDL triggers? (Choose three.)

A. They must be created in a disabled state. B. They can be fired when a privilege is granted to a user. C. They cannot include the WHEN clause. D. They must be created in an enabled state. E. They can be fired either before or after a DDL statement executes. F. They can be fired when a table is truncated. G. They fire only when a DDL statement is executed by the owner of the trigger.

Discussion 0

Correct Answer: E,F,G Vote an answer

Question 3

Which is the correct method to implement a local subprogram in an anonymous block?

A.

B.

C.

D.

Discussion 0

Correct Answer: C Vote an answer

Question 4

Which block of code displays the error message "Incorrect price value"?

A.

B.

C.

D.

Discussion 0

Correct Answer: A Vote an answer

Question 5

Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

A. It will always return a compile time error because it lacks an EXCEPTION section. B. It will always return a run time error because v_raise is not initialized. C. It will set all salaries to 0 if it executes successfully. D. It might return a run time error depending on who invokes it. E. It will always automatically initialize v_raise. F. It will set all salaries to NULL if it executes successfully.

Discussion 0

Correct Answer: E,F Vote an answer

Question 6

Which two are true about collections and RECORD types? (Choose two.)

A. A variable of RECORD type can contain fields of another RECORD type or any collection type. B. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level. C. All collections and RECORD types can be stored in table columns. D. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null. E. Collections and RECORD types are always dense. F. Only associative arrays and nested tables can have elements of RECORD type.

Discussion 0

Correct Answer: D,F Vote an answer

Question 7

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

A. Named subprograms cannot be called from other packages. B. Anonymous blocks must always start with the Declare keyword. C. Named subprograms are stored in the database server. D. A FUNCTION subprogram must return one or more values. E. Anonymous blocks cannot use packaged variables. F. PROCEDURE subprograms can accept parameters. G. FUNCTION subprograms must be called and passed through one or more parameters.

Discussion 0

Correct Answer: C,D,F Vote an answer