Question 1

View the Exhibit to examine the PLSQL block.

Which statement is true about the output of the PL/SQL block?

Options :

A : It executes and the Output is emprec.deptname: .

B : It executes and the Output is emprec.deptname: Sales.

C : It produces an error because NULL is assigned to the emprec.empid field in the record

D : It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.

Answer: A

Question 2

Which two blocks of code execute successfully?

Options :

A : DECLARE SUBTYPE new_one IS BINARY_INTERGER RANGE 0..9;my_val new_one;BEGIN my_val :=0;END;

B : DECLARE SUBTYPE new_string IS VARCHAR2 (5) NOT NULL; my_str_new_string;BEGIN my_str := abc;END;

C : DECLARE SUBTYPE new_one IS NUMBER (2, 1); my_val new_one; BEGIN my_val :=12.5; END;

D : DECLARE SUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL;my_val new_one;BEGIN my_val :=2;END;

E : DECLARE SUBTYPE new_one IS NUMBER (1, 0);my_val new_one; BEGIN my_val := -1

Answer: A

Question 3

Which kind of parameters cannot have a DEFAULT value?

Options :

A : OUT

B : IN

C : CONSTANT

D : R(ead)

E : W(rite)

Answer: A

Question 4

View the Exhibit to examine the PL/SQL block.Which statement is true about the execution of the PL/SQL block?

Options :

A : It executes successfully and gives the desired output.

B : It does not execute because the definition of type population is indexed by VARCHAR2.

C : It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.

D : It does not execute because the value that is once assigned to the element of the associative array cannot be changed.

Answer: C

Question 5

Which of the following is not true about labeling PL/SQL loops?

Options :

A : PL/SQL loops can be labeled.

B : The label should be enclosed by angle brackets (< and >).

C : The label name appears at the beginning of the LOOP statement.

D : The label name can also appear at the end of the LOOP statement or with an EXIT statement.

Answer: B

Free 1Z0-149 Mock Exam – Practice Online Confidently