ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
1.what is the difference between view and cursor?

2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
 Question Submitted By :: AnithaBabu1
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
Answer
# 1		 
declare cursor, open cursor and close cursor
 
Is This Answer Correct ?    0 Yes 3 No
Mari
 
  Re: 1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
Answer
# 2		 
Change in view would not reflect chg in db but in cursor it 
would.
 
Is This Answer Correct ?    1 Yes 4 No
Avinash
 
 
 
  Re: 1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
Answer
# 3		 
There is no affect in DB while changing in both casess.
 
Is This Answer Correct ?    1 Yes 0 No
Shaik
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is a Join in SQL Server?  2
What is a NOLOCK?  3
What is the difference between Drop and Truncate  10
what purpose does OPENXML clause have in sql server stored procedure?  1
Can you link only other SQL Servers or any database servers such as Oracle?  1
What is the difference between having and where clause?  4
What are the pros and cons of creating extended stored procedures?  1
What is cursor ? And what is difference between Trigger ? HCL1
what is the importence of the trigger in sqlserver2000? ATI1
how to retrive only second row from table in sql server 2000? CTS7
plz send every query in sql server2000 Infosys1
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..  2
What is an index? Yardi-Software7
How to write a script for upate the data in prod , i have 50000 row are there TCS2
can any one please send sql quries most used in applications.  1
can foreign key take role of primary key? TCS4
What is the difference between truncate and delete statement? CTS4
what is the difference between sql query and google query? TCS7
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)  1
What is a Trace frag?Where can we use this?  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com