AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
TCS
Compare
Filter interviews by
TCS Oracle Apps DBA Consultant Interview Questions and Answers
TCS Oracle Apps DBA Consultant Interview Experiences
1 interview found
Anonymous
Selected
I applied via Job Portal and was interviewed before Mar 2023. There was 1 interview round.
(2 Questions)
- Q1. Row chaining in clusterware
- Ans.
Row chaining in clusterware refers to the situation where a row in a table is too large to fit in a single data block.
Row chaining occurs when a row's data is split across multiple blocks because it is too large to fit in one block.
This can lead to performance issues as multiple I/O operations are required to retrieve the complete row.
To avoid row chaining, it is important to properly design the table structure and con...
- Q2. Db buffer cache
Interview Preparation Tips
- Oracle
Interview questions from similar companies
I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Explain your project?
- Q2. Write sql query for this scenarios?
- Ans.
SQL query for scenario
Identify the tables involved
Determine the columns needed
Specify the conditions for filtering data
Use appropriate joins to combine tables
- Q3. Write the code read json as spark data frame
- Ans.
Code to read JSON as Spark DataFrame
Use SparkSession to create a DataFrameReader
Specify the JSON file path and schema
Use the reader to load the JSON file as a DataFrame
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jan 2020. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Past experience and scenario based questions, where on a specific scenario what will be the step by step process one will follow to identify an issue and solve it.
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.
(1 Question)
- Q1. Normal java and springboot qustion regarding project and prepare well for java8 with dept knowledge
(1 Question)
- Q1. Salary negotiation with 10 sec call
Interview Preparation Tips
- Java 8
- Spring Boot
- MySQL
- spring core
- Spring
honorednoni
I applied via Campus Placement and was interviewed before Jul 2021. There were 3 interview rounds.
There are 30 questions in Appetitive
Find the occurrence of character in a string?
Interview Preparation Tips
- Java
- DS
- MySQL
I applied via Referral and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Basic questions and most important confidence level is checked
- Q2. I have given all answers and in some of the question I will confused
Interview Preparation Tips
I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. I attended for a role Associate Consultant. The interview was quite easy. It's a half an hour interview and interviewer asked basic questions of my domain
Interview Preparation Tips
Interview Preparation Tips
Experience: Aptitude test majorly comprise of Quants ,Data Interpretation and English (majorly RC's) ....slightly on the higher side of R.S agrawall.Would recommend Arun Sharma's 3 books (quant,verbal and DI +reasoning ) . If you are already preparing for CAT , entire process would be like a MOCK test
Tips: Selection Process:- Written Round + GD+ PI (As in 2011 )
All rounds were eliminatory.
Eligibility :- 70 % throughout
CTC :- 4 L
Bond :- 2 Years / 1 lakh (You can easily do away with bond until 6 months of your joining,in case you get into some better organisation (Read PSU for non CS/IT people) . No company will sue you for bond amount . But if time spent is more than 6 months and you are joining another IT company , then it might land you in trouble ,because all IT company do a background verification )
Round: HR Interview
Experience: Interviews generally are non technical and revolve around 'why this company' and 'why you' .Highly NOT recommended for those who want to grow their technical expertise . Headstrong works in Capital Markets and you can expect good exposure to BFSI domain.
College Name: BIT MESRA
I applied via Naukri.com and was interviewed in Nov 2017. There were 5 interview rounds.
Interview Questionnaire
2 Questions
- Q1. It was basically a written round. Questions were based on Core Java , Spring and Hibernate
- Q2. Questions on Project I have previously worked on !
Interview Preparation Tips
Experience: Data Structure question that we need to code on coderpad. i.e. Reverse String , 3rd largest integer in an array , Design Chess board , etc
General Tips: Brush your Java Basics and Data Structures , as Capgemini is Hiring for Goldman Sachs account which require good knowledge on Data Structures.
Deploying into a project is a great headache here.
Skills: Communication, Problem Solving, Analytical Skills
Duration: 1-4 weeks
Pranav Jain
I appeared for an interview in Oct 2016.
Interview Questionnaire
4 Questions
- Q1. Tell me about yourself
- Ans.
I am a recent graduate with a degree in Business Administration and a passion for problem-solving and teamwork.
Recent graduate with a degree in Business Administration
Passionate about problem-solving and teamwork
Strong communication and analytical skills
Experience in internships and extracurricular activities
- Q2. What are your expectations from the company?
- Ans.
I expect the company to provide a supportive and challenging work environment, opportunities for growth and learning, and a strong company culture.
Supportive and challenging work environment
Opportunities for growth and learning
Strong company culture
- Q3. Are you ready to relocate?
- Ans.
Yes, I am open to relocating for the right opportunity.
I am willing to relocate for the right job opportunity
I have experience moving for previous jobs
I am excited about the possibility of exploring a new location
- Q4. What are your future plans?
- Ans.
I plan to gain experience and expertise in the consulting field, eventually aiming for a leadership role.
Gain experience and expertise in the consulting field
Work towards a leadership role
Continuously learn and develop skills
Build a strong professional network
Stay updated with industry trends and advancements
Interview Preparation Tips
Experience: It was an amcat style test, adaptive in nature and measured the accuracy and speed.
Tips: Basic questions of aptitude and LR freely available on internet websites can be practiced to crack these easily.
Duration: 1 hour 30 minutes
Total Questions: 70
Round: Technical + HR Interview
Experience: It was a group interview, as 2 panelists interviewed 5 candidates at a time. It was more like giving a Viva voce at a practical exam.
Tips: Never tell them if you are planning for a master's degree, else you don't get a job for that time. Also don't stick to a job profile you think would suit you the best, be flexible. Moreover one should always be ready to relocate at the fresher level for such multi domain organizations.
College Name: Maharaja Surajmal Institute of Technology
TCS Interview FAQs
Tell us how to improve this page.
TCS Interviews By Designations
- TCS System Engineer Interview Questions
- TCS Software Developer Interview Questions
- TCS Software Engineer Interview Questions
- TCS Assistant System Engineer Interview Questions
- TCS Assistant System Engineer Trainee Interview Questions
- TCS IT Analyst Interview Questions
- TCS Ninja Interview Questions
- TCS Java Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Apps DBA Interview Questions
- MS SQL DBA Interview Questions
- Database Administrator DBA Interview Questions
- Oracle Database Administrator Interview Questions
- Lead DBA Interview Questions
- DBA Consultant Interview Questions
- DBA Administrator Interview Questions
- Oracle SCM Functional Consultant Interview Questions
- Show more
TCS Oracle Apps DBA Consultant Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
TCS Oracle Apps DBA Consultant Reviews and Ratings
based on 1 review
Rating in categories
|
System Engineer
1.1L
salaries
|  ₹1 L/yr - ₹9 L/yr |
|
IT Analyst
66.2k
salaries
| ₹5 L/yr - ₹15.9 L/yr |
|
AST Consultant
51.8k
salaries
| ₹8 L/yr - ₹25 L/yr |
|
Associate Consultant
30.1k
salaries
| ₹9 L/yr - ₹32 L/yr |
|
Assistant System Engineer
29.8k
salaries
| ₹2.2 L/yr - ₹5.8 L/yr |
Amazon
Wipro
Infosys
Accenture
- Home >
- Interviews >
- TCS Interview Questions >
- TCS Oracle Apps DBA Consultant Interview Questions
