Q. An Entity - relationship diagram is a tool to represent:

View solution

Q. Multi-valued dependency among attribute is checked at which level ?

View solution

Q. A WINDOW into a portion of a data base is:

View solution

Q. The E-R model is expressed in terms of:

(i) Entities
(ii) The relationship among entities
(iii) The attributes of the entities

View solution

Q. Specialization is a ............... process.

View solution

Q. The completeness constraint has rules:

View solution

Q. The entity type on which the ................. type depends is called the identifying owner.

View solution

Q. Match the following:

(i) 5 NF              (a) Transitive dependencies eliminated
(ii) 2 NF             (b) Multivalued attribute removed
(iii) 3 NF            (c) Contains no partial functional dependencies
(iv) 4 NF            (d) Contains no join dependency

View solution

Q. The normalization of 1NF relations to 2NF involves:

View solution

Q. Tuple in relational algebra refers to:

View solution

Q. A relation R on a set X is said to be a partial ordering if R is

View solution

Q. An attribute or set of attributes within one relation that matches the candidate key of some(possibly the same) relation:

View solution

Q. With QBE, inserting records from one or more source tables into a single target table can be achieved by:

View solution

Q. SQL command to delete a column from an existing table:

View solution

Q. Data Scrubbing is

View solution

Q. An attribute A of datatype varchar(20) has the value ‘xyz’, and the attribute B of datatype char(20) has the value “lmnop”, then the attribute A has ............... spaces and attribute B has ............... spaces.

View solution

Q. Data warehouse contains ............... data that is never found in operational environment.

View solution

Q. .................. command is used to remove a relation from SQL database.

View solution

Q. Which of the following statement/s is/are true?

(i) Facebook has the world’s largest Hadoop Cluster.
(ii) Hadoop 2.0 allows live stream processing of Real time data.

Choose the correct answer from the code given below:

View solution

Q. Consider the relation schema R = (A,B,C,D,E,F) on which the following functional dependencies hold:

A → B
B, C → D
E → C
D → A

What are the candidate keys of R?

View solution