Infosys Oracle Developer Interview Questions and Answers

A cursor is a database object used to manipulate data in a result set.

• A cursor is used to retrieve and manipulate data row by row.

• Types of cursors include implicit, explicit, and forward-only cursors.

• Implicit cursors are automatically created by Oracle when executing a SQL statement.

• Explicit cursors are created by the developer and allow for more control over the result set.

• Forward-only cursors only allow for iterating

I joined inm because of the company's reputation for innovation and growth in the tech industry.

• Attracted to company's reputation for innovation

• Excited about opportunities for growth in tech industry

• Impressed by company culture and values

An interface acts as a bridge between two systems, allowing them to communicate and exchange data.

• Interfaces define a set of methods that a class must implement.

• They provide a way for different systems to interact with each other.

• Interfaces can be used to achieve abstraction and polymorphism in programming.

• Example: JDBC (Java Database Connectivity) provides an interface for connecting Java applications to databases.

HCM Extract is a tool in Oracle HCM Cloud that allows users to extract and transfer data from the system.

• HCM Extracts are used to extract data from Oracle HCM Cloud for reporting, analysis, or integration purposes.

• Users can define the data to be extracted, the format of the output, and the delivery method.

• HCM Extracts can be scheduled to run at specific times or triggered based on certain events.

• Extracted data can be t...read more