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 command is used to rename the database?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Can you explain various data region available in ssrs with their use?
What is database mirroring?
Diffrences between sql server 2000 vs 2005
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Explain about Joins?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
What is the security principal at the server level that represents your session?
What is sqlcmd?
Define indexes?
What is the command used to check locks in microsoft sql server?
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)