PNB MetLife Senior Plsql Developer Interview Questions, Process, and Tips

Q1. Challenges in development
Ans. 
Challenges in development include managing project timelines, debugging complex issues, and staying updated with new technologies.
• Managing project timelines to ensure timely delivery of software

• Debugging complex issues that arise during development

• Staying updated with new technologies and tools to remain competitive in the industry
Answered by AI
Add your answer
Q2. Why Allianz, why leaving from current company
Add your answer

Aptitude test , of general,maths,
Coding basic coding question

Json data based assignment angular

Q1. Basic technical question based on js angular
Add your answer

20 min ease questions can surf on internet

Q1. Tell me about yourself
Add your answer

Q1. Coding ques mid level and project
Add your answer

Q1. Project discussion
Add your answer

Q1. Hr ques mixed with project
Add your answer

Q1. Mostly based on resume. Your experience, what you have done, what all you know. That's all.
Add your answer

Q1. How we join the tabels and types of join
Ans. 
Joining tables is done using JOIN keyword. Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
• JOIN keyword is used to combine rows from two or more tables based on a related column between them.

• INNER JOIN returns only the matching rows from both tables.

• LEFT JOIN returns all rows from the left table and the matching rows from the right table.

• RIGHT JOIN returns all rows from the right table and the m...read more
Answered by AI
View 1 more answer
Q2. What is primary key?
Ans. 
Primary key is a column or set of columns that uniquely identifies each row in a table.
• Primary key ensures data integrity by preventing duplicate rows.

• Primary key can be a single column or a combination of columns.

• Primary key is used as a reference in foreign keys of other tables.

• Primary key values cannot be null.

• Primary key values must be unique.
Answered by AI
Add your answer