44 + Interview Questions in Normalization in Database Management Page 1 InterviewSolution

1.	The functional dependency can be tested easily on the materialized view, using the constraints ____________.(a) Primary key(b) Null(c) Unique(d) Both Null and UniqueThe question was asked during an online interview.I need to ask this question from Algorithms for Decomposition in portion Normalization of Database Management
Answer» Right OPTION is (d) Both NULL and Unique To EXPLAIN: Primary key CONTAINS both unique and not null CONSTRAINTS.

Discussion

2.	Blueprints are intended to:(a) Prototype of the screen layout showing navigation and main design elements(b) Show the grouping of pages and user journeys(c) Indicate the structure of a site during site design and as a user feature(d) Prototype typical customer journeys or clickstreams through a websiteThis question was addressed to me in an interview for job.My question is based upon Application Programs and User Interfaces topic in division Normalization of Database Management
Answer» The correct ANSWER is (c) Indicate the STRUCTURE of a site during site design and as a USER feature Easy explanation - A blueprint is a REPRODUCTION of a technical drawing, documenting an architecture or an ENGINEERING design, using a contact print process.

Discussion

3.	In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ?(a) Dept name, year->size(b) Year->size(c) Dept name->size(d) Size->yearThe question was asked by my school teacher while I was bunking the class.This interesting question is from Database Design Process in section Normalization of Database Management
Answer» The CORRECT ANSWER is (a) Dept name, YEAR->size To EXPLAIN: The PROCESS of taking a normalized schema and making it nonnormalized is called denormalization.

Discussion

4.	Storyboards are intended to:(a) Indicate the structure of a site during site design and as a user feature(b) Prototype of the screen layout showing navigation and main design elements(c) Integrate consistently available components on the webpage (e.g. navigation, search boxes)(d) Prototype typical customer journeys or click streams through a websiteI had been asked this question in exam.My doubt stems from Application Programs and User Interfaces topic in portion Normalization of Database Management
Answer» Right CHOICE is (d) Prototype typical customer journeys or click streams through a website Best EXPLANATION: An APPLICATION programming INTERFACE SPECIFIES how some software components should interact with each other.

Discussion

5.	_____________ can help us detect poor E-R design.(a) Database Design Process(b) E-R Design Process(c) Relational scheme(d) Functional dependenciesThis question was posed to me in an interview for job.The origin of the question is Database Design Process topic in chapter Normalization of Database Management
Answer» Correct choice is (d) Functional dependencies Best EXPLANATION: For eg.,Suppose an INSTRUCTOR ENTITY set had attributes dept NAME and dept address, and there is a functional DEPENDENCY dept name -> dept address.

Discussion

6.	What is the best way to represent the attributes in a large database?(a) Relational-and(b) Concatenation(c) Dot representation(d) All of the mentionedThis question was addressed to me by my school teacher while I was bunking the class.The doubt is from Database Design Process in portion Normalization of Database Management
Answer» CORRECT option is (B) Concatenation To explain: Example INST SEC and STUDENT sec.

Discussion

7.	Which is a bottom-up approach to database design that design by examining the relationship between attributes:(a) Functional dependency(b) Database modeling(c) Normalization(d) DecompositionI had been asked this question in unit test.My question is based upon Normal Forms in portion Normalization of Database Management
Answer» Right ANSWER is (C) Normalization To explain: Normalisation is the process of removing REDUNDANCY and UNWANTED data.

Discussion

8.	Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:(a) 1NF(b) 2NF(c) 3NF(d) All of the mentionedThis question was posed to me in an online quiz.I need to ask this question from Normal Forms in portion Normalization of Database Management
Answer» Right choice is (c) 3NF The BEST I can explain: The first normal form is used to eliminate the DUPLICATE INFORMATION.

Discussion

9.	A table on the many side of a one to many or many to many relationship must:(a) Be in Second Normal Form (2NF)(b) Be in Third Normal Form (3NF)(c) Have a single attribute key(d) Have a composite keyI got this question in an online quiz.Question is from Normal Forms topic in chapter Normalization of Database Management
Answer» Correct ANSWER is (d) Have a COMPOSITE key For explanation: The relation in second normal form is ALSO in FIRST normal form and no partial DEPENDENCIES on any column in primary key.

Discussion

10.	Designers use which of the following to tune the performance of systems to support time-critical operations?(a) Denormalization(b) Redundant optimization(c) Optimization(d) RealizationI have been asked this question in an interview for internship.I would like to ask this question from Database Design Process in portion Normalization of Database Management
Answer» CORRECT option is (a) DENORMALIZATION Best EXPLANATION: The process of TAKING a normalized schema and making it nonnormalized is called denormalization.

