Wipro Architect Interview Questions, Process, and Tips for Experienced

Q1. Explain normalization in database?
Ans. 
Normalization in database is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down a database into smaller, more manageable tables.

• It helps in reducing data redundancy by storing data in a structured manner.

• Normalization ensures data integrity by minimizing data anomalies.

• There are different normal forms such as 1NF, 2NF, 3NF, BCNF, and 4NF.

• For...read more
Answered by AI
Add your answer
Q2. What is a trigger
Ans. 
A trigger is a special kind of stored procedure that is automatically executed when certain events occur in a database.
• Triggers are used to maintain referential integrity, enforce business rules, and automate actions in response to data changes.

• They can be defined to execute before or after an INSERT, UPDATE, or DELETE operation on a table.

• For example, a trigger can be set up to automatically update a timestamp column
Answered by AI
Add your answer
Q3. What is a view
Ans. 
A view is a sight or prospect, typically of attractive natural scenery.
• A view refers to what can be seen from a particular location or vantage point

• Views can include landscapes, cityscapes, seascapes, or any other visually appealing scenes

• Architects often design buildings to take advantage of specific views, such as positioning windows to frame a picturesque landscape

• Views can greatly enhance the overall experience and
Answered by AI
Add your answer

Q1. Technical Round + Coding Test 1.30 hours
Add your answer
Q2. For Coding they have given one system to design with all the parts.
Add your answer

Q1. More on System Designing, Microservices, design Pattern Implementation. and Project Related.
Add your answer

Q1. About the Career detailed questions.
Add your answer

Short of general discussion.

Q1. L1 Tech Assessment
Add your answer

Q1. L2 Tech Assessment
Add your answer

Q1. HR Formal Discussion
Add your answer

Q1. Salary Negotiation
Add your answer

Q1. What are PL/SQL collections?
Ans. 
PL/SQL collections are data structures used to store multiple elements of the same data type in Oracle databases.
• PL/SQL collections include associative arrays, nested tables, and VARRAYs.

• They can be used to store data temporarily during processing.

• Examples include storing employee names in an array or tracking customer orders in a nested table.
Answered by AI
Add your answer
Q2. What are SQL analytical functions?
Ans. 
SQL analytical functions are used to perform calculations across a set of rows in a table.
• They allow for advanced analysis and reporting in SQL queries.

• Examples include functions like RANK(), ROW_NUMBER(), and LEAD().
Answered by AI
Add your answer

Q1. What is your notice period?
Ans. 
My notice period is currently one month.
• Notice period is one month

• Standard notice period in the industry

• Can be negotiable based on the situation
Answered by AI
Add your answer
Q2. What is your preferred work location?
Ans. 
I prefer working in a collaborative office environment with natural light and greenery.
• Collaborative office environment

• Natural light

• Greenery
Answered by AI
Add your answer