Concurrency control in DBMS is essential to manage simultaneous access to the database by multiple transactions, ensuring data consistency and integrity. Two-Phase Locking (2PL) is a standard protocol for achieving serializability, a key property for correct concurrent execution.
What is a common technique for concurrency control in DBMS? - Question not attempted
Asked in Analyst Cum Programmer (Deputy Director) 2024 · Topic: Basics of Computers and Information Technology (Database Management Systems (DBMS) Basics: Concepts, Types of Databases)
Show answer
Answer: D. Two phase locking
Read the notes: Basics of Computers and Information Technology →
More Information and Communication Technology questions
- Which condition must be true for using MINUS between two relations? - Question not attempted
- In embedded SQL, which prefix allows the programmers to refer shared variables in SQL statements? - Question not attempted
- Which of the following statement is true with regards to candidate keys and super keys? - Every super key is a candidate key. - Candidate keys must contain all attributes of the relation. - Candidate keys are minimal super key with no redundant attributes. - A candidate key must include a foreign key. - Question not attempted
- Under which of the following conditions, a SQL view is said to be updatable? - The FROM clause has more than one database relation. - The SELECT clause contains only attribute names (no expressions, aggregates or DIS‐ TINCT). - Any attribute not listed in SELECT clause can be set to NULL and is not part of primary key. - The query does not use GROUP BY or HAVING. Select the correct combination using the code below - (1) (A), (B), (C) and (D) (2) (A), (B) and (D) only (3) (B), (C) and (D) only (4) (A) and (B) only (5) Question not attempted
- Consider a database table - Studentcourses(Student_Id, Student_Name, Course_Id, Course_Name, Instructor_Name) If a new course "XYZ123" is required to be introduced but none of the students have enrolled for it yet then which amongst the following problems will the database face? - Updation anomaly - View anomaly - Deletion anomaly - Insertion anomaly - Question not attempted
- What is the primary goal of query optimization in a DBMS? - To encrypt data during query execution - To validate query syntax - To normalize the database schema - To find the most efficient and cost-effective way to execute a query - Question not attempted
- In M.S. Excel, column in a table is called as
- Tag 260 in MARC-21 marks :
All 1,360 Information and Communication Technology questions →