DB Developer Interview Questions and Answers

Updated 1 Feb 2024

Q1. 1.what is sql server 2.what is procedure 3.what is CTE table 4. Difference between cte and table variable in sql 5. Difference between function and procedure. 6.type of indexes 7.what is unique index.

Ans.

SQL Server is a relational database management system developed by Microsoft.

SQL Server is a software product used to manage and store data in a relational database.
It provides a platform for creating, managing, and querying databases.
SQL Server supports SQL (Structured Query Language) for interacting with the database.
It offers various features like data storage, data retrieval, data manipulation, and data security.
SQL Server can be used for developing and deploying database...read more

Q2. 1 what is view 2 difference between union and union all. 3.what is indexes 4.difference between primary and unique key. 5.what is composit key.

Ans.

A view is a virtual table that is based on the result of a query. It is used to simplify complex queries and provide a logical representation of data.

Views are created by selecting columns from one or more tables and can be used like a table in queries.
They do not store any data themselves but provide a way to access and manipulate data from underlying tables.
Views can be used to restrict access to certain columns or rows of a table.
They can also be used to combine data from ...read more