Related InterviewSolutions

• 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
• 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
• 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
• 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
• _____________ 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
• 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
• 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
• 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
• 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
• 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