85.

86.

87.

88.

89.

Ina software project COCOMO is used to estimate :

(A) _ effort and duration based on the size of the software
(B) | effort and cost based on the duration of the software
(C) size and duration based on the effort of the software

(D) _ size, effort and duration based on the cost of the software

The measure of the time between observed system failures is :
(A) Probability of Failure on Demand (POFOD)
(2) Rate of Failure Occurrence (ROCOF)
(C) Mean Time to Failure MTTF)
(D) Availability (AVAIL)

Which of the following statement are TRUE about an SQL query?

@ An SQL query can contain a HAVING clause even if it does not have a GROUP BY
clause

Gi) An SQL query can contain a HAVING clause only if it has GROUP BY clause

(111) All attributes used in the GROUP BY clause must appear in the SELECT clause

(iv) Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
(A) @ and (iii) (B) (i) and (iv)
(¢ Gi) and (iii) (D) (ii) and (iv)

Consider the schema R=(A, B,C, D) and the dependencies A>B,B3C,C—D and
D-A.Let R=(R1 and R2)be a decomposition such that R, 1 R,# O. The decomposition is :
(A) Not in 2NF (B) In 2NF but not in 3NF
(0) In3NF but not in 2NF (D) In both 2NF and 3NF

When a transaction T; requests a data item currently held by T;,7, is allowed to wait only if
it has a timestamp larger than that of T; (that is T; is younger than T;). Otherwise, T; is
rolled back. The scheme is :

(^) Wait-die ൯) Wait-wound

(0) Wound-wait (D) Wait

132/2023 16 A