Add office photos
Employer?
Claim Account for FREE

Consilio

3.8
based on 138 Reviews
Filter interviews by

Indira Gandhi Govt. Dental College & Hospital Interview Questions and Answers

Updated 1 Feb 2025

Q1. What are the concepts of Object-Oriented Programming (OOP), specifically method overloading and method overriding?

Ans.

OOP concepts include method overloading and method overriding for reusability and flexibility in programming.

  • Method overloading allows multiple methods with the same name but different parameters in a class.

  • Method overriding involves creating a new implementation of a method in a subclass that is already defined in the superclass.

  • Method overloading is resolved at compile time, while method overriding is resolved at runtime.

  • Example of method overloading: adding(int a, int b) a...read more

Add your answer

Q2. What technology stack is utilized, and why was this specific stack selected?

Ans.

The technology stack utilized includes Java, Spring Boot, Angular, and MySQL. This stack was selected for its robustness, scalability, and ease of development.

  • Java is used for backend development due to its versatility and strong community support

  • Spring Boot is chosen for its ease of setup and integration with Java applications

  • Angular is utilized for frontend development to create dynamic and interactive user interfaces

  • MySQL is the database of choice for its reliability and p...read more

Add your answer

Q3. What is FSMO roles and explain?

Ans.

FSMO roles are flexible single master operations roles in Active Directory that control specific operations and functions.

  • FSMO roles are used in Active Directory to manage and control specific operations and functions.

  • There are five FSMO roles: Schema Master, Domain Naming Master, PDC Emulator, RID Master, and Infrastructure Master.

  • Schema Master role manages updates and modifications to the Active Directory schema.

  • Domain Naming Master role controls the addition or removal of ...read more

View 1 answer

Q4. Write commands for DML

Ans.

DML commands are used to manipulate data in a database. Examples include INSERT, UPDATE, DELETE.

  • INSERT: Adds new data into a table

  • UPDATE: Modifies existing data in a table

  • DELETE: Removes data from a table

Add your answer
Discover Indira Gandhi Govt. Dental College & Hospital interview dos and don'ts from real experiences

Q5. Write commands for Joins

Ans.

Joins are used to combine rows from two or more tables based on a related column between them.

  • INNER JOIN: Returns rows when there is at least one match in both tables

  • LEFT JOIN: Returns all rows from the left table and the matched rows from the right table

  • RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table

  • FULL JOIN: Returns rows when there is a match in one of the tables

Add your answer

Q6. Sql and types of queue

Ans.

SQL is a language used for managing relational databases. Queues are data structures that follow the FIFO principle.

  • SQL is used for querying, updating, and managing data in relational databases.

  • Types of queues include FIFO (First In First Out) and priority queues.

  • In SQL, queues can be implemented using tables with a timestamp or priority column.

  • Example: CREATE TABLE Queue (id INT, data VARCHAR(255), timestamp DATETIME);

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Indira Gandhi Govt. Dental College & Hospital

based on 11 interviews
Interview experience
3.9
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Interview Questions from Similar Companies

3.8
 • 1.6k Interview Questions
3.9
 • 174 Interview Questions
3.3
 • 145 Interview Questions
4.0
 • 138 Interview Questions
4.0
 • 132 Interview Questions
View all
Top Consilio Interview Questions And Answers
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter