Anyone please explain me the concept of Serialization?
Answers were Sorted based on User's Feedback
Answer / monal
Serialization is highest level of Isolation. Most resource
intensive and slowest isolation level. But because of
serialization isolation level all concurrency issues like
dirty read, repeatable read and phantom read won't occur.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anil sharma
Serialization means organise data with relations between
tables.Removing duplicate row maintain structured data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nixo
Serialization, This is the higest level of Isolation.
When this is on, no dirty reads, no nonrepeatable reads
and no phantom rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
Define Joins?
What are the differences between local and global temporary tables?
How do I find my localdb version?
Tell me what is sql profiler?
How to define and use table alias names in ms sql server?
Differentiate between delete and truncate.
Explain concepts of analysis services?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Explain sql delete command?
Explain about nested stored procedure?
How to create logins using windows Authentication mode?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
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)