Q. Match the following :

List-I
(1) Determinants
(2) Candidate key
(3) Non-redundancy
(4) Functional dependency

List-II
(a) No attribute can be added
(b) Uniquely identified a row
(c) A constraint between two attribute
(d) Group of attributes on the left hand side of arrow of function dependency.

View solution

Q. A function that has no partial functional dependencies is in ……………. form.

View solution

Q. Which of the following statement is wrong?

I. 2-phase locking protocol suffer from dead lock.
II. Time stamp protocol suffer from more aborts.
III. A block hole in a DFD is a data store with only inbound flows.
IV. Multivalued dependency among attribute is checked at 3 NF level.
V. An entity-relationship diagram is a tool to represent event model.

View solution

Q. The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called

View solution

Q. (i) DML includes a query language based on both relation algebra and tuple calculus
(ii) DML includes a query language based on tuple calculus
(iii) DML includes a query language based on relational algebra
(iv) DML includes a query language based on none of the relational algebra and tuple calculus

Which one is correct?

View solution

Q. Which construct in SQL is used to test whether a subquery has any tuples in its result?

View solution

Q. An entity has:

(i) a set of properties
(ii) a set of properties and values for all the properties
(iii) a set of properties and the values for some set of properties may non-uniquely identify an entity
(iv) a set of properties and the values for some set of properties may uniquely identify an entity

Which of the above are valid?

View solution

Q. Aggregation is:

View solution

Q. Suppose R is a relation schema and F is a set of functional dependencies on R. Further, suppose R1 and R2 form a decomposition of R. Then the decomposition is a lossless join decomposition of R provided that:

View solution

Q. In a heap, every element is …………… of all the elements in the subtree.

View solution

Q. A superkey for an entity consists of:

View solution

Q. Which of the following set of keywords constitutes a mapping in SQL?

View solution

Q. If a relation is in 2NF then:

View solution

Q. Which of the following is true ?

View solution

Q. Consider the query : SELECT student_name FROM student_data WHERE rollno (SELECT rollno FROM student_marks WHERE SEM1_MARK=SEM2_MARK);

Which of the following is true?

View solution

Q. A primary key for an entity is:

View solution

Q. Aggregate functions in SQL are:

View solution

Q. If a relation is in 2NF and 3NF forms then:

View solution

Q. The end of an SQL command is denoted by:

View solution

Q. Consider  the  query  :  SELECT  student_name  FROM  students  WHERE class_name=(SELECT  class_name  FROM  students  WHERE  math_marks=100); what will be the output ?

View solution