Example & Drawbacks of two phase locking in hindi | How two-phase locking work with commit in DBMS|
Happy New Year 2019.
Do you know how commit works for two phase locking??. Learn with us and examples and drawbacks for 2 phase. This tutorial is helpful for MCA, BCA, BTECH, M.Sc students and NET and other competitive exam aspirants. Hope you like the video. Share it with friends and Subscribe to channel.
Following are the important topics of dbms
ER‐model - entity–relationship model, strong entity set, weak entity set, single valued attribute, multivalued attribute, stored attribute, derived attribute, simple attribute composite attribute, weak relationship, strong relationship, mapping, cardinality ratios, discriminator attribute, fan trap, chasm trap
Relational model – relational table, column, domain, row, tuple,
relational algebra – selection, projection, union, intersection, set difference, Cartesian product, natural join, left outer join, right outer join, complete outer join, theta join, division operator, nested query, safe query
tuple calculus – tuple relational calculus, domain relational calculus,
SQL – select, from, where, order by, group by, max, min, avg, count, sum, having,
Integrity constraints – super key, candidate key, primary key, foreign key, alternate key, secondary key, surrogate key
normal forms – first normal form, second normal form, third normal form, bcnf, 4nf, 5nf, functional dependency, minimal cover, canonical collection, multivalued functional dependency, dependency preserving, lossy and lossless decomposition.
File organization – indexing, B, B+ trees, key attribute, anchor attribute, primary indexing, secondary indexing, clustered indexing, multilevel indexing, block pointer, tree pointer, record pointer, top down search, sequential search, range query, index file, ordering, non-ordering
Transactions and concurrency control- transaction, acid properties, atomicity, consistency, isolation, durability, life cycle of a transaction, active state, partially committed state, committed state, abort, rollback, terminated, phantom read, dirty read, unrepeatable read, lost update problem, conflict serializability, view serializability, irrecoverable schedule, cascading rollback, recoverable schedule, cascadless schedule.
Lock based protocol, two phase locking, exclusive lock, shared lock, growing phase, shrinking phase, conservative two-phase locking, rigorous two phase locking, strict two phase locking, time stamping, time stamp, read, write, deadlock, granularity, tree based protocol,
how to find normal form in dbms in hindi,how to identify normal form in dbms in hindi,normal form in dbms in hindi,practice problems on normalization dbms,practice problems on normal form in dbms,practice questions on normal form in dbms,practice questions on normalization in dbms,shortcut methods to find normal form,how to normalize a relation table,normalization in database with example in hindi,normalization in dbms in hindi,normalization 1nf 2nf 3nf with examplehow to find normal form in dbms in hindi,how to identify normal form in dbms in hindi,normal form in dbms in hindi,practice problems on normalization dbms,practice problems on normal form in dbms,practice questions on normal form in dbms,practice questions on normalization in dbms,shortcut methods to find normal form,how to normalize a relation table,normalization in database with example in hindi,normalization in dbms in hindi,normalization 1nf 2nf 3nf with examplehow to find normal form in dbms in hindi,how to identify normal form in dbms in hindi,normal form in dbms in hindi,practice problems on normalization dbms,practice problems on normal form in dbms,practice questions on normal form in dbms,practice questions on normalization in dbms,shortcut methods to find normal form,how to normalize a relation table,normalization in database with example in hindi,normalization in dbms in hindi,normalization 1nf 2nf 3nf with examplehow to find normal form in dbms in hindi,how to identify normal form in dbms in hindi,normal form in dbms in hindi,practice problems on normalization dbms,practice problems on normal form in dbms,practice questions on normal form in dbms,practice questions on normalization in dbms,shortcut methods to find normal form,how to normalize a relation table,normalization in database with example in hindi,normalization in dbms in hindi,normalization 1nf 2nf 3nf with examplehow to find normal form in dbms in hindi,how to identify normal form in dbms in hindi,normal form in dbms in hindi,practice problems on normalization dbms,practice problems on normal form in dbms,practice questions on normal form in dbms,practice questions on normalization in dbms,shortcut methods to find normal form,how to normalize a relation table,normalization in database with example in hindi,normalization in dbms in hindi,normalization 1nf 2nf 3nf with example