Time Left - 15:00 mins

GATE 2023 Database Quiz 16

Attempt now to get your rank among 74 students!

Question 1

Which normal form is considered adequate for normal relational database design?

Question 2

Let R = (A, B, C, D, E, F) be a relation scheme with the following dependencies C → F, E → A, EC → D, A → B. Which of the following is a key for R?

Question 3

Which one of the following is a procedural language?

Question 4

Normalization form which is based on transitive dependency is classified as?

Question 5

Which symbol denote derived attributes in ER Model?

Question 6

Consider a relation R (A, B, C, D) with the following set of functional dependencies;

F = {A → B, B → C, and C → D}.

Is the decomposition of R (A, B, C, D) into R1 (A, C, D) and R2 (B, C) a dependency preserving decomposition?

  • 74 attempts
  • 1 upvote
  • 2 comments
May 9GATE & PSU CS