Job Interview Questions about Programmatic Constructs for Oracle Database Admin Job:

What do you understand by a Procedure?

What do you mean by a package?

List the various benefits of packages.

What is the purpose of Database Trigger?

Explain the various differences between Integrity Constraints and Database Trigger.

How are procedures and functions different from each other?

What do you mean by database trigger? Why do we need it?

List the various types of PL/SQL program units which exist in oracle database.