PL/SQL and Oracle Apps HRMS interview questions

To begin with , I will initially post some common interview question topics for PL/SQL developer and Oracle Apps HRMS. These questions really helped me lot for cracking interviews at an experience level of 2-3 years.

PL/SQL Topics   —->>
Constraints
Truncate and Delete
Cursor -Explicit ,Implicit cursor
lead and Lag function
Exception
Pragma exception init
Raise application error
Collection
bulk collect and for all
DDL and DML
Triggers
Performance Tuning
Pragma autonomous transaction
Reference cursor
Cursor Attributes
Rank and Dense Rank
how view can be updated with multiple table (Instead of trigger )
Global temporary table
Pseudo columns
Types of Indexes
Types of pay elements
what is standard Link
Diff between nested table and v array
Annualization factor
Oracle packages used
%Rowtype
Can DDL statement be used in PL/Sql Block
Difference between Rownum and row_number

Oracle Apps HRMS Topics —>

Eit and Sit
KFF and DFF
System Profile
termination of pay elements
AME
Costing
Concurrent program
rehire and Reverse termination
Balances and dimension
Costing and types of costing
Joins
Qualifiers
Multi Organization structure
Payroll processing types
Valueset and Look up
Job and position
payment methods
payroll processing types
Date track mode
Security Profile
User Tables
Pay Query Explanation

Please atleast go through these topics ,you will definitely crack the interview.

Suggestion are always welcome .

Thank you 🙂

Advertisements