MS SQL Server interview question and answer
1).What is SQL Server? SQL Server is a relational database management system (RDBMS) developed by Microsoft. It provides an environment to manage data and applications using SQL (Structured Query Language) commands. 2). What is a Primary Key? A Primary Key is a unique identifier for a record in a database table. It is used to ensure that each record can be uniquely identified, and it prevents duplicates or inconsistencies in the data. A Primary Key is created using a unique index or constraint on one or more columns in the table. 3). What is a Foreign Key? A Foreign Key is a field in a table that links to the Primary Key of another table. It is used to establish a relationship between two tables and ensure data consistency between them. 4). What is normalization? Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It involves breaking down larger tables into smaller, more specialized tables, and establishing re...