Given the basic ER and relational models, which of the following is INCORRECT?(a) An attribute of an entity can have more than one value(b) An attribute of an entity can be composite(c) In a row of a relational table, an attribute can have more than one value(d) In a row of a relational table, an attribute can have exactly one value or a NULL valueThe question was asked in an interview for job.The question is from Entity-Relationship Design Issues topic in division Database Systems Design and Implementation of Database Management

Given the basic ER and relational models, which of the following is IN

1.	Given the basic ER and relational models, which of the following is INCORRECT?(a) An attribute of an entity can have more than one value(b) An attribute of an entity can be composite(c) In a row of a relational table, an attribute can have more than one value(d) In a row of a relational table, an attribute can have exactly one value or a NULL valueThe question was asked in an interview for job.The question is from Entity-Relationship Design Issues topic in division Database Systems Design and Implementation of Database Management
Answer» CORRECT ANSWER is (C) In a row of a relational table, an attribute can have more than one value Easiest EXPLANATION - It is possible to have several values for a single attribute provide it is a multi-valued attribute.

Discussion

No Comment Found

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

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment