Wipro Plsql Developer Interview Questions and Answers

Q1. Plsql and Oracle SQL
Add your answer

Q1. Discussion for salary
Add your answer

Q1. Factorial of a number
Ans. 
Factorial of a number is the product of all positive integers up to that number.
• To calculate factorial of a number, multiply all positive integers up to that number.

• Factorial of 0 is 1.

• Example: Factorial of 5 is 5*4*3*2*1 = 120.
Answered by AI
Add your answer
Q2. Sql queries including 2nd highest salary and table joins
Add your answer

Q1. Sql question and table joins
Add your answer
Q2. Modelling of schema
Ans. 
Modelling of schema involves designing the structure of a database to organize and represent data.
• Identify entities and their relationships

• Define attributes for each entity

• Establish primary and foreign keys

• Normalize the schema to reduce redundancy

• Consider performance and scalability
Answered by AI
Add your answer

Oracle pl sql developer

Q1. SQL queries, joins, views, functions , advanced functions, exceptions.. Lot of Scenario based question
Add your answer
Q2. About resume and past experiences
Add your answer
Q3. Interview happened almost 1hr
Add your answer

Q1. After 30 days.. Do u have any other offer in hand? How much they offered
Add your answer

Q1. Basics of pl sql like cursor, triggers, sequences
Add your answer
Q2. Performance tuning, basic queries on situations
Add your answer

Q1. Just a discussion with HR
Add your answer

Q1. Basic SQL related question
Add your answer
Q2. Good knowledge on pl SQL is preferred, few in-depth questions . Keep your cool and answer every question with best of your knowledge
Add your answer