Online 1Z0-149 Practice Test

Question 1

Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with

%ROWTYPE? (Choose three.)

Options :

A : CREATE

B : DROP

C : UPDATE

D : SELECT

E : DELETE

F : ALTER

G : INSERT

Answer: A,C,D

Question 2

View the Exhibit to examine the PL/SQL code.

Identify the correct output for the code.

Options :

A : King 17-JUN-87 1500

B : King 17-JUN-87 24000

C : King current sysdate 1500

D : King current sysdate 24000

Answer: C

Question 3

View the Exhibit and examine the structure of the EMP table.

2021-06-04-19-29-02-aa50ebaef8605bb516f71bdc2da495c5

Examine the code of the packages that you have created.

You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?

Options :

A : It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.

B : It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.

C : It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.

D : It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.

Answer: B

Question 4

Subprograms are named PL/SQL blocks that can be called with a set of parameters.

Options :

A : True

B : False

C : Depends upon

D : None of the above

Answer: A

Question 5

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

EXPERTY DESIGNED 1Z0-149 PRACTICE TEST