Database concepts Interview questions -
Part 4
<< Previous Next>>
Part 1 |
Part 2 | Part 3 | Part 4
Aggregate Functions return a single value by
operating against a group of values. Scalar functions operate against a
single value................
Views can
be created referencing tables and views only in the current
database.
A view name must not be the same as any table owned by
that user.
You can build views on other views
and on procedures that reference views.............
In "correlated subqueries",
the result of outer query is passed to the subquery and the subquery
runs for each row...............
Data Warehousing is a process
of storing and accessing data
from central location for some strategic decision................
Joins are
used in queries to explain how different tables are
related.
Joins also let you select data from a table depending
upon data from another table................
Also read
Answer - Cursors can support various
functionalities that are listed here.....
Answer - Cursors behavior can be controlled by
dividing them into cursor types: forward-only, static,........
Answer - Temporary Stored Procedure is stored in
TempDB database. It is volatile and is deleted once connection gets
terminated or server is restarted......
Answer - This is the default
and recommended security mode. In this mode, access to SQL server is
controlled by Windows NT.....
Answer - Column with identity
property contains unique system generated value in the table. Column
with identity property is similar to AutoNumber field in MS
Access....
|
