SQL SERVER VERY BASIC INTERVIEW QUESTIONS FOR FRESHER
SQL SERVER INTERVIEW QUESTIONS WITH ANSWERS FOR FRESHER (for below 1 years experience) 1). What is SQL? Ans: SQL (Structured Query Lang...
1). What is SQL?
Ans: SQL (Structured Query Language) is used to perform operations on the records stored in database such as updating records, deleting records, creating and modifying tables, views etc.
2). What's a Database?
Ans: A collection of stored data objects.
3). What is RDBMS?
Ans: RDBMS stands for Relational Database Management Systems. RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.The data in RDBMS is stored in database objects called tables.
4). What's a Table?
Ans: Store data; core component of all databases.
5). What are Views?
Ans: Virtual tables; usually
6). What are Stored Procedures?
Ans: Commands that can be executed to make changes and return data.
7). What are Functions?
Ans: Commands that can be executed to only return data.
8). What are Constraints?
Ans: Ensure valid values.
9). Primary Keys ?
Ans: Unique values required for each row, designed to uniquely identify each row.
10). Foreign Keys ?
Ans: Used to create relationship between tables. Refers to the column pointing to the primary key.
11). What is the difference between a primary key and a unique key?
Ans: A primary key created a clustered index that does not allow NULLs. A unique key creates a non-clustered index which allows one NULL.
12). Why use Joins?
Ans: Data is divided across multiple tables, combine tables to make data "human readable".