Capgemini Senior Plsql Developer Interview Questions and Answers

Provide various round for aptitude test

Provided various round of coding test questions

It was a basic filtering round based on aptitude.

I had two medium-level LeetCode questions.

Q1. During the interview, I was asked both HR and technical questions. Initially, I responded to technical inquiries regarding HTML, MongoDB, SQL, and JavaScript, as they were listed on my resume. After addres...read more
Add your answer
Q2. What are different types of tag in html and tags which do not require closing tag
Add your answer
Q3. Sql query for highest salary from list of employees table
Add your answer

An aptitude test is an assessment to measure a candidate mental aptitude/mental ability

Q1. Can you briefly Tell us about yourself?
Add your answer
Q2. What do you consider to be your strongest points?
Add your answer
Q3. Which programming languages do you use regularly in your work
Add your answer

A group discussion is a structured conversation in which participants share their ideas, perspectives, and solutions on a specific topic.

Q1. What motivates you to seek employment at Wipro?
Add your answer
Q2. What are your long-term career goals?
Add your answer

Assignment details refer to the specifics of an assignment, including any documents and/or emails or subsequent correspondence between the company and the client.

Q1. Java 8 , java 11 and java 17 features?
Ans. 
Java 8 introduced lambda expressions, Java 11 added local-variable syntax for lambda parameters, and Java 17 included sealed classes and pattern matching.
• Java 8 introduced lambda expressions for functional programming.

• Java 11 added local-variable syntax for lambda parameters to simplify code.

• Java 17 included sealed classes to restrict inheritance and pattern matching for instanceof checks and type casts.
Answered by AI
Add your answer
Q2. Dispatcher servlet, design patterns
Add your answer
Q3. @SpringbootApplication annotation, actuators
Add your answer
Q4. String Coding question with java 8 features such as lambda function and stream api
Add your answer
Q5. Number of words in a string
Ans. 
Count the number of words in a given string.
• Split the string by spaces and count the number of resulting elements.

• Handle edge cases like multiple spaces or empty strings.

• Consider punctuation marks as part of words unless specified otherwise.
Answered by AI
Add your answer
Q6. Microservice design patterns
Add your answer

Q1. What are the types and number of constraints in your specific context?
Ans. 
There are various types of constraints in DOT NET development, including primary key, foreign key, unique, check, and default constraints.
• Primary key constraints ensure each record in a table is unique.

• Foreign key constraints enforce referential integrity between tables.

• Unique constraints ensure that all values in a column are distinct.

• Check constraints validate the data before it is inserted or updated.

• Default constra...read more
Answered by AI
Add your answer
Q2. What is the difference between an independent class and an abstract class?
Ans. 
Independent class can be instantiated while abstract class cannot be instantiated directly.
• Independent class can be directly instantiated using the 'new' keyword.

• Abstract class cannot be instantiated directly, it can only be used as a base class for other classes.

• Independent class does not require any derived class to implement its members.

• Abstract class can have abstract methods that must be implemented by derived cla
Answered by AI
Add your answer

Q1. Technical coding with the technical team
Add your answer

Q1. What are your reasons for changing your job?
Ans. 
Seeking new challenges, growth opportunities, and a better work-life balance.
• Looking for new challenges and opportunities to learn and grow.

• Seeking a better work-life balance.

• Interested in working with new technologies or in a different industry.

• Wanting to advance my career and take on more responsibilities.

• Company restructuring or changes in management.
Answered by AI
Add your answer

Onlin test consist pf easy numerical questions

Easy questions not so difficult

Q1. Java oops concept
Add your answer
Q2. Basic sprophramming questions
Add your answer
Q3. Networking firewall cisco
Add your answer

Q1. Personal questions
Add your answer
Q2. Whetehr to willing to work in any locations
Ans. 
Yes, I am willing to work in any location for the right opportunity.
• I am open to relocating for the right job opportunity

• I am flexible and adaptable to new environments

• I believe working in different locations can provide valuable experiences and growth opportunities
Answered by AI
Add your answer

3 coding problems
1 aptitude
1 puzzle
3 hrs duration

Q1. Sorting algorithms
Add your answer
Q2. 1 puzzle - burning candles
Add your answer

Q1. General discussion on resume
Add your answer
Q2. Few reasoning questions
Add your answer

Q1. About company work culture
Add your answer