Concurrency control is important for which of the following reasons?

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.

A

i, ii, iii only

B

i, iv, v only

C

i, ii, iii, iv, v and vi

D

iv, v and vi

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

A

To ensure data integrity when updates occur to the database in a single -user environment.

B

To ensure data integrity when reads occur to the database in a single-user environment.

C

To ensure data integrity when updates occur to the database in a multi-user environment.

D

To ensure data integrity when reads occur to the database in a multi-user environment.

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?

A

(a) and (b)

B

(b) and (c)

C

(b) and (d)

D

(a) and (d)

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.

A

Both 1 and 2

B

1, 3 and 4

C

Both 2 and 4

D

1, 2 and 4

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?

A

14

B

34

C

20

D

None

Which of the following is not a factor in determining the concurrency control behavior of SQL Server?

A

Lock level

B

Transaction isolation level

C

Cursor concurrency setting

D

Locking hints

Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock? I. 2-phase locking II. Time-stamp ordering

A

I only

B

II only

C

Both I and II

D

Neither I nor II

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?

A

I only

B

II only

C

Both I and II

D

Neither I nor II

Which of the following concurrency control protocol ensures both conflict serializability and free from deadlock?

A

Time stamp ordering

B

2 Phase locking

C

Both (a) and (b)

D

None of the above

Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock? I) 2-phase locking II) Timestamp ordering

A

I only

B

II only

C

Both I and II

D

Neither I nor II

Concurrency control is important for which of the following reasons?

Related Questions