SQL Server notification services interview
questions
Notification Services are
services which send notifications to the interested entities based
on what they would like be notified on...................
Read
answer
The following terms are
the components of Notification Service: Event: an action that
occurred affecting the specified
data...................
Read
answer
Notification Services
consists four components. Subscription
Subscription data can be added using (SMO)
Subscription Management Objects to Notification Services
application...................
Read
answer
Subscription data can be
added using (SMO) Subscription Management Objects to Notification
Services application................
Read
answer
Also read
What can SQL Server Reporting Services do?
Explain the
architecture of reporting services.
Describe Reporting
Lifecycle.
What are the ways to tune Reporting Services?
How
to schedule SSAS Database backup.
How to Generate an Auto
Incremental Number in a SSIS Package?
Lookup's are a key
component in SQL Server Integration Services (SSIS). Explain its
purpose
How to unzip a File in SSIS?...........
Answer - Views can be created referencing tables
and views only in the current
database...........
Answer - A transaction is a set
of operations that works as a single unit. The ransactions can be
categorized into explicit, autocommit, and implicit............
Answer - Data Integrity validates the data
before getting stored in the columns of the table. SQL Server
supports four type of data integrity........
Answer - Distributed Query is a query which can
retrieve data from multiple data sources including distributed
data............
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..........
|
