Assessment

_________ generally occurs whenever more than one copy of the exact same data exists in several different places.

• Data Repository

• Data Inconsistency

• Data Mining

• Data Redundancy

_________ used for identifying the subset of an entity set which share the distinguishing characteristics.

• Aggregation

• Generalization

• Specialization

• All of the above

What do you mean by one to many relationship between Teacher and Class table?

• One class may have many teachers

• One teacher can have many classes

• Many classes may have many teachers

• Many teachers may have many classes

Which of the following is a database model?

• Network Database Model

• Relational Database Model

• Object Oriented Database Model

• All the above

__________ helps us in removing all the redundant data.

• Aggregation

• Normalization

• Optimization

• Generalization

Triggers that contain DML and find other triggers for data modification are called _______.

• Nested Triggers

• DML Triggers

• DDL Triggers

• Logon Triggers

A binary search tree whose left sub tree and right subtree differ in height by at most 1 unit is called _______

• AVL tree

• Red-black tree

• Lemma tree

• None of the above

Which of the following data structure is not a linear type?

• Graph

• Trees

• Binary tree

• All the above

A growth rate of n, is referred to as _________.

• Absolute growth rate

• Linear growth rate

• Exponential growth rate

• Quadratic growth rate

An analysis that estimates resource consumption of an algorithm is known to be ___________.

• Relative analysis

• Absolute analysis

• Asymptotic analysis

• Cost analysis