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
What types of Joins are possible with Sql Server?
Explain syntax for dropping triggers?
Explain what role entity and relationship play in an ER diagram.
Explain the dirty pages?
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.
Explain cdc and sql injection?
Is it ok to shrink transaction log?
How does Report Builder support Analysis Services cubes?
Explain the first normal form(1nf)?
Explain about extended stored procedure?
What is query processing?
Does sql server use t sql?
How to delete existing triggers using "drop trigger"?
How ssrs maintain security?
What are views used for?