If there is failure during updation of certain rows, what
will be the state?

Answer Posted / lu

The data will rollback

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What types of Joins are possible with Sql Server?

767


Explain syntax for dropping triggers?

694


Explain what role entity and relationship play in an ER diagram.

789


Explain the dirty pages?

753


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2524






Explain cdc and sql injection?

716


Is it ok to shrink transaction log?

695


How does Report Builder support Analysis Services cubes?

136


Explain the first normal form(1nf)?

743


Explain about extended stored procedure?

672


What is query processing?

692


Does sql server use t sql?

724


How to delete existing triggers using "drop trigger"?

764


How ssrs maintain security?

775


What are views used for?

777