What do you mean by concurrency control techniques? Write the comparison between single user and multi-user system. What do you mean by Transaction? Write the ACID property of Transaction. What is the need of concurrency control. Explain the lost update problem and dirty read problem. Describe the problem faced when concurrent transaction are executing in … Read more
What is transaction concept? Explain the ACID property of transaction. What is Serializability? Explain the view Serializability. Discuss conflict Serializability. What is Recoverability? What are Schedules? What are differences between conflict serializability and view serializability ? Explain with suitable example what are cascadeless and recoverable schedules? Explain cascadeless schedules and cascading rollback. What is the … Read more
Write a short note on decomposition. Write a note on Normalization. What do you mean by lossless join? Explain. What do you mean by dependency preservation? Define Functional Dependency ? What do you mean by Lossless Decomposition? Explain with a suitable example how functional dependencies can be used to show that decomposition are lossless. What … Read more
What do you mean by relational model? Explain with example. What is relational algebra ? Discuss its basic operations. Write the operations in Relational Algebra. What is relational algebra? Describe the tuple and domain relational calculus with suitable example. What do you mean by referential integrity ? Explain the concept of Foreign key with a … Read more