Answer / shaik

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

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

Answer / bindu

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

Answer / mari

declare cursor, open cursor and close cursor

Answer / avinash

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

A left outer join B B right outer join A gives the same result then what is the use of two?

1 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,

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

What is change data capture (cdc) feature?

0 Answers  

Write the syntax for stuff function in an sql server?

0 Answers  

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

1 Answers   United Healthcare,

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

Explain about integration services of Microsoft SQL server?

0 Answers  

What are partitioned views and distributed partitioned views?

0 Answers  

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,