Which of the following is a good database management practice?(a) Adding redundant attributes(b) Removing redundant attributes(c) Not specifying primary keys(d) None of the mentionedThe question was posed to me during a job interview.Query is from Entity Relationship Model topic in division Database Design and the ER Model of RDBMS

Which of the following is a good database management practice?(a) Addi

1.	Which of the following is a good database management practice?(a) Adding redundant attributes(b) Removing redundant attributes(c) Not specifying primary keys(d) None of the mentionedThe question was posed to me during a job interview.Query is from Entity Relationship Model topic in division Database Design and the ER Model of RDBMS
Answer» The correct ANSWER is (b) Removing redundant attributes The EXPLANATION: Removing redundant attributes from a relation makes DATA extraction more efficient and faster. Thus, it is a good DATABASE management TECHNIQUE.

Discussion

No Comment Found

Related InterviewSolutions

________ is an abstraction through which relationships are treated as higher level entities(a) Creation(b) Superseding(c) Attribute separation(d) AggregationI had been asked this question during an online exam.My enquiry is from Extended E-R Features topic in section Database Design and the ER Model of RDBMS
If each higher level entity belongs to the lower level entity, then what kind of generalization is it?(a) Modal generalization(b) Partial generalization(c) Total generalization(d) None of the mentionedThe question was asked in final exam.Question is taken from Extended E-R Features in chapter Database Design and the ER Model of RDBMS
Condition defined generalization constraint is also said to be ________(a) Attribute defined(b) Constraint defined(c) Value defined(d) UndefinedI have been asked this question in final exam.Enquiry is from Extended E-R Features in section Database Design and the ER Model of RDBMS
Which of the following is not a generalization constraint?(a) Condition-defined(b) User defined(c) Disjoint(d) Machine definedI have been asked this question by my school teacher while I was bunking the class.I want to ask this question from Extended E-R Features topic in section Database Design and the ER Model of RDBMS
State true or false: The attributes of the higher level entity sets are inherited by the attributes of the lower level entity sets(a) True(b) FalseThis question was posed to me by my college director while I was bunking the class.The origin of the question is Extended E-R Features topic in section Database Design and the ER Model of RDBMS
Higher level entity sets are designated by the term _________(a) Sub class(b) Super class(c) Parent class(d) Root classThe question was asked in exam.This is a very interesting question from Extended E-R Features in portion Database Design and the ER Model of RDBMS
The similarities between the entity set can be expressed by which of the following features?(a) Specialization(b) Generalization(c) Uniquation(d) InheritanceThis question was posed to me in class test.My enquiry is from Extended E-R Features topic in division Database Design and the ER Model of RDBMS
Which of the following is the specialization that permits multiple sets(a) Superclass specialization(b) Disjoint specialization(c) Overlapping specialization(d) None of the mentionedThe question was posed to me in examination.The above asked question is from Extended E-R Features topic in portion Database Design and the ER Model of RDBMS
State true or false: Specialization can be applied only once(a) True(b) FalseThis question was posed to me by my school principal while I was bunking the class.My query is from Extended E-R Features in portion Database Design and the ER Model of RDBMS
The process of designating sub groupings within the entity set is called as _______(a) Specialization(b) Division(c) Aggregation(d) FinalizationThe question was asked in a job interview.This interesting question is from Extended E-R Features topic in chapter Database Design and the ER Model of RDBMS

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment