DBMS End Term 22 Dec 2024 — Question 15
Show answer
Correct answers
Question 15 of 20 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 22 Dec 2024, in the September 2024 term (IIT M FOUNDATION DIPLOMA AN EXAM QDF3 22 Dec 2024). It carries 3 marks.
More questions from this paper
- Consider the table Player given in Figure 1. | pname | team | rating | age | type | |---|---|---|---|---| | AJAY | TEAM…
- Figure question
- Consider seek time of your hard disk read head is 2ms, rotational speed is 60,000 RPM. The disk has 300 sectors/track a…
- Consider a non-empty B+-tree of order 13. What are the maximum and minimum number of keys that can be placed in the roo…
- Consider a multilevel index with five levels as L1, L2, L3, L4 and L5. Let L1 be the innermost and L5 be the outermost …
- Consider the following monthly backup schedule used by a company: | Monday | Tuesday | Wednesday | Thursday | Friday | …
- Figure question
- Consider the given log records at an instance of time: | < T_0 \text{ start} > | |---| | < T_0, A, 1000, 800 > | | < T_…
- Consider the following statements:\ Hot backup refers to keeping a database up and running while the backup is being pe…
- Figure question
- Consider the Schedule given below: | T_1 | T_2 | T_3 | |---|---|---| | | | R(D) | | | R(A) | | | R(C) | | | | | W(A) | …
- Consider the following two schedules S1 and S2 and three transactions T_1, T_2, T_3: \begin{aligned} &\mathbf{S1}: R_1(…
- Figure question
- Consider the definition of the table Products. The following sequence of queries is executed on this table: Which of th…
- Figure question
- Figure question
- Figure question
- Consider the following table: | BookID | Title | Author | Publisher | |---|---|---|---| | 301 | Introduction to SQL | D…
- Consider a Block nested loop join for the two relations, instructor and department. Assuming the worst-case memory avai…