1
GATE CSE 2013
MCQ (Single Correct Answer)
+1
-0.3
An index is clustered, if
A
It is on a set of fields that form a candidate key.
B
It is on a set of fields that include the primary key.
C
The data records of the file are organized in the same order as the data entries of the index.
D
The data records of the file are organized not in the same order as the data entries of the index.
2
GATE CSE 2013
MCQ (Single Correct Answer)
+2
-0.6
Relation $$R$$ has eight attribution $$ABCDEFGH.$$ Fields of $$R$$ contain only atomic values.
$$F = \left\{ {CH \to G,\,\,A \to BC,\,B \to CFH,\,\,E \to A,\,\,F \to EG} \right\}$$ set of functional dependencies $$(FDs)$$ so that $${F^ + }$$ is exactly the set of $$FDs$$ that hold for $$R.$$

How many candidate keys does the relation $$R$$ have?

A
$$3$$
B
$$4$$
C
$$5$$
D
$$6$$
3
GATE CSE 2013
MCQ (Single Correct Answer)
+2
-0.6
Relation $$R$$ has eight attribution $$ABCDEFGH.$$ Fields of $$R$$ contain only atomic values.
$$F = \left\{ {CH \to G,\,\,A \to BC,\,B \to CFH,\,\,E \to A,\,\,F \to EG} \right\}$$ set of functional dependencies $$(FDs)$$ so that $${F^ + }$$ is exactly the set of $$FDs$$ that hold for $$R.$$

The relation $$R$$ is

A
in $$1NF,$$ but not in $$2NF.$$
B
in $$2NF,$$ but not in $$3NF.$$
C
in $$3NF,$$ but not in $$BCNF$$
D
in $$BCNF.$$
4
GATE CSE 2013
MCQ (Single Correct Answer)
+1
-0.3
In the following truth table $$V=1$$ if and only if the input is valid. GATE CSE 2013 Digital Logic - Combinational Circuits Question 18 English

What function does the truth table represent?

A
Priority encoder
B
Decoder
C
Multiplexer
D
Demultiplexer
EXAM MAP