Triyam Information Technology Interview Questions and Answers

Where clause is used to filter rows before grouping, while Having clause is used to filter groups after grouping.

• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition.

• Having clause is used with GROUP BY clause to filter groups based on a condition.

• Where clause is applied before grouping, Having clause is applied after grouping.

• Example: SELECT * FROM table_name WHERE condition; ...read more

Encapsulation is the concept of bundling data and methods that operate on the data into a single unit, known as a class.

• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for data hiding, which prevents outside code from directly accessing an object's internal data.

• Encapsulation also helps in achieving data abstraction, where the internal details of an object are hidden...read more

Java is a high-level, object-oriented programming language, while C is a low-level, procedural programming language.

• Java is platform-independent, while C is platform-dependent.

• Java uses automatic memory management (garbage collection), while C requires manual memory management.

• Java is more secure due to its strong type system and runtime environment, while C allows for more direct memory manipulation.

• Java is typically ...read more