Discussion

11.	A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.(a) 2NF(b) 3NF(c) BCNF(d) 1NFI had been asked this question in exam.I want to ask this question from Algorithms for Decomposition topic in division Normalization of Database Management
Answer» The correct option is (B) 3NF For explanation: A relation is in 3 NF if an attribute of a COMPOSITE key is DEPENDENT on an attribute of other composite key. (If an attribute of a composite key is dependent on ANATTRIBUTE of other composite key then the relation is not in BCNF, hence it has to bedecomposed.).

Discussion

12.	We can use the following three rules to find logically implied functional dependencies. This collection of rules is called(a) Axioms(b) Armstrong’s axioms(c) Armstrong(d) ClosureThis question was posed to me by my college professor while I was bunking the class.Enquiry is from Functional-Dependency Theory topic in chapter Normalization of Database Management
Answer» The CORRECT OPTION is (b) Armstrong’s axioms The best I can EXPLAIN: By applying these rules REPEATEDLY, we can FIND all of F+, given F.

Discussion

13.	Which forms has a relation that possesses data about an individual entity:(a) 2NF(b) 3NF(c) 4NF(d) 5NFThe question was posed to me in an online quiz.This intriguing question originated from Normal Forms in chapter Normalization of Database Management
Answer» Right CHOICE is (c) 4NF Best EXPLANATION: A Table is in 4NF if and only if, for every ONE of its non-trivial multivalued DEPENDENCIES X \twoheadrightarrow Y, X is a superkey—that is, X is either a candidate key or a superset thereof.

Discussion

14.	If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.(a) A many-to-many relationship set(b) A multivalued attribute of an entity set(c) A one-to-many relationship set(d) Both A many-to-many relationship set and A multivalued attribute of an entity setI have been asked this question in quiz.I need to ask this question from Database Design Process topic in section Normalization of Database Management
Answer» The correct choice is (d) Both A many-to-many relationship SET and A multivalued ATTRIBUTE of an entity set Explanation: For a many-to-many relationship set each RELATED entity set has its own schema and there is an additional schema for the relationship set. For a multivalued attribute, a separate schema is created CONSISTING of that attribute and the primary key of the entity set.

Discussion

15.	Which of the normal form is based on multivalued dependencies?(a) First(b) Second(c) Third(d) FourthThis question was posed to me in homework.The above asked question is from Multivalued Dependencies in section Normalization of Database Management
Answer» Right answer is (d) Fourth For explanation: Multivalued dependencies, do not RULE out the EXISTENCE of certain TUPLES. Instead, they require that other tuples of a certain form be PRESENT in the RELATION.

Discussion

16.	Which of the following is a tuple-generating dependencies?(a) Functional dependency(b) Equality-generating dependencies(c) Multivalued dependencies(d) Non-functional dependencyThe question was asked in a national level competition.My doubt stems from Multivalued Dependencies in chapter Normalization of Database Management
Answer» RIGHT option is (C) Multivalued dependencies The BEST I can explain: Multivalued dependencies, do not rule out the EXISTENCE of certain tuples. INSTEAD, they require that other tuples of a certain form be present in the relation.

Discussion

17.	Also known as schematics, a way of illustrating the layout of an individual webpage is a:(a) Wireframe(b) Sitemap(c) Card sorting(d) BlueprintThis question was addressed to me during an online exam.The doubt is from Application Programs and User Interfaces in portion Normalization of Database Management
Answer» Right option is (a) Wireframe Best explanation: An APPLICATION programming INTERFACE specifies how some software COMPONENTS should INTERACT with each other.

Discussion

18.	Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.(a) Instance(b) Snapshot(c) Both Instance and Snapshot(d) All of the mentionedThe question was asked during an online interview.My question is taken from Database Design Process in portion Normalization of Database Management
Answer» Right option is (b) SNAPSHOT For EXPLANATION: We USE the term snapshot of data to mean the value of the data at a particular POINT in time.

Discussion

19.	What are the desirable properties of a decomposition(a) Partition constraint(b) Dependency preservation(c) Redundancy(d) SecurityI got this question in homework.This interesting question is from Algorithms for Decomposition in section Normalization of Database Management
Answer» CORRECT option is (B) Dependency preservation Explanation: LOSSLESS JOIN and dependency preserving are the two goals of the decomposition.

Discussion

20.	In the __________ normal form, a composite attribute is converted to individual attributes.(a) First(b) Second(c) Third(d) FourthThis question was addressed to me during an interview.My question is taken from Normal Forms topic in chapter Normalization of Database Management
Answer» CORRECT choice is (a) First To EXPLAIN: The first normal FORM is used to eliminate the duplicate information.

