Interested to Buy Any Domain ? << Click Here >> for more details...
wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform
- 1 Answers
- 8862 Views
- Idea, I also Faced
- E-Mail Answers
Answer / praveen
Transaction must be Atomic (it is one unit of work and does
not dependent on previous and following transactions)
Consistent (data is either committed or roll back, no
“in-between” case where something has been updated and
something hasn’t)
Isolated (no transaction sees the intermediate results of
the current transaction)
Durable (the values persist if the data had been committed
even if the system crashes right after).
| Is This Answer Correct ? | 4 Yes | 1 No |
What is sql server agent and what are the two modes of authentication in sql server?
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
in how many ways we can use count()
What is the order by used for?
What are the authentication modes in sql server? How can it be changed?
What objects does the fn_my_permissions function reports on? : sql server security
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is a stored procedure?
How do you create an execution plan?
Where the sql logs gets stored?
How many databases instances are there in sql server 2000?
What is difference between commit and rollback when used in transactions?
-
Oracle (3259) - 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)
