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

The query which selects the Course_id ‘CS-101’ from the section re

1.	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.

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