|
SQL Server interview questions - Part 1
Latest answer: Buffer Cache: Buffer cache is
a memory pool in which data pages are read. It performance of the buffer cache
is indicated as follows:.............
Read
answer
Latest answer: Temporary setting of specific
server characteristics is done by trace tags. DBCC TRACEON is the command to
set the trace flags. Once activated, trace flag will be in effect until the
server is restarted...............
Read answer
Latest answer: MS SQL Server supports the
connection to different OLE DB on an ad hoc basis. This persistent connection
is referred as Linked Server..............
Read answer
Latest answer: SQL Server has a feature for
sending mail. Stored procedures can also be used for sending mail on demand.
With SQL Server 2005, MAPI client is not needed for sending
mails................
Read
answer
Latest answer: The following is the process
to make a remote connection in database: - Use SQL Server Surface Area
Configuration Tool for enabling the remote connection in
database...................
Read
answer
Latest answer: Cross Join : No join
conditions are specified. Results in pairs of rows. Results in Cartesian
product of two tables...............
Read
answer
Latest answer: OPENXML
parses the XML data in SQL Server in an efficient manner. It’s primary ability
is to insert XML data to the RDB. It is also possible to query the data by
using OpenXML................
Read
answer
Latest answer: The following is the order of
executing SQL query: The query goes to the shared pool that has information
like parse tree and execution plan for the corresponding
statement...............
Read
answer
Latest answer: Create a column as type
‘blob’ in a table. Read the content of the file and save in ‘blob’ type column
in a table...............
Read answer
Latest answer: Microsoft SQL server is a relational database
management system. It uses MS- SQL as the query language. SQL Server offers a
high level of security, reliability and scalability depending on the business
needs..............
Read answer
Explain inline variable assignment in sql server 2008 with an example.
What is Compound Operators in sql server 2008? Explain with an example
SQL Server 2008 introduces automatic auditing. Explain its
benefits.............
Read answer
Latest answer: WITH ENCRYPTION Indicates that SQL Server will
convert the original text of the CREATE PROCEDURE statement to an encrypted
format. Users that have no access to system................
Read answer
Latest answer: A linked server allows remote access. Using
this, we can issue distributed queries, update, commands, and transactions
across different data sources................
Read answer
Latest answer: Analysis service provides a combined view of the
data used in OLAP or Data mining. Services here refer to OLAP, Data mining.
Analysis services assists in creating, designing...........
Read answer
Latest answer: Each server running analysis service has a
repository to store objects of the computer running Analysis Services an
Analysis service repository stores the information about the.............
Read answer
Latest answer: SQL
service broker provides asynchronous queuing functionality to SQL server. Once
message is sent to the SQL server................
Read
answer
Latest answer: User defined datatypes is created by using base
SQL Server data type by providing a descriptive name.................
Read
answer
Latest answer: Bit datatype is used to store boolean
information................
Read answer
Latest answer: Lock escalation from SQL Server 7.0 onwards, is
dynamically managed by SQL Server. It is..........
Read answer
Latest answer: Blocking happens when one connection from an
application holds a lock and a second............
Read answer
Latest answer: Every database has a public role which holds all
the default permissions for the users in a database.................
Read answer
Latest answer: SQL server login is used to connect to SQL
server. This used when login in through the windows login credentials is not
existent.............
Read answer
Latest answer: The built in Administrator Account is basically
used during some setup to join some machine in the domain............
Read answer
Latest answer: Failover clustering is mainly used for data
availability. Typically in a failover cluster, there are two machines. One
machine provides the basic services and the second is available to
run..................
Read answer
Latest answer: SQL server can return XML document using FOR XML
clause.................
Read answer
Latest answer: SQL Server has efficient ways to enhance
scalability of the database system...............
Read answer
Latest answer: SQL Server English Query helps to build
applications that can accept query.............
Read answer
Latest answer: SQL Profiler captures SQL Server events from a
server. The events are saved.................
Read answer
Latest answer: SQL Server uses different ways to execute SQL
statements which are listed below................
Read answer
Latest answer: SQL Server supports searches on character string
columns using Full-Text Query...............
Read answer
Latest answer: The several phases a transaction has to go
through are listed here. Database..............
Read answer
Latest answer: XPath is a language defined by the W3C, used to
select nodes from XML documents..............
Read answer
Latest answer: A file or file group can only be used by one
database. For example, the files abc.mdf and abc.ndf contains.................
Read answer
Latest answer: SQL Server supports two security
(authentication) modes................
Read answer
Latest answer: Data definition language is used to define and
manage all attributes and properties of a database..............
Read answer
Latest answer: SQL Server uses the following steps to process a
single SELECT statement............
Read answer
Latest answer: CREATE DEFAULT, CREATE PROCEDURE, CREATE RULE,
CREATE TRIGGER, and CREATE VIEW statements..............
Read
answer
Latest answer: GO Command is used to signal the end of a
batch...............
Read answer
Latest answer: Null means no entry has been made. It implies
that the value is either unknown or undefined............
Read answer
Latest answer: UNION command selects distinct and related
information from two tables. On the other hand..............
Read answer
Latest answer: Database Consistency Checker Commands give
details in form of statistics about the SQL Server..............
Read answer
Latest answer: UNION command selects distinct and related
information from two tables. On the other hand.............
Read answer
Latest answer: A local temporary table lives until the
connection is valid or until the duration of a compound statement.........
Read
answer
Latest answer: STUFF function is used to insert a string into
another string by deleting some characters specified.............
Read
answer
Also read
|
SQL Profiler
What are the tasks performed by SQL Profiler? How can you use the SQL Profiler
to ensure database security? How can you reduce the amount of data collected by
a trace? What is SQL Profiler? When do you use SQL Profiler?............
|
Sql Server DBA interview
What are the steps to take to improve performance of a poor performing query?
What is a deadlock and what is a live lock? How will you go about resolving
deadlocks? What is blocking and how would you troubleshoot it?.............
|
|
Sql Server database maintenance
Explain the concepts of faster differential backups. Explain the concepts of
Parallel Database consistency check (DBCC). Define Indexed view.
Define Distributed partitioned views............
|
SQL Server backup devices and methods
Database backup methods - Full Backups, Differential Backups, Transaction Log
Architecture Backups, File and Filegroup Backups...............
|
|
RAID (Redundant Array of Inexpensive disks)
RAID is a mechanism of storing the same data in different locations. Since the
same data is stored, it is termed as redundant............
|
SQL Server 2005 XML support
Explain the concepts and capabilities of SOAP. Explain the purpose of
Native XML mode in SQL Server 2005. Native XML Access vs. SQLXML.............
|
|
XML Data type implementation in SQL
2005
What is Untyped XML? Provide examples for : Create a table with a untype XML
column, Insert into an untyped XML data type column. What is typed XML? The XML
data type comes with five methods. Explain them Differentiate between Untyped
XML and Typed XML...................
|
Querying &
modifying XML data in SQL 2005
What is XQuery language? Explain the syntax rule of XQuery language.
XQuery expression contains two parts: the Prolog and the Body. Explain them
Explain PATH expression in XQuery with an example.....................
|
|
Indexing XML data in SQL Server
2005
Explain the concepts of indexing XML data in SQL Server 2005. Provide basic
syntax for creating index on XML data type column. What is content
indexing/full text indexing? Explain the reason to index XML data type column.
What are the guidelines to be adhered when creating a XML
index?...................
|
Indexing XML data in SQL Server
2005
Explain the concepts of indexing XML data in SQL Server 2005. Provide basic
syntax for creating index on XML data type column. What is content
indexing/full text indexing? Explain the reason to index XML data type column.
What are the guidelines to be adhered when creating a XML index?...............
|
|
XML Schemas in SQL Server 2005
Syntax and example for creating and dropping XML schema collection. Limitations
of the XML Schema collections. Discuss about XML schema collection
permission...................
|
FOR XML in SQL Server
Discuss the TYPE directive of FOR XML. Explain the RAW mode of FOR XML. Explain
the AUTO mode of FOR XML. Explain the EXPLICIT mode of FOR XML..............
|
|
CLR support for SQL Server 2005
Overview of integration of CLR with SQL Server.
Advantages of CLR integration...............
|
XSLT in SQL Server 2005
Overview of XSLT and the components that make up an XSLT style sheet. What is
XSLCompiledTransform class of the .NET Framework? What is XSLTSetting class of
the .NET Framework?...................
|
|
SOAP support in SQL Server 2005
Syntax and example for creating and dropping XML schema collection. Limitations
of the XML Schema collections. Discuss about XML schema collection
permission..............
|
Transferring a
View from Oracle 10G XE to an SQL Server 2005 Database
Here you will learn how to copy a table on an Oracle 10G XE database to a
database on the SQL Server 2005. You will also learn how to install an Oracle
10G XE server and work with its database objects...........
|
|
SQL
Server 2005 Analysis Services
What is SQL Server 2005 Analysis Services (SSAS)? What are the new features
with SQL Server 2005 Analysis Services (SSAS)? What are SQL Server Analysis
Services cubes? Explain the purpose of synchronization feature provided
in Analysis Services 2005. Explain the new features of SQL Server 2005 Analysis
Services (SSAS). [Hint - Unified Dimensional Model, Data Source View, new
aggregation functions and querying tools]....................
|
|
|
