63.

64.

67,

140/2016 10

A software configuration management tool helps in :
(4) Keeping track of the schedule based on the milestone reached
(B) Maintaining different versions of the configurable items
(C) Managing manpower distribution by changing the project structure
(D) None of the above

A relational database contains two tables employee and department in which employee table
has columns emp-no, name and dept-id and department table has columns dept-id and
dept-name. The following insert statement were executed successfully to populate the empty
tables :

Insert into department values (1, ‘computer science’)

Insert into department values (2, ‘information technology’)

Insert info employee values (1, ‘Navin', 1)

Insert into employee values (2, ‘Mukesh’, 2)

Insert into employee values (3, ‘Suresh’, 1)

How many rows and columns will be retrieved by the following SQL statement?

Select * from employee, department
(A) Orow and 4 columns (B) 3rowsand 4 columns
)0 3rowsand 5 columns (D) 6rows and b columns

A table has fields F1, F2, F3, F4, F5 with the following functional dependencies F1 - F3
F2 5 F4, (F1, F2) - F5 in terms of normalization, this table is in :

(A) INF (B) ओषः

மணை (D) None of these

A B-tree used as an index for a large database table has four levels including the root node. If
a new key is inserted in this index ,then the maximum number of nodes that could be newly
created in the process are :

@ 5 0) 4

© 3 @O 2

Amongst the ACID properties of a transaction, the ‘durability’ property requires that the
changes made to the database by a successful transaction persist

(A) Except in case of an operating system crash
(B) Except in case of a disk crash

(C) Except in case of a power failure

(D) Always, even if there is a failure of any kind

Consider a relation R with five attributes V, W, X, Y and Z. The following functional
dependencies hold : VY -+ W, WX Z and ZY — V. Which of the following is a candidate

key for 7
ഭു VXZ ऋ) VXY
ത VWXY (D) VWXYZ

തും