ITC Infotech Plsql Developer Interview Questions, Process, and Tips

Q1. 1. Basic questions of PLSQL. 2. When to rebuild indexes and how to build them. 3. Performance tuning.
Add your answer

Q1. Latest project explanation with application architecture, tech stack used. Business logic implemented
Ans. 
Developed a web application for online shopping with microservices architecture using Node.js, Express, MongoDB, and React.
• Implemented microservices architecture to improve scalability and maintainability

• Used Node.js and Express for backend development

• Utilized MongoDB for database management

• Implemented React for frontend development

• Implemented business logic for user authentication, product management, and order proces
Answered by AI
Add your answer
Q2. Create an api based on your latest project with coding standards, SOLID principles (need to code in the laptop provided) interviewer assess the code.
Add your answer
Q3. What are the design patterns you have used and explain them within your project context
Ans. 
I have used the Singleton, Factory, and Observer design patterns in my projects.
• Singleton pattern: Used to ensure a class has only one instance and provides a global point of access to it. For example, I implemented a Logger class as a Singleton to manage logging throughout the application.

• Factory pattern: Used to create objects without specifying the exact class of object that will be created. For instance, I used a F...read more
Answered by AI
Add your answer
Q4. Write linq queries to get order id and list of products (based on latest project)
Ans. 
Use LINQ queries to retrieve order id and list of products based on latest project.
• Use OrderByDescending to get the latest project first

• Join Order and Product tables on OrderId

• Select OrderId and list of Products
Answered by AI
Add your answer
Q5. Write sql query to get 2 nd largest salary
Ans. 
Use SQL query with ORDER BY and LIMIT to get 2nd largest salary.
• Use SELECT statement to retrieve salary column

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 1,1 to get the second row
Answered by AI
Add your answer
Q6. Web apps/ api security, performance, unit testing, code review and authentication/authorization related discussions
Add your answer
Q7. Generic class, generic methods related questions and write code in the board
Add your answer

Q1. Experience, relevant experience, current company related details
Add your answer
Q2. Salary discussions/negotiations
Add your answer

Q1. Write MySQL query to find employee with 2nd Highest salary
Ans. 
Use MySQL query with ORDER BY and LIMIT to find employee with 2nd highest salary.
• Use ORDER BY salary DESC to sort salaries in descending order

• Use LIMIT 1,1 to skip the highest salary and get the second highest salary
Answered by AI
Add your answer
Q2. What is branch in git
Ans. 
A branch in git is a separate line of development that allows you to work on features or fixes without affecting the main codebase.
• Branches allow for parallel development

• They can be created, switched between, merged, and deleted

• Common branches include master, develop, feature branches, and release branches
Answered by AI
Add your answer

Q1. Write the code in eggplant
Ans. 
Writing code in eggplant for Senior Developer interview
• Use 'click' to simulate a mouse click on an element

• Use 'typeText' to enter text into a field

• Use 'verify' to check if an element is present on the screen
Answered by AI
Add your answer

Q1. CSS Box-model definition
Ans. 
CSS Box-model defines how elements are rendered in a webpage, including padding, border, and margin.
• Box-model consists of content, padding, border, and margin

• Content area is where text or images are displayed

• Padding is the space between content and border

• Border is the line around the content and padding

• Margin is the space outside the border
Answered by AI
Add your answer
Q2. Difference b/n flexbox and grid
Ans. 
Flexbox is for one-dimensional layouts, grid is for two-dimensional layouts.
• Flexbox is best for arranging items in a single row or column.

• Grid is best for creating complex layouts with rows and columns.

• Flexbox is more suitable for smaller scale layouts, while grid is better for larger scale layouts.

• Flexbox is more flexible in terms of item order and sizing, while grid provides more control over the overall layout.

• Both
Answered by AI
Add your answer

Q1. Based on Angular
Add your answer
Q2. Based on Html, CSS, Javascript
Add your answer

Q1. Simple question from your resume
Add your answer

Coding related questions

Q1. Tell me about yourself
Add your answer
Q2. What is your strength and weakness
Add your answer
Q3. Why are you want to join this question and what is your salary expectation
Add your answer

All the basic topics

Normal JS, And CSS and HTML