Quiz Space

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

DBMS End Term 22 Dec 2024 — Question 16

Question 16

+3 marksOne or more correct options

Select all that apply.

  1. A

    The decomposition of R into R1 and R2 is dependency preserving.

  2. B

    The decomposition of R into R1 and R2 is lossless.

  3. C

    The schema R1 is in 3NF.

  4. D

    The schema R2 is in 2NF.

Show answer

Correct answers

  • A

    The decomposition of R into R1 and R2 is dependency preserving.

  • C

    The schema R1 is in 3NF.

  • D

    The schema R2 is in 2NF.

See the whole paperTake it as a mock test

Question 16 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. Q17Figure 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…