Upload Button Icon Add office photos

Filter interviews by

Clearing Corporation of India Oracle Database Administrator Interview Questions and Answers

Updated 19 Mar 2022

Clearing Corporation of India Oracle Database Administrator Interview Experiences

1 interview found

I applied via Naukri.com

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 tips
Round 2 - Technical 

(1 Question)

  • Q1. Rman backups , daily tasks
Round 3 - HR 

(5 Questions)

  • Q1. What are your salary expectations?
  • Ans. 

    I expect a competitive salary based on my experience and the responsibilities of the role.

    • Research the average salary range for Oracle Database Administrators in your area

    • Consider your level of experience and expertise

    • Factor in the responsibilities and requirements of the specific role

    • Be prepared to negotiate and discuss benefits and perks

    • Example: I expect a salary in the range of $80,000 to $100,000 per year.

  • Answered by AI
  • Q2. What is your family background?
  • Ans. 

    My family background is diverse and multicultural, with members from different countries and professions.

    • My parents are from different countries, which has exposed me to different cultures and traditions.

    • My father is a doctor and my mother is an engineer, so I have been influenced by both the medical and technical fields.

    • I have relatives who are teachers, artists, and entrepreneurs, which has given me a broad perspecti...

  • Answered by AI
  • Q3. Share details of your previous job.
  • Ans. 

    I worked as a Database Administrator at XYZ Company.

    • Managed and maintained Oracle databases for multiple clients.

    • Performed regular backups and recovery operations.

    • Optimized database performance by tuning SQL queries and indexes.

    • Implemented security measures to protect sensitive data.

    • Troubleshot and resolved database issues and errors.

    • Collaborated with development teams to design and implement database solutions.

    • Provide...

  • Answered by AI
  • Q4. Why are you looking for a change?
  • Ans. 

    Seeking new challenges and growth opportunities in a dynamic work environment.

    • Looking for a change to expand my skill set and knowledge

    • Seeking new challenges and opportunities for professional growth

    • Interested in working in a more dynamic and innovative work environment

    • Want to explore new technologies and stay updated in the field

    • Seeking better work-life balance or location convenience

  • Answered by AI
  • Q5. Tell me about yourself.
  • Ans. 

    I am an experienced Oracle Database Administrator with a strong background in managing and optimizing database systems.

    • Over 5 years of experience in Oracle database administration

    • Proficient in performance tuning, backup and recovery, and database security

    • Extensive knowledge of Oracle Database versions 11g, 12c, and 19c

    • Implemented high availability solutions using Oracle Data Guard

    • Managed large-scale databases with tera...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn basics of Oracle and SQL ,mongo db.. though oracle is enough

Interview questions from similar companies

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

I appeared for an interview in Jan 2025.

Round 1 - Coding Test 

Focused on the functionality of hashmaps and sorting.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Follow up questions based on coding test.
  • Q2. Multiple systems design questions starting with different design patterns and principles, Database sharding, cap theorem. Multiple concepts from springboot were asked.
Round 3 - One-on-one 

(1 Question)

  • Q1. More focused on system design, task scheduler and db schema etc. Also multiple questions from resume.

Interview Preparation Tips

Interview preparation tips for other job seekers - Concentrate on grasping the fundamental concepts instead of merely memorizing a few solutions. Always articulate your thoughts, strive to comprehend the problem, pose questions, and consider various solutions along with their advantages and disadvantages.

I applied via Referral and was interviewed before Oct 2021. There were 3 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 tips
Round 2 - HR 

(1 Question)

  • Q1. Basic screening questions
Round 3 - Oper 

(1 Question)

  • Q1. Questions on Basics finance terminology Capital markets Fund accounting

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush the accounts knowledge and skills.
Go with positive mindset.

Interview Questionnaire 

