Recent questions tagged goclasses-databases-practice-questions

Consider the two FD sets, $F=\{A \to B,\ B \to C,\ C \to A\}$ and $G=\{A \to C,\ C \to B,\ B \to A\}$.Which of the following statements is correct?Only $F$ is a minimal c...

Consider $F=\{AB \to CF,\ CD \to EA,\ E \to ABC,\ B \to F,\ C \to D\}$Which of the following is a minimal cover of $F$?$\{AB \to C,\ C \to D,\ C \to E,\ E \to A,\ E \to B...

Consider $F=\{P \to S,\ PQ \to ST,\ S \to RU,\ RU \to S,\ PT \to V\}$.Which of the following is a minimal cover of $F$?$\{P \to S,\ PQ \to ST,\ S \to RU,\ RU \to S,\ PT \...

Consider $F=\{A \to B,\ AB \to C\}$.Which of the following statements is correct?$B$ is extraneous in the left-hand side of $AB \to C$. $A$ is extraneous in the left-hand...

Consider the following two sets of functional dependencies:$F=\{A \to B,\ B \to C\}$$G=\{A \to B,\ B \to C,\ A \to C\}$Which of the following statements are correct?$F$ c...

Consider the relation schema $R(A,B,C,D,E)$ with $F=\{AB \to D,\ AC \to E,\ A \to B,\ BC \to E,\ A \to E\}$.Consider the following functional dependencies:$A \to D$$AC \t...

Consider the relation schema $R(A,B,C,E,F,G,H)$ with $F=\{A \to BC,\ C \to FG,\ E \to HG,\ G \to A\}$Which of the following statements are correct?$A^+=\{A,B,C,F,G\}$ $A ...

Consider the relation schema $R(A,B,C,D,E)$ with$F=\{AB \to C,\ CD \to E,\ DE \to B\}$Which attributes must necessarily occur in every candidate key of $R$?$A$ $B$ $C$ $D...

Consider the relation$Student(S,I,E,N,L)$with the functional dependencies$F=\{S \to I,\ I \to E,\ E \to S,\ N \to L\}$Which of the following are candidate keys?$SN$ $IN$ ...

Consider the relation schema $R(A,B,C,D,E,F)$ with$F=\{BE \to C,\ B \to F,\ D \to F,\ AEF \to B,\ A \to E\}$Which of the following is a candidate key of $R$?$ACD$ $AD$ $F...

Consider the relation schema $R(A,B,C,D,E,F)$ with the functional dependencies$F=\{A \to BF,\ B \to F,\ CD \to E,\ DE \to F\}$.What is $(CD)^+$?$\{C,D,E\}$ $\{C,D,E,F\}$ ...

Suppose $R(A,B,C)$ satisfies $AB \to C$ and $B \to C$.Which of the following two-tuple relation instances is a valid counterexample showing that $A \to C$ does not necess...

Suppose the following functional dependencies hold on $R(A,B,C,D)$:$A \to B$$B \to C$Which of the following functional dependencies must also hold?$A \to C$ $AC \to B$ $C...

Consider the relation schema $R(A,B,C,D)$.Which of the following are trivial functional dependencies?$AB \to A$ $A \to AB$ $ABC \to BC$ $CD \to D$ $B \to C$

Consider a relation schema $R(A,B,C)$.Which of the following statements are correct?If one legal instance of $R$ satisfies $A \to B$, then $A \to B$ must hold as a functi...

Consider the following schema:$\text{Parent(pid ~INTEGER ~PRIMARY KEY)}$$\text{Child(cid ~INTEGER, ~pid ~INTEGER,}$$\text{PRIMARY KEY(cid,~pid),}$$\text{FOREIGN KEY(pid) ...

Consider relation $S(D,E)$ with primary key $(D,E)$.The current instance of $S$ contains $(1,3)$, $(2,4)$, $(3,1)$.Relation $R(A,B,C)$ contains the foreign-key constraint...

Consider the relations $\text{Employee}(eid)$, $\text{Policy}(pid,eid)$, $\text{Dependent}(did,pid)$.The following foreign keys are defined:$\text{Policy}.eid$ $\text{ RE...

Consider the relations $Parent(pid)$ and $Child(cid,pid)$where $Parent.pid$ is the primary key and $Child.pid$ is a foreign key referencing $Parent.pid$No cascading actio...

Let $R(A,B,C)$ be a referencing relation and $S(D,E)$ be a referenced relation.Suppose $B$ is a foreign key of $R$ that references the candidate key $D$ of $S$.Which of t...

Suppose the relation $R(A)$ exists and currently contains several tuples.The following SQL statements are executed in sequence:$\text{DELETE\ FROM\ R;}$$\text{INSERT\ INT...

Consider the relation$\text{Student(sid,\ name,\ age)}$where the attributes occur in the schema in the order shown.Which of the following statements correctly inserts the...

A relation $R(A,B)$ currently contains $7$ tuples.The following SQL statement is executed:$\text{ALTER\ TABLE\ R\ ADD\ C\ INTEGER;}$Immediately after this command, and be...

A table contains the following attributes:$\text{code\ CHAR(6)}$$\text{name\ VARCHAR(10)}$Which of the following statements are correct?A value of $\text{code}$ has a fix...

Consider the following SQL statements:$\text{CREATE\ TABLE\ Student\ (sid\ INTEGER,\ name\ VARCHAR(20));}$ $\text{ALTER\ TABLE\ Student\ ADD\ age\ INTEGER;}$ $\text{UPDAT...

Let $K_1$ and $K_2$ be two distinct candidate keys of a relation $R$.Let $S_1$ and $S_2$ be two superkeys of $R$.Which of the following statements are always true?$K_1\cu...

Consider the relation schema $R(A,B,C,D,E)$.It is known that $R$ has exactly two candidate keys, and one of them is ${A,B}$.What are the maximum and minimum possible numb...

A relation schema $R$ has $6$ attributes.What is the maximum number of candidate keys that $R$ can simultaneously have?

A relation schema $R$ has $6$ attributes.Assume that the empty set is not considered a key.What is the maximum possible number of superkeys of $R$?

Consider the following relation instance $R(A,B,C)$:$$\begin{array}{|c|c|c|}\hlineA & B & C \\\hline\alpha & \delta & \xi \\\beta & \delta & \psi \\\gamma & \eta & \xi \\...