AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Titan Company
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Titan Company Oracle Application Technical Consultant Interview Questions, Process, and Tips
Titan Company Oracle Application Technical Consultant Interview Experiences
1 interview found
Oracle Application Technical Consultant Interview Questions & Answers
santosh patangi
posted on 18 Oct 2024
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
(5 Questions)
- Q1. Difference between decode and case?
- Ans.
Decode is a function in Oracle that is used to provide if-then-else type of logic, while Case is used for conditional logic with multiple conditions.
Decode is used for simple if-then-else logic, while Case is used for more complex conditional logic.
Decode can only handle equality conditions, while Case can handle a variety of conditions.
Case allows for multiple conditions and multiple results, while Decode only allows ...
- Q2. How will we handle exceptions in Bulk Collect?
- Ans.
Exceptions in Bulk Collect can be handled using SAVE EXCEPTIONS clause and FORALL statement.
Use SAVE EXCEPTIONS clause to handle exceptions in Bulk Collect.
Use FORALL statement to process the data and handle exceptions efficiently.
Exceptions can be logged, ignored, or handled based on the business requirements.
- Q3. What are Cursor attributes?
- Ans.
Cursor attributes are properties that provide information about the status of a cursor in PL/SQL.
Cursor attributes include %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN.
They are used to check the status of a cursor after a DML operation.
For example, %FOUND returns TRUE if a fetch operation successfully retrieves a row.
- Q4. What is pragma autonomous transaction?
- Ans.
Pragma autonomous transaction is used to create a new transaction within the current transaction.
Pragma autonomous transaction allows a subprogram to start a new transaction that is independent of the calling transaction.
This is useful when you need to commit or rollback changes made by the subprogram without affecting the main transaction.
It is commonly used in triggers, where you want to perform some actions independ...
- Q5. Concat function
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Anonymous
I applied via Job Portal and was interviewed in Mar 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Exprence,timeing,hard work
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. General knowledge
Rounak Dey
(2 Questions)
- Q1. What is your cgpa
- Ans.
My CGPA is 3.8 out of 4.0.
My CGPA is 3.8
It is on a scale of 4.0
I have consistently maintained a high CGPA throughout my academic career
- Q2. What is your latest qualification
- Ans.
I have recently completed my Bachelor's degree in Computer Science
Bachelor's degree in Computer Science
Completed in May 2021
Focused on software development and programming languages
Interview Preparation Tips
Chaitanya Joshi
The topic was very unique
(1 Question)
- Q1. Sales strategy and other questions related to sales
I applied via Naukri.com and was interviewed in Mar 2022. There were 2 interview rounds.
Work
It's a very hectic daily job
Interview Preparation Tips
Akshay Dhande
I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.
Assignment on internship project
(2 Questions)
- Q1. Why join Tata Trent
- Ans.
Tata Trent offers a dynamic work environment with opportunities for growth and learning.
Tata Trent is a well-established company with a strong reputation in the retail industry.
The company values innovation and creativity, providing employees with a platform to showcase their talents.
There are ample opportunities for career advancement and skill development within the organization.
- Q2. Why join retail sector
- Ans.
Joining the retail sector offers opportunities for growth, customer interaction, and learning about various products and services.
Opportunity for career growth and advancement
Interacting with diverse customers and building relationships
Learning about different products and services
Experiencing fast-paced and dynamic work environment
I applied via Campus Placement and was interviewed in Jul 2020. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. First paly game
- Q2. And second question is group decision topic
- Q3. Third question is mathmatical and Company related and sport related question
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Jun 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Tell me something about your self
- Q2. Tell me something about qualification and family details
Interview Preparation Tips
- Induction Program
Basic Gk Questions or current affairs
(2 Questions)
- Q1. Tell me about yourself
- Q2. Why do you want to join us?
Titan Company Interview FAQs
Tell us how to improve this page.
Titan Company Interviews By Designations
- Titan Company Retail Sales Officer Interview Questions
- Titan Company Graduate Engineer Trainee (Get) Interview Questions
- Titan Company Sales Executive Interview Questions
- Titan Company Software Developer Interview Questions
- Titan Company Area Business Manager Interview Questions
- Titan Company Intern Interview Questions
- Titan Company Senior Engineer Interview Questions
- Titan Company Marketing Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle SCM Functional Consultant Interview Questions
- Oracle Technical Consultant Interview Questions
- Oracle Financial Functional Consultant Interview Questions
- Oracle Database Administrator Interview Questions
- Oracle Functional Consultant Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- Oracle Developer Interview Questions
- Oracle Consultant Interview Questions
- Show more
Titan Company Oracle Application Technical Consultant Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Area Business Manager
245
salaries
|  ₹8.6 L/yr - ₹30 L/yr |
|
Store Manager
216
salaries
| ₹1 L/yr - ₹9 L/yr |
|
Retail Sales Officer
216
salaries
| ₹1.5 L/yr - ₹7.8 L/yr |
|
Deputy Manager
214
salaries
| ₹6.8 L/yr - ₹21 L/yr |
|
Sales Executive
212
salaries
| ₹1 L/yr - ₹6.4 L/yr |
Reliance Digital
Vishal Mega Mart
Shoppers Stop
V-Mart
- Home >
- Interviews >
- Titan Company Interview Questions >
- Titan Company Oracle Application Technical Consultant Interview Questions
