|
SQL Server interview questions
- Part 4
By Nishant Kumar
Latest answer: A database is a structured
collection of data. Database can be thought as simple data
file.............
Read answer
Latest answer: It is the process of organizing
data into related table. To normalize database, we divide database
into tables............
Read
answer
Latest answer: SQL Server Provides three types
of Transact-SQL statements namely DDL, DCL, and DML...........
Read answer
Latest answer: SQL Server database stores
information in a two dimensional objects of rows and columns called
table.............
Read answer
Latest answer: Data Integrity validates the data
before getting stored in the columns of the table. SQL Server
supports four type of data integrity............
Read answer
Latest 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...........
Read answer
Latest answer: Distributed Query is a query
which can retrieve data from multiple data sources including
distributed data...............
Read answer
Latest answer: Temporary Stored Procedure is
stored in TempDB database. It is volatile and is deleted once
connection gets terminated or server is restarted.............
Read answer
Latest 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............
Read answer
Latest 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................
Read
answer
|
