IDC Technologies Structural Engineer Trainee Interview Questions and Answers

Q1. Recovery models of sql server
Ans. 
SQL Server has three recovery models: Simple, Full, and Bulk-Logged.
• Simple recovery model: minimally logged, no log backups, only full backups

• Full recovery model: fully logged, allows for point-in-time recovery, requires log backups

• Bulk-Logged recovery model: minimally logged for bulk operations, requires log backups for point-in-time recovery
Answered by AI
Add your answer
Q2. DMVs in sql server
Ans. 
DMVs in SQL Server are dynamic management views that provide information about the current state of the SQL Server instance.
• DMVs can be used to monitor performance, troubleshoot issues, and gather information about the server.

• Examples of DMVs include sys.dm_exec_requests, sys.dm_os_wait_stats, and sys.dm_db_index_physical_stats.
Answered by AI
Add your answer

Q1. How do you tackle difficult scenarios in project
Ans. 
I tackle difficult scenarios in projects by breaking them down, seeking input from team members, and staying organized.
• Break down the problem into smaller, manageable tasks

• Seek input and feedback from team members to gain different perspectives

• Stay organized by creating a timeline and setting priorities

• Communicate openly with stakeholders to address any challenges or roadblocks

• Stay calm and focused under pressure to ma
Answered by AI
Add your answer

Q1. CTC discussion went on
Add your answer

Q1. How to communicate between microservices
Ans. 
Communication between microservices is typically done through APIs, messaging queues, or service meshes.
• Use RESTful APIs for synchronous communication between microservices

• Implement messaging queues like RabbitMQ or Kafka for asynchronous communication

• Utilize service meshes like Istio for managing communication between microservices
Answered by AI
Add your answer
Q2. 2. Java 8 grouping by coding
Ans. 
Grouping in Java 8 allows elements to be grouped based on a common attribute or condition.
• Use the Collectors.groupingBy() method to group elements in a stream based on a specified classifier function.

• The classifier function determines how elements are grouped.

• Grouping can be done on any type of object, such as strings, integers, or custom objects.

• For example, to group a list of Person objects by their age: Map<Integ...read more
Answered by AI
Add your answer
Q3. Asynchronous communication
Add your answer
Q4. Spring security basics
Add your answer

Q1. Resume based questions
Add your answer

Q1. Infrastructure based questions
Add your answer

Q1. Salary discussion
Add your answer

Q1. Manager discussion
Add your answer

Ai interview backend microservices core java

Q1. Microservice architecture spring boot
Add your answer
Q2. Rest api implementation and communication
Add your answer