Answer - A database is a structured collection of data.
Database can be thought as simple data file......
Answer - It is the process of organizing data into related
table. To normalize database, we divide database into tables.....
Answer - SQL Server Provides three types of Transact-SQL
statements namely DDL, DCL, and DML....
Answer - SQL Server database stores information in a two
dimensional objects of rows and columns called table......
Answer - Data Integrity validates the data before getting
stored in the columns of the table. SQL Server supports four type of data
integrity.....
Answer - The Bulk Copy is a command utility that transfer SQL
data to or from a data file.
This utility mostly used to transfer huge data to SQL server from other
database....
Answer - Distributed Query is a query which can retrieve data
from multiple data sources including distributed data........
Answer - Temporary Stored Procedure is stored in TempDB
database. It is volatile and is deleted once connection gets terminated or
server is restarted......
Answer - The column or columns of the table whose value
uniquely identifies each row in the table is called primary key. You can define
column as primary key using primary key constraint while you create table.....
Answer - Index can be thought as index of the book that is used
for fast retrieval of information. Index uses one or more column index keys and
pointers to the record to locate record.........