SQL server cursors interview questions and answers

SQL server cursors interview questions and answers for freshers and experienced candidates. These interview questions and answers on SQL server cursors will help you strengthen your technical skills, prepare for the interviews and quickly revise the concepts. Many candidates appear for the interview for one role - many of the them give the right answers to the questions asked. The one who provides the best answer with a perfect presentation is the one who wins the interview race. The set of SQL server cursors interview questions here ensures that you offer a perfect answer to the interview questions posed to you.

SQL Server cursors interview questions

<<Previous  Next>>

What are Global and Local cursors?

SQL Server cursors - August 29, 2008 at 18:00 PM by Amit Satpute

What are Global and Local cursors?

Local cursors are available only in the batch, stored procedure, or trigger in which they were created. They are implicitly deallocated when the batch, stored procedure, or trigger terminates.

Global cursors are global to the connection.They are implicitly deallocated at disconnect.

<<Previous  Next>>

Also read

Define data, entity, domain and referential integrity.

Answer - Data Integrity validates the data before getting stored in the columns of the table. SQL Server supports four type of data integrity.....

Define Distributed Query and Linked Server?

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

Define temporary and extended stored procedure.

Answer - Temporary Stored Procedure is stored in TempDB database. It is volatile and is deleted once connection gets terminated or server is restarted......

Define Primary and Unique key.

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

What is index? Define its types.

Answer - Index can be thought as index of the book that is used for fast retrieval of information. Index uses one or more column index keys and pointers to the record to locate record......... 

Also read

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.

The answers to following questions will be made available soon. Keep visiting.

What are cursors?
Explain different types of cursors.
What are the disadvantages of cursors?
How can you avoid cursors?
What are the steps to create cursors?

Write your comment - Share Knowledge and Experience

Interview questions
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