explain different types of cursors? : Sql server database administration


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  


What is rank function?

0 Answers  


Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,


How can you stop stored procedures from recompiling?

0 Answers  


how many clustered indexes can be created on a table? : Sql server database administration

0 Answers  


1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,


How to delete an attribute from the emp table

4 Answers  


One table how may column and Primary key

3 Answers  


Is it possible to replicate data from sql server to oracle? : sql server replication

0 Answers  


how many type of indexing in database?

0 Answers   IBM,


HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

18 Answers   Infosys, TCS,


What is role playing dimension with two examples? : sql server analysis services, ssas

0 Answers  


Categories