Oracle Database 19c: Program with PL/SQL - 1Z0-149 Exam Practice Test

Question 1

Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

A. It will return an error at line 2.

B. It will return an error at line 3.

C. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

D. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

E. It will return an error at line 8.

Correct Answer: C

Question 2

Which is true about EXIT and CONTINUE statements?

A. They can be used in any type of loop.

B. They must use labels.

C. They have the same effect on the execution of a loop.

D. They must have a WHEN condition.

Correct Answer: A

Question 3

Examine this code:

What will be the outcome?

A. It will result in an error as the range of the error code can only be from "-1000 to -2000."

B. It will execute successfully and will display the user-defined error message.

C. It will result in an error as the range of the error code can only be from "-2000 to -2999."

D. It will result in an error as the range of the error code can only be from "-20000 to -20999."

Correct Answer: D

Question 4

Which two are true about lexical units? (Choose two.)

A. Identifiers include labels.

B. Spaces can be embedded in delimiters.

C. Character literals are case-sensitive.

D. All user-defined identifiers must start with an alphabet.

E. A character literal with zero characters has the BOOLEAN value NULL.

Correct Answer: C,D

Question 5

Examine these statements:

Which is true?

A. It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

B. With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

C. It will result in a compilation error for protected_proc because calling_proc does not exist.

D. It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.

Correct Answer: C

Question 6

Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:

What is true about the result?

A. It executes and displays output.

B. It returns an error in line 4.

C. It returns an error in line 9.

D. It returns an error in line 2.

Correct Answer: B

Question 7

Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

A. The PL/SQL compiler can conditionally include selected parts of a program.

B. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.

C. PL/SQL code can be compiled and executed based on different versions of the operating system.

D. Conditional compilation is disabled by default.

E. PL/SQL code can be compiled and executed based on different versions of Oracle.

Correct Answer: A,E

Oracle Database 19c: Program with PL/SQL - 1Z0-149 Exam Practice Test

Latest Update

Useful Links

Contact Us