SQL Server interview questions - Part 5
SQL server is an RDBMS that uses Transact-SQL
to interact with the client application. It includes
database,.............
Read answer
Denormalization is the reverse process of
normalization. It is controlled introduction of redundancy to the
database design..................
Read
answer
One to one is implemented using single table by
establishing relationship..............
Read
answer
Implemented using two tables with primary
key.................
Read
answer
Implemented using a junction
table................
Read
answer
It extends base type datatypes functionality. It
is create when particular datatype format has to be used across many
tables in the
database...............
Read
answer
Both enforce uniqueness of the column. By default
primary key creates a clustered index..............
Read
answer
Bit datatype is used to store boolean information
like 1 or 0 (true or false)................
Read
answer
Candidate key: A column or a set of columns can
be called as candidate key if they i dentify each row of a table
uniquely.............
Read
answer
A key formed by combining at least two or more
columns..............
Read
answer
Default constraint is used to fill column with
default value defined during creation of table if
nothing................
Read
answer
Transaction encapsulates SQL commands and work as
a single unit..............
Read
answer
Isolation levels determine the degree of
isolation of data during concurrent access..............
Read
answer
Lock escalation is the process of converting low
level locks (row locks, page locks) into higher level locks (table
locks)............
Read
answer
SQL Profiler is used to diagnose a problem by
capturing events in a trace file...............
Read
answer
SQL Server Service Manager is used to start,
stop, and pause SQL Server services that exist as the separate
components on the server.............
Read
answer
SQL Query Analyzer is a tool that are used for
various purposes such as creating and executing
querie.................
Read
answer
DTS, Data Transformation Services is used to
import and export data between heterogeneous data
source...............
Read
answer
Replication allows creating copies of data in
separate databases along with keeping all databases synchronized by
replicating modification..............
Read
answer
Bulk copying is used to transfer large amount of
data. Distributed Queries in SQL server are used to reference
heterogeneous..............
Read
answer
SQL server agent is important service of the
server where instances of SQL server are
running..............
Read
answer
|
