Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Titan Company Team. If you also belong to the team, you can get access from here

Titan Company Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Clear (1)

Titan Company Oracle Application Technical Consultant Interview Questions, Process, and Tips

Updated 18 Oct 2024

Titan Company Oracle Application Technical Consultant Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(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 ...

  • Answered by AI
  • 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.

  • Answered by AI
  • 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.

  • Answered by AI
  • 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...

  • Answered by AI
  • Q5. Concat function

Skills evaluated in this interview

Interview questions from similar companies

I was interviewed before Jul 2016.

Interview Preparation Tips

Round: Test
Experience: In that question paper they ask about general knowledge, mathematics and about politics also.
Tips: No tips
Duration: 1 hour 15 minutes
Total Questions: 30

Round: Resume Shortlist
Experience: They select out of 85 - 30.
Then they take interview for this 30 people.
Out of 30 they select 16 for giving job.
Tips: No tips

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Jan 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. What expected this job ?
  • Q2. How much salary expectations ,

Interview Preparation Tips

Interview preparation tips for other job seekers - Full
confidence
be
coll
Faceking any Questions and answers
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. Experience test
  • Q2. Study & family back ground
Round 3 - Aptitude Test 

Father work & salary amount choose

I applied via Walk-in and was interviewed in Jan 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - HR 

(1 Question)

  • Q1. What are your salary expectations?

Interview Preparation Tips

Topics to prepare for Joyalukkas Sales Executive interview:
  • Solid Works
Interview preparation tips for other job seekers - I want job sir plese give me the

I applied via Campus Placement and was interviewed in Sep 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about yourself, about joyalukkas thats it
  • Q2. Campus selection in collage
  • Ans. 

    Yes, I was selected through campus placement in my college.

    • I was shortlisted based on my academic performance and communication skills.

    • I went through multiple rounds of interviews and assessments.

    • Finally, I was offered a job by a reputed company through campus placement.

    • This experience helped me gain valuable insights into the recruitment process and the expectations of employers.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - You need to work all day in the showroom ,you should sacrifice your life .. 12 to 13 hours work
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. About education Family background Experience etc
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via AmbitionBox and was interviewed in Jun 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

Good character and good behaviour

Round 2 - Group Discussion 

All everything possible

Round 3 - One-on-one 

(7 Questions)

  • Q1. Inter and deplom
  • Q2. English and Telugu
  • Q3. I am interestedu joyalukkas jewellery
  • Q4. No remarks and good store
  • Q5. I like you joyalukkas jewellery
  • Q6. I am interested joyalukkas jewellery
  • Q7. Best store and best collections
Round 4 - Coding Test 

K.padma
Age 30
Kakinada

Interview Preparation Tips

Interview preparation tips for other job seekers - Joyalukkas best store and best collections
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Aug 2023. There was 1 interview round.

Round 1 - One-on-one 

(5 Questions)

  • Q1. Self introduction
  • Q2. Compromise With Salary
  • Ans. 

    Negotiate based on value, benefits, and growth opportunities rather than compromising on salary.

    • Highlight your skills, experience, and achievements that justify your desired salary

    • Discuss potential for performance-based bonuses or commission

    • Negotiate for additional benefits like flexible work hours, remote work options, or professional development opportunities

  • Answered by AI
  • Q3. Compromise selected location
  • Ans. 

    It is important to consider compromising on the selected location if it benefits the overall sales strategy.

    • Consider the potential customer base in the new location

    • Evaluate the competition in the new location

    • Assess the logistical and cost implications of changing the location

    • Discuss with the team and stakeholders to gather their input

    • Be open to exploring new opportunities that may arise from a different location

  • Answered by AI
  • Q4. Joining Process Quickly
  • Q5. Every one selecting while interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Dont Choose GRT, Working Hours Are Heavy, Torcher From Management But All Staffs Are Very Friendly
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. Gold chain and gold ring standard size?
  • Ans. 

    The standard size for gold chains and rings varies depending on the design and style.

    • Gold chains come in various lengths ranging from 16 inches to 24 inches.

    • Gold rings have different sizes based on the circumference of the finger.

    • The most common ring sizes for women are between 5 and 7, while for men, it's between 8 and 10.

    • Some jewelers offer custom sizing for both chains and rings.

  • Answered by AI
  • Q2. Diamond 22ct weight?
  • Ans. 

    Diamond 22ct weight is a measure of the weight of a diamond.

    • 22ct weight refers to the carat weight of a diamond

    • Carat weight is one of the 4Cs used to grade diamonds

    • A 22ct diamond is a very large and valuable diamond

  • Answered by AI
Round 3 - Aptitude Test 

Mathematics calculation
Ificiccicc
Iggigg8
Igig8g

Interview Preparation Tips

Interview preparation tips for other job seekers - Think first than answering and be calm.
H0offflfflvfvlffpglvcdkcluffifovodsffidgg
Contribute & help others!
anonymous
You can choose to be anonymous

Titan Company Interview FAQs

How many rounds are there in Titan Company Oracle Application Technical Consultant interview?
Titan Company interview process usually has 1 rounds. The most common rounds in the Titan Company interview process are Technical.
What are the top questions asked in Titan Company Oracle Application Technical Consultant interview?

Some of the top questions asked at the Titan Company Oracle Application Technical Consultant interview -

  1. How will we handle exceptions in Bulk Colle...read more
  2. what is pragma autonomous transacti...read more
  3. what are Cursor attribut...read more

Recently Viewed

INTERVIEWS

Air Liquide

5.6k top interview questions

CAMPUS PLACEMENT

PSG College of Technology, Coimbatore

CAMPUS PLACEMENT

Pondicherry University

CAMPUS PLACEMENT

SRM university (SRMU)

INTERVIEWS

Euler Motors

No Interviews

INTERVIEWS

Titan Company

No Interviews

INTERVIEWS

Euler Motors

No Interviews

INTERVIEWS

Air Liquide

No Interviews

INTERVIEWS

Air Liquide

No Interviews

INTERVIEWS

1Digital Stack

No Interviews

Tell us how to improve this page.

Titan Company Oracle Application Technical Consultant Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Senco Gold Interview Questions
4.5
 • 558 Interviews
Vishal Mega Mart Interview Questions
3.7
 • 157 Interviews
V-Mart Interview Questions
4.1
 • 146 Interviews
Reliance Digital Interview Questions
4.1
 • 117 Interviews
Shoppers Stop Interview Questions
4.1
 • 111 Interviews
Decathlon Interview Questions
3.9
 • 101 Interviews
Trent Interview Questions
4.0
 • 76 Interviews
Tanishq Interview Questions
4.4
 • 71 Interviews
View all
Retail Sales Officer
238 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Executive
214 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Area Business Manager
204 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Deputy Manager
199 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Engineer
186 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Titan Company with

PC Jewellers

3.9
Compare

Malabar Gold and Diamonds

4.1
Compare

Kalyan Jewellers

4.6
Compare

Tanishq

4.4
Compare
Did you find this page helpful?
Yes No
write
Share an Interview