i
Infosys
Compare
Filter interviews by
Infosys Oracle Developer Interview Questions and Answers
Infosys Oracle Developer Interview Experiences
1 interview found
I was interviewed in Mar 2024.
(1 Question)
- 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...
Skills evaluated in this interview
What people are saying about Infosys
Interview questions from similar companies
I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.
(1 Question)
- Q1. Mainly they focus on PLSQL query .
(2 Questions)
- Q1. What have you worked on?
- 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
Interview Preparation Tips
I applied via Referral and was interviewed in Sep 2021. There were 2 interview rounds.
Interview Questionnaire
1 Question
- Q1. Oracle questions
I applied via Company Website and was interviewed in May 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. In Tr they have asked basics questions related to java like oops concepts
Interview Preparation Tips
Oracle Database Administrator Interview Questions & Answers
Accenture
Anonymous
posted on 10 Jan 2025
I applied via Approached by Company and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell me the high level overview of dataguard installation?
- Q2. What are your daily tasks adn what things you handel in your team?
(2 Questions)
- Q1. Dataguard architecture
- Q2. Rman backup and restoration
(1 Question)
- Q1. Why you join inm
- Ans.
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
Oracle Technical Consultant Interview Questions & Answers
LTIMindtree
Anonymous
posted on 29 May 2024
(2 Questions)
- Q1. How does an interface works?
- Ans.
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.
- Q2. How does an HCM Extract work?
- Ans.
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...
Oracle Database Administrator Interview Questions & Answers
DXC Technology
Anonymous
posted on 9 Sep 2024
(1 Question)
- 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)
(2 Questions)
- Q1. Tell me something about yourself
- Q2. What is your current ctc
Interview Preparation Tips
Infosys Interview FAQs
Tell us how to improve this page.
Infosys Interviews By Designations
- Infosys System Engineer Interview Questions
- Infosys Software Engineer Interview Questions
- Infosys Technology Analyst Interview Questions
- Infosys Associate Consultant Interview Questions
- Infosys Senior Systems Engineer Interview Questions
- Infosys Software Developer Interview Questions
- Infosys Business Analyst Interview Questions
- Infosys Senior Associate Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- Oracle SCM Functional Consultant Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- Oracle HCM Functional Consultant Interview Questions
- Oracle Apps DBA Interview Questions
- Oracle Financial Functional Consultant Interview Questions
- Oracle Technical Consultant Interview Questions
- Oracle Functional Consultant Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Infosys Oracle Developer Reviews and Ratings
based on 1 review
Rating in categories
|
Technology Analyst
56.3k
salaries
|  ₹3 L/yr - ₹11 L/yr |
|
Senior Systems Engineer
50k
salaries
| ₹2.8 L/yr - ₹8 L/yr |
|
System Engineer
39.2k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
|
Technical Lead
30.7k
salaries
| ₹5.2 L/yr - ₹19.5 L/yr |
|
Senior Associate Consultant
27.4k
salaries
| ₹6.2 L/yr - ₹16.8 L/yr |
TCS
Wipro
Cognizant
Accenture
- Home >
- Interviews >
- Infosys Interview Questions >
- Infosys Oracle Developer Interview Questions
