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 |
What are “phantom rows”?
How to defragment indexes with alter index ... Reorganize?
What xml support does the sql server extend?
1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format
what is replication? where do u use Go Keyword?
What is resource governor?
what is statistics
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What are difference between Cluster index and Non-Cluster index?
How you can move data or databases between servers and databases in sql server?
How many types of triggers are there?
Explain SELF JOIN ?
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)