Infosys Oracle Developer Interview Questions and Answers

Q1. What have you worked on?
Add your answer
Q2. What is a cursor and types?
Ans. 
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
Answered by AI
Add your answer

Q1. How would you monitor a db performance with OEM AWR report?
Ans. 
Monitoring db performance using OEM AWR report
• Access OEM console and navigate to Performance tab

• Select AWR report option to generate a report

• Analyze the report for key performance metrics like CPU usage, memory utilization, I/O stats

• Identify any performance bottlenecks and take necessary actions to optimize db performance
Answered by AI
Add your answer

Maths reasoning english

Problem solving based question

Q1. Basic on location shift jobs etc
Add your answer

Q1. Networking database Linux windows
Add your answer

Q1. Tell about yourself
Ans. 
Experienced Oracle DBA with 5+ years of hands-on experience in managing databases, optimizing performance, and ensuring data security.
• 5+ years of experience as an Oracle DBA

• Proficient in database management, performance optimization, and data security

• Skilled in troubleshooting and resolving database issues

• Strong knowledge of Oracle database architecture and SQL

• Certified Oracle Database Administrator (OCA/OCP)
Answered by AI
Add your answer

Q1. Purpose of po ,O2C cycle, P2P cycle discussion, debit memo, credit memo, inventory topics
Ans. 
Discussion on PO, O2C cycle, P2P cycle, debit memo, credit memo, and inventory topics for Oracle SCM Functional Consultant role.
• PO (Purchase Order) is a document used to request goods or services from a supplier.

• O2C (Order to Cash) cycle involves the entire process from receiving an order to receiving payment.

• P2P (Procure to Pay) cycle involves the entire process from identifying a need to paying the supplier.

• Debit mem...read more
Answered by AI
Add your answer
Q2. Key flexifields, order to cash
Add your answer
Q3. Advance priceing,cash memo
Add your answer

Q1. Examples of day to day issues
Add your answer

Q1. Communication with client
Add your answer
Q2. How frequently communication with client
Ans. 
Frequent communication with the client is crucial for successful project delivery.
• Regular status updates should be provided to the client.

• Communication should be maintained through various channels such as emails, phone calls, and meetings.

• Client feedback should be taken into consideration and addressed promptly.

• Communication frequency may vary depending on the project phase and client requirements.

• Effective communicat...read more
Answered by AI
Add your answer