Discussion

21.	R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?(a) A->B, B->CD(b) A->B, B->C, C->D(c) AB->C, C->AD(d) A->BCDI have been asked this question in an interview for job.I'm obligated to ask this question of Algorithms for Decomposition in portion Normalization of Database Management
Answer» Correct ANSWER is (d) A->BCD Explanation: This relation GIVES a relation WITHOUT any loss in the values.

Discussion

22.	In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.(a) A many-to-many relationship set(b) A multivalued attribute of an entity set(c) A one-to-many relationship set(d) All of the mentionedThe question was asked in an international level competition.Origin of the question is Database Design Process in section Normalization of Database Management
Answer» Correct option is (b) A multivalued ATTRIBUTE of an entity set For explanation: If a multivalued DEPENDENCY holds and is not implied by the CORRESPONDING FUNCTIONAL dependency, it usually ARISES from this source.

Discussion

23.	Information architecture influences:(a) Answer choice(b) Site structure(c) Labeling(d) Navigation designI have been asked this question by my college professor while I was bunking the class.The origin of the question is Application Programs and User Interfaces topic in section Normalization of Database Management
Answer» Right choice is (b) Site structure Best explanation: The actions in GUI are usually PERFORMED through direct manipulation of the graphical elements.

Discussion

24.	Functional Dependencies are the types of constraints that are based on______(a) Key(b) Key revisited(c) Superset key(d) None of the mentionedThe question was posed to me during an interview.My question is from Normal Forms topic in division Normalization of Database Management
Answer» The correct answer is (a) Key Easiest explanation - Key is the BASIC ELEMENT NEEDED for the CONSTRAINTS.

Discussion

25.	A graphical or text depiction of the relationship between different groups of content on a website is a:(a) Page template(b) Wireframe(c) Site map(d) Cascading style sheet (CSS)This question was posed to me in exam.Query is from Application Programs and User Interfaces in chapter Normalization of Database Management
Answer» Right option is (c) Site map The BEST I can EXPLAIN: In computing, graphical user interface is a type of user interface that ALLOWS users to interact with ELECTRONIC devices.

Discussion

26.	Which of the following occupies boot record of hard and floppy disks and activated during computer startup?(a) Worm(b) Boot sector virus(c) Macro virus(d) VirusI have been asked this question during an online interview.I'd like to ask this question from Application Programs and User Interfaces in chapter Normalization of Database Management
Answer» Right option is (b) Boot SECTOR virus Easy EXPLANATION - A blueprint is a reproduction of a technical drawing, documenting an ARCHITECTURE or an engineering design, USING a contact print PROCESS.

Discussion

27.	Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.(a) A many-to-many relationship set(b) A multivalued attribute of an entity set(c) A one-to-many relationship set(d) All of the mentionedThe question was asked in my homework.This is a very interesting question from Database Design Process topic in chapter Normalization of Database Management
Answer» Correct OPTION is (a) A many-to-many relationship set Easy explanation - If a multivalued DEPENDENCY holds and is not implied by the corresponding FUNCTIONAL dependency, it usually arises from this source.

Discussion

28.	Which forms has a relation that possesses data about an individual entity?(a) 2NF(b) 3NF(c) 4NF(d) 5NFI have been asked this question in a job interview.My question is taken from Multivalued Dependencies topic in division Normalization of Database Management
Answer» Right choice is (c) 4NF Best explanation: A Table is in 4NF if and only if, for every ONE of its non-trivial multivalued DEPENDENCIES X \twoheadrightarrow Y, X is a superkey—that is, X is EITHER a candidate key or a superset THEREOF.

Discussion

29.	A graphical or text depiction of the relationship between different groups of content on a website is referred to as a:(a) Wireframe(b) Blueprint(c) Sitemap(d) Card sortingThe question was posed to me during a job interview.Question is from Application Programs and User Interfaces in section Normalization of Database Management
Answer» The CORRECT answer is (c) Sitemap The best EXPLANATION: An application PROGRAMMING INTERFACE specifies how some software COMPONENTS should interact with each other.

Discussion

30.	A method of modelling and describing user tasks for an interactive application is referred to as:(a) Customer journey(b) Primary persona(c) Use case(d) Web design personaI had been asked this question in final exam.I'd like to ask this question from Application Programs and User Interfaces topic in section Normalization of Database Management
Answer» Correct option is (c) Use case Explanation: The actions in GUI are usually PERFORMED through DIRECT manipulation of the GRAPHICAL ELEMENTS.

Discussion

31.	Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by(a) Unique-role assumption(b) Unique-key assignment(c) Role intergral assignment(d) None of the mentionedI have been asked this question in an internship interview.This interesting question is from Database Design Process topic in division Normalization of Database Management
Answer» Correct ANSWER is (a) Unique-role ASSUMPTION To explain: A desirable feature of a database DESIGN is the unique-role assumption, which means that each ATTRIBUTE NAME has a unique meaning in the database.

Discussion

32.	Which normal form is considered adequate for normal relational database design?(a) 2NF(b) 5NF(c) 4NF(d) 3NFI have been asked this question in an online interview.My enquiry is from Algorithms for Decomposition topic in portion Normalization of Database Management
Answer» Correct ANSWER is (d) 3NF Explanation: A relational DATABASE table is often described as “normalized” if it is in the THIRD Normal Form because most of the 3NF tables are free of insertion, update, and deletion anomalies.

Discussion

33.	Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in(a) Fourth NF(b) BCNF(c) Third NF(d) Second NFI have been asked this question during an interview.The origin of the question is Database Design Process in chapter Normalization of Database Management
Answer» CORRECT ANSWER is (b) BCNF The best I can EXPLAIN: BCNF has only ONE normal form.

Discussion

34.	The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is(a) BCNF algorithm(b) 2NF algorithm(c) 3NF synthesis algorithm(d) 1NF algorithmI got this question by my school principal while I was bunking the class.I'd like to ask this question from Algorithms for Decomposition topic in division Normalization of Database Management
Answer» Right answer is (C) 3NF synthesis algorithm The BEST I can explain: The result is not UNIQUELY defined, SINCE a set of functional dependencies can have more than one canonical cover, and, further, in some cases, the result of the algorithm depends on the order in which it considers the dependencies in Fc.

Discussion

35.	In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.(a) A many-to-many relationship set(b) A multivalued attribute of an entity set(c) A one-to-many relationship set(d) None of the mentionedThis question was posed to me in an online interview.This is a very interesting question from Multivalued Dependencies in portion Normalization of Database Management
Answer» The correct choice is (B) A MULTIVALUED attribute of an entity set Best explanation: If a multivalued dependency holds and is not IMPLIED by the CORRESPONDING functional dependency, it usually arises from this source.

Discussion

36.	Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?(a) A many-to-many relationship set(b) A multivalued attribute of an entity set(c) A one-to-many relationship set(d) None of the mentionedThis question was addressed to me by my school teacher while I was bunking the class.This interesting question is from Multivalued Dependencies topic in division Normalization of Database Management
Answer» Correct choice is (a) A many-to-many relationship set For EXPLANATION: If a MULTIVALUED dependency holds and is not implied by the corresponding functional dependency, it USUALLY arises from this SOURCE.

Discussion

37.	If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.(a) A many-to-many relationship set(b) A multivalued attribute of an entity set(c) A one-to-many relationship set(d) Both A many-to-many relationship set and A multivalued attribute of an entity setThis question was posed to me in an internship interview.Query is from Multivalued Dependencies in division Normalization of Database Management
Answer» Right option is (d) Both A many-to-many relationship SET and A multivalued ATTRIBUTE of an entity set For explanation: For a many-to-many relationship set each RELATED entity set has its own schema and there is an additional schema for the relationship set. For a multivalued attribute, a separate schema is created consisting of that attribute and the primary key of the entity set.

Discussion

38.	The normal form which satisfies multivalued dependencies and which is in BCNF is(a) 4 NF(b) 3 NF(c) 2 NF(d) All of the mentionedI have been asked this question in final exam.This intriguing question comes from Multivalued Dependencies in portion Normalization of Database Management
Answer» Correct ANSWER is (a) 4 NF Easy EXPLANATION - FOURTH NORMAL form is more restrictive than BCNF.

Discussion

39.	An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:(a) Web usability(b) Persuasion(c) Web accessibility(d) None of the mentionedThe question was asked in an interview for job.I would like to ask this question from Application Programs and User Interfaces topic in portion Normalization of Database Management
Answer» CORRECT option is (B) Persuasion The explanation is: In computing, graphical user interface is a type of user interface that allows USERS to INTERACT with electronic devices.

Discussion

40.	The main task carried out in the __________ is to remove repeating attributes to separate tables.(a) First Normal Form(b) Second Normal Form(c) Third Normal Form(d) Fourth Normal FormI have been asked this question in an international level competition.The query is from Multivalued Dependencies topic in portion Normalization of Database Management
Answer» Correct ANSWER is (a) First Normal FORM The BEST I can explain: Multivalued dependencies, do not RULE out the existence of certain tuples. Instead, they REQUIRE that other tuples of a certain form be present in the relation.

Discussion

41.	Tables in second normal form (2NF):(a) Eliminate all hidden dependencies(b) Eliminate the possibility of a insertion anomalies(c) Have a composite key(d) Have all non key fields depend on the whole primary keyThe question was asked in an online quiz.My question comes from Normal Forms in chapter Normalization of Database Management
Answer» Correct option is (a) Eliminate all hidden dependencies For EXPLANATION: The relation in second NORMAL form is ALSO in first normal form and no PARTIAL dependencies on any column in primary key.

Discussion

42.	Which of the following is not Armstrong’s Axiom?(a) Reflexivity rule(b) Transitivity rule(c) Pseudotransitivity rule(d) Augmentation ruleI had been asked this question by my school principal while I was bunking the class.Asked question is from Functional-Dependency Theory topic in chapter Normalization of Database Management
Answer» The correct choice is (c) Pseudotransitivity rule The BEST explanation: It is POSSIBLE to USE Armstrong’s axioms to prove that Pseudotransitivity rule is SOUND.

Discussion

43.	Fifth Normal form is concerned with(a) Functional dependency(b) Multivalued dependency(c) Join dependency(d) Domain-keyI have been asked this question in my homework.Enquiry is from Multivalued Dependencies topic in portion Normalization of Database Management
Answer» Right ANSWER is (C) Join DEPENDENCY To explain: If a multivalued dependency holds and is not implied by the CORRESPONDING functional dependency, it usually ARISES from this source.

Discussion

44.	Which-one ofthe following statements about normal forms is FALSE?(a) BCNF is stricter than 3 NF(b) Lossless, dependency -preserving decomposition into 3 NF is always possible(c) Loss less, dependency – preserving decomposition into BCNF is always possible(d) Any relation with two attributes is BCNFThe question was asked during an interview.My question comes from Normal Forms in division Normalization of Database Management
Answer» Right answer is (c) Loss less, dependency – preserving DECOMPOSITION into BCNF is always possible Easiest explanation - We SAY that the decomposition is a lossless decomposition if there is no loss of INFORMATION by replacing R (R) with two RELATION schemas r1(R1) andr2(R2).

Discussion

Explore topic-wise InterviewSolutions in .

Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:(a) 1NF(b) 2NF(c) 3NF(d) All of the mentionedThis question was posed to me in an online quiz.I need to ask this question from Normal Forms in portion Normalization of Database Management

Which forms has a relation that possesses data about an individual entity:(a) 2NF(b) 3NF(c) 4NF(d) 5NFThe question was posed to me in an online quiz.This intriguing question originated from Normal Forms in chapter Normalization of Database Management

Which of the normal form is based on multivalued dependencies?(a) First(b) Second(c) Third(d) FourthThis question was posed to me in homework.The above asked question is from Multivalued Dependencies in section Normalization of Database Management

What are the desirable properties of a decomposition(a) Partition constraint(b) Dependency preservation(c) Redundancy(d) SecurityI got this question in homework.This interesting question is from Algorithms for Decomposition in section Normalization of Database Management

In the __________ normal form, a composite attribute is converted to individual attributes.(a) First(b) Second(c) Third(d) FourthThis question was addressed to me during an interview.My question is taken from Normal Forms topic in chapter Normalization of Database Management

Functional Dependencies are the types of constraints that are based on______(a) Key(b) Key revisited(c) Superset key(d) None of the mentionedThe question was posed to me during an interview.My question is from Normal Forms topic in division Normalization of Database Management

Which forms has a relation that possesses data about an individual entity?(a) 2NF(b) 3NF(c) 4NF(d) 5NFI have been asked this question in a job interview.My question is taken from Multivalued Dependencies topic in division Normalization of Database Management

Which normal form is considered adequate for normal relational database design?(a) 2NF(b) 5NF(c) 4NF(d) 3NFI have been asked this question in an online interview.My enquiry is from Algorithms for Decomposition topic in portion Normalization of Database Management

The normal form which satisfies multivalued dependencies and which is in BCNF is(a) 4 NF(b) 3 NF(c) 2 NF(d) All of the mentionedI have been asked this question in final exam.This intriguing question comes from Multivalued Dependencies in portion Normalization of Database Management

Fifth Normal form is concerned with(a) Functional dependency(b) Multivalued dependency(c) Join dependency(d) Domain-keyI have been asked this question in my homework.Enquiry is from Multivalued Dependencies topic in portion Normalization of Database Management