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
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 are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is tempdb database? : SQL Server Architecture
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is exporting and importing utility?
What are the hotfixes and patches in sql server?
What are the underflow and overflow behaviors on float literals?
What function does a database engine serve in the sql server?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What does executeupdate return?
what is checksum in sql server.........???
What is an example of a primary key?
There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9
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)