Quiz Space

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

Question 19: Consider the following table: | BookID | Title | Author …

Question 19

+2 marksOne or more correct options

Consider the following table:

BookIDTitleAuthorPublisher
301Introduction to SQLDr. AndersonABC Publishers
302Data Science BasicsDr. KimXYZ Publishers
303Machine LearningDr. AndersonABC Publishers
304Data Science BasicsDr. TaylorXYZ Publishers
305Advanced SQLDr. AndersonABC Publishers

Table 2: Books

Which of the following functional dependencies hold in the Books table?

Select all that apply.

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

Correct answers

  • A
  • C
  • D
See the whole paperTake it as a mock test

Question 19 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 2 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. Q17Figure question
  18. Q18Figure question
  19. Q20Consider a Block nested loop join for the two relations, instructor and department. Assuming the worst-case memory avai…