Bissoy.com
Doctors Medicines MCQs Q&A

 Concurrency control in RDBMS is important for which of the following reasons ?

 Concurrency control in RDBMS is important for which of the following reasons ? Correct Answer To ensure data integrity when updates occur to the database in a multi-user environment.  

Concept:

RDBMS stands for a relational database management system. A relational database is made up of number of relations and corresponding relational database schema. RDBMS data is in the form of tables, records. 

Explanation:

Concurrency control in RDBMS means to manage operations that are performed simultaneously so that they will not conflict with each other. Concurrent access is quite easy when users are just reading the data. 

  • Concurrency control is important to ensure data integrity when updates occur to the database in a multi-user environment.
  • Concurrency control is used to apply isolation through mutual exclusion. 
  • It ensures serialization in the system.
  • It preserves data consistency and resolves the conflict during read-write operations.

Various concurrency control protocols are Lock-based protocols, time stamp protocols, two-phase locking.

Related Questions

Which of the following is/are the advantages of using a control chart for inspection? (i) A control chart indicates whether the process is in control or out of control. (ii) A control chart determines process variability. (iii) A control chart ensures product quality. (iv) Scrap or percentage reduction can be reduced by taking the necessary actions in time against the warnings indicated by control charts. (v) Control charts build up the reputation of the organization through customer’s satisfaction. (vi) The control chart can detect the unusual variations taking place in a process.
Concurrency control is important for which of the following reasons?
Based on the given para, answer the following question. Sensitivity considerations often are important in the design of Control Systems. Because all physical elements have properties that change with environment and age, we cannot always consider the parameters of the Control System to be completely stationary over the entire operating life of the system. For instance, the winding resistance of an electric motor changes as the temperature of the motor rises during operation. Control systems with electric components may not operate normally when first turned on because of the still-changing system parameters during warmup. This phenomenon is sometimes called “morning sickness”. Most duplicating machines have a warmup period during which time operation is blocked out when first turn on. A good Control System should be: (a) Very sensitive to parameter variations (b) Insensitive to parameter variations (c) Insensitive to input commands (d) Sensitive to input commands Which of the above are correct?
Examine the following statements about span of control and identify the ones which are true?
1. More task complexity requires narrower span of control.
2. Routine tasks can have greater span of control than exceptional tasks.
3. When tasks are dissimilar, then span of control can be larger.
4. Spans of control are generally narrower at the top and broader at the bottom of the hierarchy.
Consider a control unit generating the control signals. These control signals are divided into five mutually exclusive groups as shown below: Groups  G1  G1  G1  G1  G1 Control  Signals   3  7  10  12  2 How many bits are saved using the Vertical Micro-programmed instead of Horizontal Micro-programmed control unit?
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock? I. 2-phase locking II. Time-stamp ordering
Consider the following two statements about database transaction schedules: I. Strict two-phase locking protocol generates conflict serializable schedules that are also recoverable. II. Timestamp-ordering concurrency control protocol with Thomas’ Write Rule can generate view serializable schedules that are not conflict serializable. Which of the above statements is/are TRUE?
Which of the following concurrency control protocol ensures both conflict serializability and free from deadlock?
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock? I) 2-phase locking II) Timestamp ordering