Quiz Space

Database Management Systems · End Term · 22 Dec 2024 · September 2024 term · Set QDF1

DBMS End Term 22 Dec 2024 — Question 17

Question 17

+3 marksOne or more correct options

Select all that apply.

  1. A

    A bank offers more than one loan

  2. B

    An account is managed by more than one bank

  3. C

    Every loan must be availed by at least one customer

  4. D

    Every customer must be holding at least one account

Show answer

Correct answers

  • A

    A bank offers more than one loan

  • D

    Every customer must be holding at least one account

Question 17 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

  1. Q1Consider the table Player given in Figure 1. | pname | team | rating | age | type | |---|---|---|---|---| | AJAY | TEAM…
  2. Q2Figure question
  3. Q3Consider seek time of your hard disk read head is 2ms, rotational speed is 60,000 RPM. The disk has 300 sectors/track a…
  4. Q4Consider a non-empty B+-tree of order 13. What are the maximum and minimum number of keys that can be placed in the roo…
  5. Q5Consider a multilevel index with five levels as L1, L2, L3, L4 and L5. Let L1 be the innermost and L5 be the outermost …
  6. Q6Consider the following monthly backup schedule used by a company: | Monday | Tuesday | Wednesday | Thursday | Friday | …
  7. Q7Figure question
  8. Q8Consider the given log records at an instance of time: | < T_0 \text{ start} > | |---| | < T_0, A, 1000, 800 > | | < T_…
  9. Q9Consider the following statements:\ Hot backup refers to keeping a database up and running while the backup is being pe…
  10. Q10Figure question
  11. Q11Consider the Schedule given below: | T_1 | T_2 | T_3 | |---|---|---| | | | R(D) | | | R(A) | | | R(C) | | | | | W(A) | …
  12. Q12Consider the following two schedules S1 and S2 and three transactions T_1, T_2, T_3: \begin{aligned} &\mathbf{S1}: R_1(…
  13. Q13Figure question
  14. Q14Consider the definition of the table Products. The following sequence of queries is executed on this table: Which of th…
  15. Q15Figure question
  16. Q16Figure question
  17. Q18Figure question
  18. Q19Consider the following table: | BookID | Title | Author | Publisher | |---|---|---|---| | 301 | Introduction to SQL | D…
  19. Q20Consider a Block nested loop join for the two relations, instructor and department. Assuming the worst-case memory avai…