Free Oracle 1Z0-149 Practice Test & Real Exam Questions

Exam Code/Number: 1Z0-149
Exam Name/Title: Oracle Database 19c: Program with PL/SQL
Certification Provider: Oracle
Corresponding Certification: Oracle Database PL/SQL Developer Certified Professional

Exam Questions: 67
Updated On: Aug 15, 2026

Question #15

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

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

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

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

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

E. This clause can be used only for procedures and functions.

Discussion 0

Correct Answer: A,D Vote an answer

Question #16

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

A. Identifiers include labels.

B. Character literals are case-sensitive.

C. Spaces can be embedded in delimiters.

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

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

Discussion 0

Correct Answer: B,E Vote an answer

Question #17

Which three are true about user-defined functions? (Choose three.)

A. They can appear in the select list of a SELECT statement.

B. They can be used in CONNECT BY and START WITH clauses.

C. They can be executed as standalone commands.

D. They can be used in ORDER BY and GROUP BY clauses.

E. Functions can call only other functions.

F. They must be defined with at least one parameter.

G. They need not return any values.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #18

Which two are true about exception handling? (Choose two.)

A. All declared exceptions are raised implicitly by the runtime system.

B. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.

C. Predefined exceptions are globally declared in the standard package.

D. Internally defined exceptions can be handled only by the OTHERS exception handler.

E. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.

Discussion 0

Correct Answer: C,E Vote an answer

Question #19

In which type of trigger can :OLD and :NEW identifiers be used?

A. AFTER STATEMENT

B. AFTER SUSPEND

C. ROW

D. BEFORE STATEMENT

Discussion 0

Correct Answer: C Vote an answer

Question #20

Which is true about counter variables in a FOR loop?

A. It is accessible outside the body of the loop.

B. It cannot be NULL.

C. It can be modified in the body of the loop.

D. It must explicitly be declared.

Discussion 0

Correct Answer: B Vote an answer

Question #21

User ORA41 executes these statements successfully:
Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)

A. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.

B. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.

C. No update happens even though the procedure executes successfully.

D. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.

E. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.

Discussion 0

Correct Answer: A,B Vote an answer

Download Free Oracle 1Z0-149 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-149 exam.