InterviewSolution

Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

51.	Entity is a _________(a) Object of relation(b) Present working model(c) Thing in real world(d) Model of relationThis question was addressed to me by my college director while I was bunking the class.Question is taken from The Entity-Relationship Model topic in chapter Database Systems Design and Implementation of Database Management
Answer» RIGHT answer is (c) THING in REAL world Best EXPLANATION: For EXAMPLE, each person in a university is an entity.

52.	An ________is a set of entities of the same type that share the same properties, or attributes.(a) Entity set(b) Attribute set(c) Relation set(d) Entity modelThis question was posed to me in an internship interview.My question is based upon The Entity-Relationship Model topic in chapter Database Systems Design and Implementation of Database Management
Answer» Correct option is (a) ENTITY set For explanation: An entity is a “THING” or “object” in the real world that is DISTINGUISHABLE from all other OBJECTS.

53.	What is a relationship called when it is maintained between two entities?(a) Unary(b) Binary(c) Ternary(d) QuaternaryThe question was posed to me in an interview for internship.I'm obligated to ask this question of Entity-Relationship Design Issues topic in division Database Systems Design and Implementation of Database Management
Answer» Right OPTION is (b) Binary To explain: Binary WORD USUALLY represents two ATTRIBUTES.

54.	If you were collecting and storing information about your music collection, an album would be considered a(n) _____(a) Relation(b) Entity(c) Instance(d) AttributeThis question was posed to me in examination.This is a very interesting question from Entity-Relationship Diagrams in chapter Database Systems Design and Implementation of Database Management
Answer» RIGHT option is (b) Entity The best EXPLANATION: An entity set is a logical container for INSTANCES of an entity type and instances of any type DERIVED from that entity type.

55.	______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.(a) Entity Integrity Constraints(b) Referential Integrity Constraints(c) Domain Integrity Constraints(d) Domain ConstraintsThe question was posed to me in exam.My doubt is from Constraints topic in section Database Systems Design and Implementation of Database Management
Answer» The correct CHOICE is (b) Referential INTEGRITY Constraints Easiest EXPLANATION - NONE.

56.	In the above teaches relation ” Select * from teaches where Year = ‘2010’” displays how many rows?(a) 2(b) 4(c) 5(d) 1I have been asked this question during an internship interview.I want to ask this question from Reduction to Relational Schemas in division Database Systems Design and Implementation of Database Management
Answer» RIGHT choice is (a) 2 Explanation: There are TWO TUPLES with the YEAR is 2009.

57.	In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.(a) Desciptive(b) Derived(c) Recursive(d) RelativeThis question was addressed to me in my homework.I'd like to ask this question from The Entity-Relationship Model in division Database Systems Design and Implementation of Database Management
Answer» The correct option is (a) Desciptive The explanation is: Consider the ENTITY sets STUDENT and section, which participate in a relationship set takes. We MAY wish to store a DESCRIPTIVE ATTRIBUTE grade with the relationship to record the grade that a student got in the class.

58.	How can the values in the relation teaches be deleted?(a) Drop table teaches;(b) Delete from teaches;(c) Purge table teaches;(d) Delete from teaches where Id =’Null’;This question was posed to me during a job interview.Question is from Reduction to Relational Schemas topic in division Database Systems Design and Implementation of Database Management
Answer» The CORRECT choice is (B) Delete from teaches; The explanation is: Delete table cleans the entry from the table.

59.	Key to represent relationship between tables is called(a) Primary key(b) Secondary Key(c) Foreign Key(d) None of the mentionedThe question was asked in an international level competition.This interesting question is from Entity-Relationship Design Issues in division Database Systems Design and Implementation of Database Management
Answer» Correct CHOICE is (c) FOREIGN Key The best EXPLANATION: Primary key of one relation USED as an attribute in another relation is called foreign key.

60.	The relation with primary key can be created using(a) Create table instructor (Id, Name)(b) Create table instructor (Id, Name, primary key(name))(c) Create table instructor (Id, Name, primary key (Id))(d) Create table instructor ( Id unique, Name )The question was posed to me in class test.My question is based upon Reduction to Relational Schemas topic in section Database Systems Design and Implementation of Database Management
Answer» CORRECT answer is (c) Create table instructor (ID, NAME, primary key (Id)) The explanation is: The value Name cannot be a primary key.

61.	_____________ express the number of entities to which another entity can be associated via a relationship set.(a) Mapping Cardinality(b) Relational Cardinality(c) Participation Constraints(d) None of the mentionedI have been asked this question during an interview.I'm obligated to ask this question of Constraints topic in portion Database Systems Design and Implementation of Database Management
Answer» The correct option is (a) MAPPING Cardinality Best EXPLANATION: Mapping cardinality is ALSO called as cardinality ratio.

62.	The query which selects the Course_id ‘CS-101’ from the section relation is(a) Select Course_id from section where Building = ‘Richard’;(b) Select Course_id from section where Year = ‘2009’;(c) Select Course_id from teaches where Building = ‘Packyard’;(d) Select Course_id from section where Sec_id = ‘3’;This question was posed to me by my school teacher while I was bunking the class.This interesting question is from Reduction to Relational Schemas in division Database Systems Design and Implementation of Database Management
Answer» RIGHT CHOICE is (b) Select Course_id from section where Year = ‘2009’; The best I can explain: The year ‘2009’ should be selected from the section relation.

63.	Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality(a) One to many(b) One to one(c) Many to many(d) Many to oneI have been asked this question in an online interview.My question comes from Entity-Relationship Diagrams topic in portion Database Systems Design and Implementation of Database Management
Answer» Correct ANSWER is (b) One to one Easy explanation - This indicates that an instructor MAY ADVISE at most one student, and a student may have at most one ADVISOR.

64.	An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as(a) One-to-many(b) One-to-one(c) Many-to-many(d) Many-to-oneThis question was addressed to me by my college professor while I was bunking the class.Enquiry is from Constraints in portion Database Systems Design and Implementation of Database Management
Answer» Correct choice is (b) ONE-to-one The EXPLANATION is: Here one entity in one SET is RELATED to one one entity in other set.

65.	Which of the following gives a logical structure of the database graphically?(a) Entity-relationship diagram(b) Entity diagram(c) Database diagram(d) Architectural representationI have been asked this question during a job interview.Enquiry is from Entity-Relationship Diagrams topic in section Database Systems Design and Implementation of Database Management
Answer» Right choice is (a) Entity-relationship diagram The best explanation: E-R DIAGRAMS are SIMPLE and clear—qualities that may WELL account in LARGE part for the widespread use of the E-R model.

66.	An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.(a) One-to-many(b) One-to-one(c) Many-to-many(d) Many-to-oneThe question was posed to me in a job interview.The doubt is from Constraints topic in division Database Systems Design and Implementation of Database Management
Answer» Correct CHOICE is (d) Many-to-ONE Explanation: Here more than one ENTITY in one SET is RELATED to one one entity in other set.

67.	Not applicable condition can be represented in relation entry as(a) NA(b) 0(c) NULL(d) Blank SpaceI have been asked this question in a job interview.Asked question is from The Entity-Relationship Model in division Database Systems Design and Implementation of Database Management
Answer» Right option is (c) NULL The best explanation: NULL ALWAYS REPRESENTS that the VALUE is not present.