TCS Oracle Developer Interview Questions and Answers

Q1. 1 Write a procedure using user defined exception 2 write a procedure to get error, if updating end of the month. Etc....
Ans. 
Creating procedures with user defined exceptions and handling errors when updating at end of month.
• Create a procedure with a user defined exception using 'RAISE_APPLICATION_ERROR' and 'EXCEPTION' keywords.

• Use 'TO_CHAR(SYSDATE, 'DD')' to check if it is the end of the month before updating.

• Handle the error by raising an exception if the update is attempted at the end of the month.

• Example: CREATE OR REPLACE PROCEDURE upda...read more
Answered by AI
Add your answer

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. What is the role of Oracle DBA
Ans. 
The role of an Oracle DBA is to manage and maintain Oracle databases to ensure they are secure, efficient, and reliable.
• Installing and upgrading Oracle software

• Configuring and monitoring database performance

• Backup and recovery of data

• Troubleshooting and resolving database issues

• Implementing security measures to protect data

• Managing users and permissions
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