Quiz Space

January 2023 term · Database Management Systems · BSCS2001

DBMS End Term: 30 April 2023, Set QPD1-S2 (January 2023 term)

The IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 30 Apr 2023, in the January 2023 term, set QPD1-S2: 25 questions for 50 marks in 180 minutes. Every question is below with its answer. Take it as a timed mock test to be marked, or read it through first.

Questions
25
Marks
50
Duration
180 min
MSQ
9
MCQ
13
Numerical
3
Take as mock testPractise with answers

Updated

Official paper: IIT M DIPLOMA ET1 EXAM QPD1 S2 30 Apr 2023 · No negative marking.

Question 1

+2 marksOne or more correct options

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • B
  • D
Question 1 on its own page

Question 2

+2 marksOne or more correct options

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • A
  • D
Question 2 on its own page

Question 3

+2 marksOne or more correct options

Select all that apply.

  1. A

    45, 65, 8, 9, 15, 11, 22, 48, 95, 46, 6

  2. B

    45, 65, 6, 9, 15, 22, 11, 48, 95, 46, 8

  3. C

    45, 65, 9, 8, 15, 22, 11, 48, 95, 46, 6

  4. D

    45, 65, 8, 9, 15, 22, 11, 48, 95, 46, 6

Show answer

Correct answers

  • A

    45, 65, 8, 9, 15, 11, 22, 48, 95, 46, 6

  • D

    45, 65, 8, 9, 15, 22, 11, 48, 95, 46, 6

Question 3 on its own page

Question 4

+2 marksOne or more correct options

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • A
  • C
Question 4 on its own page

Question 5

+2 marksOne or more correct options

The snapshot of a database at a point of time is provided below. Which of the following statements are correct with respect to the procedure followed after a system crash?

Sl.no.T1T2T3
1.start
2.Read (B)
3.Write (B)
4.start
5.Write (C)
6.Commit
7.Start
8.Read (A)
9.Commit
10.System CrashSystem CrashSystem Crash

Figure 3: Log records at a point of time

Select all that apply.

  1. A

    Transaction T1 and T2 must roll back.

  2. B

    Transaction T3 must be undone.

  3. C

    Redo transaction T1 and T2

  4. D

    Redo transaction T1, T2, and T3

Show answer

Correct answers

  • B

    Transaction T3 must be undone.

  • C

    Redo transaction T1 and T2

Question 5 on its own page

Question 6

+2 marksOne or more correct options

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • C
  • D
Question 6 on its own page

Question 7

+3 marksOne or more correct options

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • A
  • B
  • C
Question 7 on its own page

Question 8

+3 marksOne or more correct options

Select all that apply.

  1. A
  2. B
  3. C
  4. D
  5. E
Show answer

Correct answers

  • B
  • D
Question 8 on its own page

Question 9

+1 markOne correct option
  1. A

    It provides poor read and write performance.

  2. B

    It requires a large number of disks.

  3. C

    It provides no fault tolerance or data redundancy.

  4. D

    All of these.

Show answer

Correct answer

  • C

    It provides no fault tolerance or data redundancy.

Question 9 on its own page

Question 10

+1 markOne correct option
  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • D
Question 10 on its own page

Question 11

+1 markOne correct option

Which of the following precedence graphs represents a schedule that is not conflict serializable?

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • D
Question 11 on its own page

Question 12

+1 markOne correct option

Which of the following backup strategies provides the most comprehensive protection against data loss?

  1. A

    Incremental backup

  2. B

    Full backup

  3. C

    Differential backup

  4. D

    All of these

Show answer

Correct answer

  • B

    Full backup

Question 12 on its own page

Question 13

+1 markOne correct option
  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • C
Question 13 on its own page

Question 14

+1 markOne correct option
  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • D
Question 14 on its own page

Question 15

+2 marksOne correct option

Consider a B-tree based index with an order p = 25. Assume that each node in the B-tree is 80% full. What is the minimum number of keys that the B-tree can have?

  1. A

    19,880

  2. B

    19,800

  3. C

    18,000

  4. D

    19,999

Show answer

Correct answer

  • D

    19,999

Question 15 on its own page

Question 16

+2 marksOne correct option

Consider the table given in the figure 5 along with the record numbers indicated as REC_NO. ii for each record in the table.

