Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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 Posted / anithababu1

Answers were Sorted based on User's Feedback



1.what is the difference between view and cursor? 2.If we do any change in view will it affect th..

Answer / shaik

There is no affect in DB while changing in both casess.

Is This Answer Correct ?    21 Yes 5 No

1.what is the difference between view and cursor? 2.If we do any change in view will it affect th..

Answer / sripathi venkata ramesh

I am Sripathi Venkata Ramesh from Gudivada.

1. The answer for view and cursor is mentioned below

Views: Views are used to retrieve date or Update the data

Cursors: Cursors are used to execute the data row by row or
record by record.
There are 2 types of cursors.

1. Implicit cursor: It returns only one
row

2. Explicit cursor: It returns more
than one row

Is This Answer Correct ?    19 Yes 7 No

1.what is the difference between view and cursor? 2.If we do any change in view will it affect th..

Answer / bindu

Both Cursors and Views doesn't store data , so their is no chance to affect the DB.

Is This Answer Correct ?    4 Yes 5 No

1.what is the difference between view and cursor? 2.If we do any change in view will it affect th..

Answer / mari

declare cursor, open cursor and close cursor

Is This Answer Correct ?    4 Yes 29 No

1.what is the difference between view and cursor? 2.If we do any change in view will it affect th..

Answer / avinash

Change in view would not reflect chg in db but in cursor it
would.

Is This Answer Correct ?    5 Yes 32 No

Post New Answer

More SQL Server Interview Questions

What is the significance of null value and why should we avoid permitting null values?

0 Answers  

What is Replication?

0 Answers  

How does stuff differ from the replace function?

0 Answers  

What is a data source or ds? : sql server analysis services, ssas

0 Answers  

What is a Stored Procedure?

8 Answers  

What is table join?

0 Answers  

Explain query editor regions

0 Answers  

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

What are the results of running this script?

0 Answers  

What is the difference between push and pull subscription? : sql server replication

0 Answers  

How to get the definition of a stored procedure back?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories