ConfiDental Clinic Interview Questions and Answers

Round duration - 60 minutes
Round difficulty - Medium

This was a technical Interview round with questions on C#, .NET and DBMS.

Q1. What is the difference between the Ref and Out keywords in C#?
Ans. 
Ref is used for passing arguments by reference, Out is used for returning multiple values.
• Ref keyword is used for passing arguments by reference, allowing the method to modify the original value.

• Out keyword is used for returning multiple values from a method, as it does not require the variable to be initialized before being passed.
Answered by AI
Add your answer
Q2. What is the difference between ViewData, ViewBag, and TempData in C#?
Ans. 
ViewData, ViewBag, and TempData are ways to pass data between controllers and views in ASP.NET MVC.
• ViewData is a dictionary object used to pass data from controller to view. It requires typecasting.

• ViewBag is a dynamic property used to pass data from controller to view. No typecasting is required.

• TempData is a dictionary object used to pass data from one controller to another or from one action to another.
Answered by AI
Add your answer
Q3. What is the difference between managed and unmanaged code in C#?
Ans. 
Managed code is executed by the CLR with memory management, while unmanaged code is executed directly by the operating system without memory management.
• Managed code is executed by the Common Language Runtime (CLR) in .NET framework.

• Unmanaged code is executed directly by the operating system without CLR.

• Managed code provides automatic memory management through garbage collection.

• Unmanaged code requires manual memory man...read more
Answered by AI
Add your answer
Q4. What are the different types of triggers in SQL Server?
Ans. 
Triggers in SQL Server are special types of stored procedures that are automatically executed when certain events occur in a database.
• Types of triggers include DML triggers (for INSERT, UPDATE, DELETE operations), DDL triggers (for CREATE, ALTER, DROP operations), and Logon triggers.

• Triggers can be set to fire before or after the triggering event.

• Examples of triggers include auditing changes to a table using an INSERT ...read more
Answered by AI
Add your answer
Q5. What are generic and non-generic collections in C#?
Ans. 
Generic collections in C# allow for type-safe collections, while non-generic collections do not enforce type safety.
• Generic collections use type parameters to specify the type of elements they can contain, ensuring type safety.

• Non-generic collections do not specify the type of elements they can contain, leading to potential runtime errors if incorrect types are used.

• Example of generic collection: List<string> nam...read more
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

This was a typical managerial round.

Q1. Past work experience explanation, skill set and technical requirements
Add your answer

Skill test and technical knowledge evaluation

Q1. Tell me about yourself, preferred work location and expected salary.
Add your answer

They ask you open Hacker Earth site and choose some random programs and ask you to complete it.

Q1. What is multi threading
Ans. 
Multi threading is the ability of a program to perform multiple tasks concurrently.
• It allows for better utilization of CPU resources

• It can improve program performance and responsiveness

• Examples include web servers handling multiple requests simultaneously and video games rendering graphics while processing user input
Answered by AI
Add your answer
Q2. What is extend keyword
Ans. 
The extend keyword is used to add properties and methods to an existing object.
• Used in JavaScript to add properties and methods to an object

• Can be used to inherit properties and methods from a parent object

• Syntax: Object.assign(target, ...sources)

• Example: const obj1 = {a: 1}; const obj2 = {b: 2}; const obj3 = {...obj1, ...obj2};
Answered by AI
Add your answer
Q3. Explain override. Why we need virtual?
Ans. 
Override is used to provide a new implementation of a method in a subclass. Virtual is needed to allow the method to be overridden.
• Override is used to change the behavior of a method in a subclass

• Virtual is used to allow the method to be overridden in a subclass

• Without virtual, a subclass cannot override a method from its parent class

• Override is used to implement polymorphism in object-oriented programming
Answered by AI
Add your answer
Q4. Write a program to sort the array and remove duplicates.
Ans. 
Program to sort and remove duplicates from an array.
• Use built-in sort() method to sort the array in ascending order.

• Loop through the sorted array and remove duplicates using filter() method.

• Return the sorted and duplicate-free array.
Answered by AI
Add your answer
Q5. What is Is Relationship and As Relationship in oops?
Ans. 
Is Relationship and As Relationship are two types of relationships in object-oriented programming.
• Is Relationship is a type of relationship where one class is a subset of another class.

• As Relationship is a type of relationship where one class is a type of another class.

• Is Relationship is denoted by a solid line with a closed arrowhead pointing towards the superclass.

• As Relationship is denoted by a dotted line with an o...read more
Answered by AI
Add your answer
Q6. What are architectural, structural, behavioural design patterns? Why we need them?
Ans. 
Architectural, structural, and behavioral design patterns are reusable solutions to common software design problems.
• Architectural patterns define the overall structure of a software system

• Structural patterns describe how objects and classes can be combined to form larger structures

• Behavioral patterns focus on communication between objects and how they operate together

• Design patterns help to improve software quality, ma...read more
Answered by AI
Add your answer

Easy but time limit was the main issue to address

Hard coding test on hacker earth platform no cameras and plagiarism tester will be on

Q1. Technical questions based on my resume, coding, project architect, etc.
Add your answer

Q1. System design round. LLD and HLD.
Add your answer

Q1. Managerial with a little bit of technical. Work ethics, vision and ctc expectations.
Add your answer

Q1. Compensation discussion.
Add your answer