Triunity Group Database Developer Interview Questions, Process, and Tips

Java pattern and some basic sql

Q1. Rapid fire mcq about oops and sql
Add your answer
Q2. What is abstract
Ans. 
Abstract is a concept or idea that is not concrete or tangible.
• Abstract refers to something that is theoretical or conceptual rather than physical.

• It is often used in programming to define classes or methods that cannot be instantiated.

• Abstract art does not attempt to represent an accurate depiction of visual reality.
Answered by AI
Add your answer
Q3. What is inheritance
Ans. 
Inheritance is a concept in object-oriented programming where a class can inherit attributes and methods from another class.
• Allows for code reusability and promotes a hierarchical structure

• Derived classes can access and modify the properties and behaviors of the base class

• Types of inheritance include single, multiple, multilevel, and hierarchical inheritance
Answered by AI
Add your answer
Q4. Constraints in sql
Ans. 
Constraints in SQL are rules that are enforced on data in a table to maintain data integrity.
• Constraints ensure data accuracy and consistency in a database.

• Common constraints include NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK constraints.

• Example: CREATE TABLE Students (ID INT PRIMARY KEY, Name VARCHAR(50) NOT NULL, Age INT CHECK (Age >= 18));
Answered by AI
Add your answer
Q5. What are different joins?
Ans. 
Different types of 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 (or Left Outer Join): Returns all rows from the left table and the matched rows from the right table.

• Right Join (or Right Outer Join): Returns all rows from the right table and the matched rows from the left table.

• Full Join (o...read more
Answered by AI
Add your answer