6 Questions

  • Q1. Comfortable with night shift
  • Ans. 

    Yes, I am comfortable with night shifts as I have prior experience working during those hours.

    • I have previous experience working night shifts at my previous job.

    • I am able to adjust my sleep schedule to accommodate working at night.

    • I understand the importance of being alert and focused during night shifts.

    • I am willing to work night shifts if required for the position.

  • Answered by AI
  • Q2. Package discussion
  • Q3. Normal finance like what is derivatives typea of derivatives
  • Q4. Where do you see in next few years in the company
  • Ans. 

    I see myself taking on more responsibilities and contributing to the growth and success of the company.

    • Continuing to excel in my current role and seeking opportunities for advancement

    • Building strong relationships with colleagues and mentors to learn and grow

    • Staying updated on industry trends and technologies to bring innovative ideas to the table

  • Answered by AI
  • Q5. Why should we hier you
  • Ans. 

    I have the relevant skills, experience, and passion to excel in this role.

    • I have a strong track record of success in similar roles.

    • I possess the necessary qualifications and certifications.

    • I am highly motivated and eager to contribute to the team.

    • I have excellent communication and problem-solving skills.

    • I am a quick learner and adaptable to new challenges.

  • Answered by AI
  • Q6. What are your personal and professional goals towaRDS the company
  • Ans. 

    My personal goal is to grow within the company by taking on new challenges and responsibilities. Professionally, I aim to contribute to the company's success through my hard work and dedication.

    • Continuously improve my skills and knowledge through training and development opportunities

    • Seek out leadership roles and projects that allow me to showcase my abilities

    • Build strong relationships with colleagues and clients to fo

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Aptitude test

I applied via Campus Placement and was interviewed before Jan 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Subject related question most of them were based on capital markets.

Interview Preparation Tips

Interview preparation tips for other job seekers - If you have good knowledge of capital market you will definitely get selected.
I would advise to get some information on investment banking.

I applied via Referral and was interviewed before Aug 2021. 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 tips
Round 2 - HR 

(1 Question)

  • Q1. Financial Markets, shares, debentures financial reports making overall excel outlook questions

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are a fresher then State street syntel provides you excellent opportunity to work with Finance KPO industry where you can gain good experience of Investment banking operations. But if you get hired here then ready to pull up your socks & lot of hard work with minimal pay & lot of stretch with no overtime paid

Interview Questionnaire 

7 Questions

  • Q1. Choose between Mahatma Gandhi and Subhash Chandra Bose.
  • Ans. 

    Both Mahatma Gandhi and Subhash Chandra Bose were important figures in India's struggle for independence.

    • Mahatma Gandhi was a non-violent activist who led the Indian National Congress and played a key role in India's independence movement.

    • Subhash Chandra Bose was a militant nationalist who formed the Indian National Army to fight against British rule.

    • Both had different ideologies and approaches towards achieving indepe...

  • Answered by AI
  • Q2. What would you do if you were given 1 lakh and were told to jump off the first floor? 5 lakh for the 2nd floor? 10 for the 3rd floor?
  • Ans. 

    I would not jump off any floor for any amount of money as it is a dangerous and foolish act.

    • I would politely decline the offer and explain that my safety and well-being are more important than any amount of money.

    • Jumping off any floor, regardless of the amount of money offered, is a dangerous and potentially life-threatening act.

    • I would suggest finding a safer and more productive way to earn money.

    • I would also question...

  • Answered by AI
  • Q3. I give you 5 lakhs right now. Go and kiss the girl standing outside. Will you take the risk?
  • Q4. Calculate 12*92 within 15 seconds (without the pen of course)
  • Ans. 

    Answer: 1104

    • Use multiplication rules to simplify calculation

    • Break down numbers into smaller parts

    • Use mental math techniques like rounding and estimation

  • Answered by AI
  • Q5. 657*53 within 15 seconds (again without the pen)
  • Q6. The interviewer asked me the length of the room. I said that it was around 18 feet. He asked me to convince him of the same
  • Q7. Question about finance sector and related to company profile and share trading were asked. Main emphasis was on observation skills and stress testing of students

Interview Preparation Tips

