Related InterviewSolutions

• Functional dependencies are a generalization of(a) Key dependencies(b) Relation dependencies(c) Database dependencies(d) None of the mentionedThis question was addressed to me during an online exam.Asked question is from Extended E-R Features in section Database Systems Design and Implementation of Database Management
• There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called(a) Commonality(b) Specialization(c) Generalization(d) SimilarityThis question was posed to me in an international level competition.I'd like to ask this question from Extended E-R Features in chapter Database Systems Design and Implementation of Database Management
• Which of the following can be used as a primary key entry of the instructor relation.(a) DEPT_NAME(b) NAME(c) ID(d) All of the mentionedI had been asked this question in semester exam.This is a very interesting question from Querying database part-1 DDL in section Database Systems Design and Implementation of Database Management
• Identify the error in the section relation(a) No error(b) Year numeric (4,0)(c) Building varchar (15)(d) Sec_id varchar (8)I got this question in semester exam.This question is from Querying database part-1 DDL topic in portion Database Systems Design and Implementation of Database Management
• If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has(a) Hierarchy(b) Multilevel inheritance(c) Single inheritance(d) Multiple inheritanceThe question was asked in unit test.Question is taken from Extended E-R Features in section Database Systems Design and Implementation of Database Management
• A _____________ constraint requires that an entity belong to no more than one lower-level entity set.(a) Disjointness(b) Uniqueness(c) Special(d) RelationalI got this question in a job interview.This intriguing question originated from Extended E-R Features topic in chapter Database Systems Design and Implementation of Database Management
• The refinement from an initial entity set into successive levels of entity subgroupings represents a ________ design process in which distinctions are made explicit.(a) Hierarchy(b) Bottom-up(c) Top-down(d) RadicalI got this question in an interview for internship.My question comes from Extended E-R Features topic in portion Database Systems Design and Implementation of Database Management
• Which of the following command is used to display the departments of the instructor relation?(a) Select * from instructor where Dept_name = Finance;(b) Select * from instructor ;(c) Select dept_name from instructor;(d) Select dept_name for instructor where Name=Jackson;This question was posed to me in homework.The above asked question is from Querying database part-2 DML in chapter Database Systems Design and Implementation of Database Management
• Which relationship is used to represent a specialization entity?(a) ISA(b) AIS(c) ONIS(d) WHOISI got this question in unit test.I need to ask this question from Extended E-R Features in section Database Systems Design and Implementation of Database Management
• If an attribute of a composite key is dependent on an attribute of the other composite key, a normalizationcalled _____ is needed.(a) DKNF(b) BCNF(c) Fourth(d) ThirdThe question was asked in class test.The question is from Atomic Domains in chapter Database Systems Design and Implementation of Database Management