Interview Questions

Database concepts Interview questions - Part 3

<<Previous  Next>>

 Part 1 | Part 2 | Part 3 | Part 4

20.What is Union and Union All operator?

Union is used to combine distinct records from two tables. Union all combines all records from two tables.............. 

21.What is cursor?

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.............

22.Explain the cursor types.

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...............  

24.Explain in brief the cursor optimization tips.

Close cursor when it is not required.
You shouldn’t forget to deallocate cursor after closing it................  

25.What is sub-query?

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)...............

26.Explain the use of group by clause.

"Group By" is used to derive aggegate values by grouping similar data................

27.Difference between clustered and non-clustered index.

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...............  

Part 1 | Part 2 | Part 3 | Part 4
<<Previous  Next>>
Also read
Querying and modifying XML data in SQL Server 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.

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.
Benefits of Native XML Access in SQL Server 2005.
Limitation for Native XML Web Services.

Define Distributed Query and Linked Server?

Answer - Distributed Query is a query which can retrieve data from multiple data sources including distributed data........

Describe in brief Databases and SQL Server Databases Architecture.

Answer - A database is a structured collection of data. Database can be thought as simple data file......

What security features are available for stored procedures?

Answer - Database users can have permission to execute a stored procedure without being......

Write your comment - Share Knowledge and Experience


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring