1
GATE CSE 2004
MCQ (Single Correct Answer)
+2
-0.6
A program takes as input a balanced binary search tree with n leaf nodes and computes the value of a function g(x) for each node x. If the cost of computing g(x) is min{ no. of leaf-nodes in left-subtree of x, no. of leaf-nodes in right-subtree of x } then the worst-case time complexity of the program is
A
$$\Theta (n)$$
B
$$\Theta (n \log n)$$
C
$$\Theta(n^2)$$
D
$$\Theta (n^2\log n)$$
2
GATE CSE 2004
MCQ (Single Correct Answer)
+2
-0.6
Consider the following entity relationship diagram $$(ERD),$$ where two entities $$E1$$ and $$E2$$ have a relation $$R$$ of cardinality $$1:m.$$ GATE CSE 2004 Database Management System - Er Diagrams Question 7 English

The attributes of $$E1$$ are $$A11, A12$$ and $$A13$$ where $$A11$$ is the key attribute. The attributes of $$E2$$ are $$A21, A22$$ and $$A23$$ where $$A21$$ is the key attribute and $$A23$$ is a multi-valued attribute. Relation $$R$$ does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form $$(3NF)$$ is designed form the above $$ERD.$$ The minimum number of tables in the database is

A
$$2$$
B
$$3$$
C
$$4$$
D
$$5$$
3
GATE CSE 2004
MCQ (Single Correct Answer)
+2
-0.6
The relation scheme student Performance (Name, CourseNo, RollNo, Grade) has the following functional dependencies:

Name, courseNo $$\,\, \to \,\,$$ grade
RollNo, courseNo $$\,\, \to \,\,$$ grade
$$\,\,\,\,\,\,\,\,\,\,\,\,\,\,\,$$$$\,\,\,\,\,\,\,\,\,$$ Name $$\,\, \to \,\,$$ rollNo
$$\,\,\,\,\,\,\,\,\,\,\,\,\,$$$$\,\,\,\,\,\,\,\,\,$$ RollNo $$\,\, \to \,\,$$ name

The highest normal form of this relation scheme is

A
$$2\,NF$$
B
$$3\,NF$$
C
$$BCNF$$
D
$$4\,NF$$
4
GATE CSE 2004
MCQ (Single Correct Answer)
+2
-0.6
A relation Empdt $$1$$ is defined with attributes empcode (unique), name, street, city, state and pincode. For any pincode, there is only one city and state. Also, for any given street city and the state, there is just one pincode. In normalization terms, Empdt$$1$$ is a relation in
A
$$1NF$$ only
B
$$2NF$$ and hence also in $$1NF$$
C
$$3NF$$ and hence also in $$2NF$$ and $$1NF$$
D
$$BCNF$$ and hence also in $$3NF,$$ $$2NF$$ and $$1NF$$
EXAM MAP
Medical
NEET
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
CBSE
Class 12