Database concepts Interview questions -
Part 3
<< Previous Next>>
Part 1 |
Part 2 | Part 3 | Part 4
Union is used to combine distinct records
from two tables. Union all combines all records from
two tables..............
A Cursor
is a database object that represents a result set and is used to
manipulate data row by row. When a cursor is opened, it is
positioned on a row and
that row is available for processing.............
DYNAMIC:
It reflects changes happened on the table while scrolling through
the row.
STATIC: It works on snapshot of record set and
disconnects from the server...............
Close
cursor when it is not required.
You shouldn’t
forget to deallocate cursor after closing it................
Sub-query is a query within a Query. Example of sub-query:
Select CustId, Custname
From Customer Where Cust_Id IN (Select Doct_Id from Doctor)...............
"Group By" is used to derive aggegate
values by grouping similar data................
Both stored as
B-tree structure. The leaf level of a clustered index is the actual data where
as leaf level of a non-clustered index is pointer to
data...............
Also read
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.
Explain the concepts and capabilities of SOAP. Explain the
purpose of Native XML mode in SQL Server 2005.
Native XML Access
vs. SQLXML.
Benefits of Native XML Access in SQL Server
2005.
Limitation for Native XML Web Services.
Answer - Distributed Query is a query which can
retrieve data from multiple data sources including distributed
data........
Answer - A database is a structured collection
of data. Database can be thought as simple data file......
Answer - Database users can have permission to
execute a stored procedure without being......
|
