What is transcation?Plz give One example?
Answers were Sorted based on User's Feedback
Answer / hari
Transcation is a sequence of operations performed as single
logical unit work .
Atomicity,consistency,isolation, Durabality
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / dev
Transaction is a process to handle cretical situation data
being inserted into table if any error comes into this
picture data will be rollbacked.
| Is This Answer Correct ? | 0 Yes | 1 No |
Can you explain about buffer cash and log cache in sql server?
Call by value and call by reference in procedure and function, with NOCOPY.
What is data mart? : sql server analysis services, ssas
What are the differences between stored procedure and view in sql server?
4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What will you do If the low Performance occurs?
How to check if a table is being used in sql server?
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?
How to loop through the result set with @@fetch_status?
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?
What is a db view?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)