Round: Test
Experience: Two tests completely based on mathematical and logical aptitude and Interviews.
Top 10 rankers of Trade Mogul competition(Trading competition conducted by Future First) are directly called for interview.
Total Questions: 2

Round: Test
Experience: Their sole purpose was to know whether you are capable of handling mathematical calculations easily and quickly. You just need to practice lots of multiplication, division and other simple stuff so that you become quick during the test.
Duration: 30 minutes

Round: HR Interview
Experience: - Choose between Mahatma Gandhi and Subhash Chandra Bose. I personally, would advise you to go for Mahatma Gandhi. If you go for Bose, they will reject you saying that you have a violent side to your personality which of course is not good for them.- What would you do if you were given 1 lakh and were told to jump off the first floor? 5 lakh for the 2nd floor? 10 for the 3rd floor?
Assess the risk in every situation and then using your reasoning, give the answer. I answered that for the amount of money involved i would jump off the 1st and 2nd floors but not the 3rd floor. At maximum I would break my bones or suffer a few fractures which is good enough for the money.
-I give you 5 lakhs right now. Go and kiss the girl standing outside. Will you take the risk?
I said yes I will. She will slap me on the face or maybe get a complaint registered against me with the Dean. It will be a fair deal for the money involved.
-I said, “Sir, my height is about 6 feet. So if I lie down 3 times along the length that should be enough reason for you to get convinced”. So I lied down on the floor along the length of the room thrice.The HR interview was a very different experience for me. I felt that they were looking for a guy who would fit best in their culture and has the ability not only to take risks but also assess it and mitigate it. Besides this they also asked me some HR questions like why should we hire you, what are your goals and why are you suitable for the company. There were few other HR questions as well which were not so different form the regular ones.Overall it was a very good interview experience. They were looking for people who can take risks and were not hesitant to take an initiative and then back their decision with sound thought process.

Skills: Algorithm, maths, Social
College Name: na

Interview Questionnaire 

1 Question

  • Q1. 1.Tell me about yourself? 2. What are your strengths and weaknesses 3. Why trading? 4. What are the strategies you've used on trade mogul? 5. What was the toughest decision you ever had to make? 6. Who ha...
  • Ans. 

    I am a motivated individual with a passion for trading and a strong desire to learn and grow in the industry.

    • Strengths: Analytical skills, quick decision-making, adaptability

    • Weaknesses: Perfectionism, tendency to overthink

    • Trading: Fascinated by the dynamics of financial markets and the potential for profit

    • Strategies on Trade Mogul: Utilizing technical analysis, risk management techniques

    • Toughest decision: Choosing betw...

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: On the basis of your one-month performance on trade mogul.

I applied via Walk-in and was interviewed before Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Finance, English aptitude questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview consist of GD, HR round , aptitude and final round.

I applied via Referral and was interviewed before Oct 2019. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Capital Market
  • Q2. All related to Banking and Finance question

Interview Preparation Tips

Interview preparation tips for other job seekers - Must prepare with Banking and Finance might be you guys learnt in your college or in MBA finance

Clearing Corporation of India Interview FAQs

How many rounds are there in Clearing Corporation of India Oracle Database Administrator interview?
Clearing Corporation of India interview process usually has 3 rounds. The most common rounds in the Clearing Corporation of India interview process are Resume Shortlist, Technical and HR.

Tell us how to improve this page.

Assistant Manager
57 salaries
unlock blur

₹6 L/yr - ₹16.3 L/yr

Senior Executive Officer
44 salaries
unlock blur

₹5.5 L/yr - ₹10 L/yr

Deputy Manager
41 salaries
unlock blur

₹10 L/yr - ₹20.3 L/yr

Executive Officer
34 salaries
unlock blur

₹3.5 L/yr - ₹7.2 L/yr

Assistant Manager II
12 salaries
unlock blur

₹6 L/yr - ₹14 L/yr

Explore more salaries
Compare Clearing Corporation of India with

State Street Syntel

3.7
Compare

Indusind Marketing & Financial Services

3.9
Compare

Home First Finance Company India

3.7
Compare

Pamac Finserve

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