Database Management Systems End Term: 21 December 2025 (September 2025 term)

1. A

   The query returns employees name who earn above the company-wide average salary and joined before the company’s latest hire.

2. B

   The query returns employees name who earn above the department’s average salary and joined before the most recent hire in the same department.

3. C

   The query returns employees name who earn above the department’s average salary and joined before the company’s latest hire.

4. D

   The query returns employees name who earn above the company-wide average salary and before the most recent hire in the same department.

Select all that apply.

1. A

   Schedule S1 is conflict serializable.

2. B

   Schedule S1 can be two-phase lockable.

3. C

   Schedule S2 is conflict serializable.

4. D

   Schedule S2 can be two-phase lockable.

1. A

   No transaction needs Roll Back.

2. B

   Transaction T3 needs to Roll Back.

3. C

   Transaction T2 needs to Roll Back.

4. D

   Transaction T1 needs to Roll Back.

1. A

   Number of blocks at L2 is 512000, Number of blocks at L3 is 12800, Number of blocks at L4 is 160, Number of blocks at L5 is 1

2. B

   Number of blocks at L2 is 512000, Number of blocks at L3 is 12800, Number of blocks at L4 is 80, Number of blocks at L5 is 1

3. C

   Number of blocks at L2 is 512000, Number of blocks at L3 is 6400, Number of blocks at L4 is 80, Number of blocks at L5 is 1

4. D

   Number of blocks at L2 is 128000, Number of blocks at L3 is 6400, Number of blocks at L4 is 3200, Number of blocks at L5 is 1600

1. A

   01011010 OR 00101110

2. B

   11001100 OR 10100000

3. C

   11001100 AND 10101010

4. D

   00110011 OR 00001010

1. A

   5

2. B

   4

3. C

   6

4. D

   3

Select all that apply.

1. A

   No undo or redo is performed for Transaction T1

2. B

   Transaction undo is performed on both T1 and T2

3. C

   Transaction redo is performed in T2

4. D

   Transanction redo is performed on both T0 and T1

Which of the following is the correct order of node traversal if we want to insert the node '76'?

1. A

   24, 60, 48, 36, 84

2. B

   24, 60, 72, 96, 108

3. C

   24, 60, 72, 96, 84

4. D

   24, 12, 72, 96, 84

1. A

   candidate keys = 2, super keys = 64

2. B

   candidate keys = 2, super keys = 48

3. C

   candidate keys = 1, super keys = 128

4. D

   candidate keys = 1, super keys = 64

1. A

   

2. B

   

3. C

   

4. D

   —

1. A

   Lossless and dependency preserving

2. B

   Lossless and not dependency preserving

3. C

   Lossy and dependency preserving

4. D

   Lossy and not dependency preserving

1. A

   F covers G but G does not cover F

2. B

   G covers F but F does not cover G

3. C

   F and G are functionally equivalent

4. D

   Neither F covers G nor G cover F

Identify the multivalued dependency (MVD) present in the table.

Select all that apply.

1. A

   EmpID →→ Project

2. B

   Project →→ Skill

3. C

   EmpID,EmpName →→ Skill

4. D

   EmpName, Project →→ Skill

Consider the following tables:

Choose the correct option.

1. A

   1-a , 2-b, 3-c, 4-d

2. B

   1-a , 2-b, 3-d, 4-c

3. C

   1-d , 2-b, 3-d, 4-c

4. D

   1-d , 2-b, 3-c, 4-d

Execute the following SQL statements in the given order.

1. A

   

2. B

   

3. C

   

4. D

   

Choose the correct option

1. A

   1-b, 2-d, 3-f

2. B

   1-a, 2-c, 3-e

3. C

   1-b, 2-c, 3-e

4. D

   1-a, 2-d, 3-f

Consider the following schema diagram of IPLt20 and answer the given subquestions

Choose the correct SQL code which is used to create the table schedule.

Select all that apply.

1. A

   CREATE table schedule ( match_id varchar(255) primary key, venue varchar(255), date varchar(255), team_1 varchar(255), team_2 varchar(255), foreign key (team_1) references teams(team_id), foreign key (team_2) references teams(team_id) )

2. B

   CREATE table schedule ( match_id varchar(255) primary key, venue varchar(255), date varchar(255), team_1 varchar(255), team_2 varchar(255), foreign key (team_1) references teams(team_id), foreign key (team_2) references teams(team_id), foreign key (match_id) references results(match_id) )

3. C

   CREATE table schedule ( match_id varchar(255) primary key, venue varchar(255), date varchar(255), team_1 varchar(255), team_2 varchar(255), foreign key (team_1, team_2) references teams(team_id) )

4. D

   CREATE table schedule ( match_id varchar(255), venue varchar(255), date varchar(255), team_1 varchar(255), team_2 varchar(255), primary key (match_id), foreign key (team_1) references teams(team_id), foreign key (team_2) references teams(team_id) )

Consider the following schema diagram of IPLt20 and answer the given subquestions

The team management has decided to make ’Surya Kumar Yadav’ as the captain of 'Mumbai Indians'. Which of the following SQL query is used to update the captain of the team 'Mumbai Indians'?

1. A

   update teams set captain = 'Surya Kumar Yadav' where team_name = 'Mumbai Indians'

2. B

   update teams where team_name = 'Mumbai Indians' set captain = 'Surya Kumar Yadav'

3. C

   update table teams set captain = 'Surya Kumar Yadav' where team_name = 'Mumbai Indians'

4. D

   update teams alter captain = 'Surya Kumar Yadav' where team_name = 'Mumbai Indians'