user_idusernameemail_idgenderagecountrycreated_on
REC_NO. 13765Stevesteve@outlook.comM34USA2000-03-19
REC_NO. 24135Marcomarcos@ymail.comM55Australia1995-10-20
REC_NO. 38762Joshuajosh99@gmail.comF49Canada2002-06-18
REC_NO. 41289Dreamydreamy@rediffmail.comF18UK2020-12-08
REC_NO. 52359Jacobjacoster@gmail.comM29Russia2014-08-24

Figure 5: Table Users

The associated ordered index file has consecutive entries with record pointers pointing to the record numbers: 4, 5, 1, 3, 2. Identify the attribute on which the index is built.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • C
Question 16 on its own page

Question 17

+3 marksOne correct option

Consider the table score as shown below.

roll_nom1m2m3s1s2
21f13445677833
21f23444627833
21f33435678333
21f43445177823
21f51445277833
21f923456678NULL
21f7234578NULLNULL

Table: Score

Match the below SQL queries with the correct output.

SQL queries:
A: SELECT count(s1) FROM score
B: SELECT count(distinct s2) FROM score
C: SELECT count(*) FROM score
D: SELECT avg(s2) FROM score

Output:

  1. 7
  2. 6
  3. 31
  4. 22.14
  5. 2
  6. 3
  1. A

    A-1, B-6, C-1, D-4

  2. B

    A-1, B-6, C-2, D-3

  3. C

    A-2, B-5, C-1, D-3

  4. D

    A-2, B-5, C-2, D-4

Show answer

Correct answer

  • C

    A-2, B-5, C-1, D-3

Question 17 on its own page

Question 18

+3 marksOne correct option
  1. A

    {40, 80}

  2. B

    {40}

  3. C

    {10, 30}

  4. D

    {40, 20}

Show answer

Correct answer

  • B

    {40}

Question 18 on its own page

Question 19

+2 marksNumerical answer

Consider a magnetic disk with 16 platters, 2 surfaces/platter, 1024 tracks/surface, 2048 sectors/track, and 1024 bytes/sector. The disk rotates with 6000 revolutions per minute. What is the minimum number of bits required for addressing all the sectors?

Show answer

Correct answer: 26

Question 19 on its own page

Question 20

+3 marksNumerical answer
Show answer

Correct answer: 4

Question 20 on its own page

Question 21

+3 marksNumerical answer
Show answer

Correct answer: 15

Question 21 on its own page

Question 22

+3 marksOne or more correct options

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

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • B
  • C
Question 22 on its own page

Question 23

+1 markOne correct option

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

Consider a scenario where a match having match id 'M009' scheduled on '30-04-2023' has shifted to 'Chinnaswamy Stadium' from 'Chepauk Stadium'.

Which of the following SQL query is used to update the venue to 'Chinnaswamy Stadium'?

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • A
Question 23 on its own page

Question 24

+2 marksOne correct option

Answer the subquestions on the basis of the given data.

Consider a RAID-5 system with 5 disks which stores the following data shown in Figure 6.

DISK - 1DISK - 2DISK - 3DISK - 4DISK - 5
010100000100XXXX1110BLOCK A
010100100101XXXX0100BLOCK B

Figure 6: RAID-5 data

According to the figure disk-4 has crashed. What data is present in the two blocks of disk-4? Note: Assume block size is 4 bits

  1. A

    block A: 0101, block B: 0101

  2. B

    block A: 1110, block B: 0100

  3. C

    block A: 1111, block B: 0110

  4. D

    block A: 0001, block B: 0001

Show answer

Correct answer

  • C

    block A: 1111, block B: 0110

Question 24 on its own page

Question 25

+2 marksOne correct option

Answer the subquestions on the basis of the given data.

Consider a RAID-5 system with 5 disks which stores the following data shown in Figure 6.

DISK - 1DISK - 2DISK - 3DISK - 4DISK - 5
010100000100XXXX1110BLOCK A
010100100101XXXX0100BLOCK B

Figure 6: RAID-5 data

Assume that the binary values represent 8-bit ASCII code. What is the data word present inside this RAID-5 storage system?
Note: The ASCII value of ‘A’ is 65 and ‘a’ is 97.

  1. A

    POST

  2. B

    PORT

  3. C

    PART

  4. D

    PLUM

Show answer

Correct answer

  • B

    PORT

Question 25 on its own page