Sunknowledge Services Database Admin Interview Questions and Answers

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions on DBMS, SQL Server etc.

Q1. What are the different types of joins in SQL?
Ans. 
Different types of joins in SQL include inner join, left join, right join, and full outer join.
• 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 outer join: Returns rows when there is a match in one of the tables.
Answered by AI
Add your answer
Q2. What are aggregate functions in DBMS?
Ans. 
Aggregate functions in DBMS are functions that operate on a set of values and return a single value as output.
• Aggregate functions perform calculations on multiple rows to return a single result.

• Examples include SUM, AVG, COUNT, MIN, and MAX.

• They are commonly used with the GROUP BY clause in SQL queries.
Answered by AI
Add your answer
Q3. What is the use of the WHERE clause in SQL?
Ans. 
The WHERE clause in SQL is used to filter records based on specified conditions.
• Used to specify a condition while fetching data from a table

• Filters records based on the specified condition

• Can be used with SELECT, UPDATE, DELETE statements

• Examples: SELECT * FROM table_name WHERE column_name = 'value';

• Examples: UPDATE table_name SET column_name = 'new_value' WHERE condition;
Answered by AI
Add your answer
Q4. What is the difference between classification and clustering in the context of database management systems?
Ans. 
Classification assigns predefined categories to data, while clustering groups similar data points together based on their characteristics.
• Classification involves labeling data into predefined classes or categories based on certain criteria.

• Clustering groups data points based on their similarities without predefined categories.

• Classification is supervised learning, while clustering is unsupervised learning.

• Example of cl...read more
Answered by AI
Add your answer
Q5. What is TempDB in MySQL?
Ans. 
TempDB in MySQL is a temporary database used for storing temporary data during query processing.
• TempDB is used for storing temporary tables, intermediate results, and other temporary data.

• It is automatically created by MySQL when needed and is dropped when the server is restarted.

• TempDB helps in optimizing query performance by reducing disk I/O and improving query execution time.
Answered by AI
Add your answer
Q6. What is SSIS?
Ans. 
SSIS stands for SQL Server Integration Services, a platform for building high-performance data integration and workflow solutions.
• SSIS is a component of Microsoft SQL Server used for data integration and workflow applications.

• It allows users to create packages that move data between various sources and destinations.

• SSIS includes tools for data extraction, transformation, and loading (ETL).

• It supports various data forma...read more
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

HR round with typical behavioral problems.