An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.(a) Candidate(b) Primary(c) Super(d) SubI had been asked this question during an interview for a job.I would like to ask this question from Keys in section The Relational Model of Database Management

An attribute in a relation is a foreign key if the _______ key from on

1.	An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.(a) Candidate(b) Primary(c) Super(d) SubI had been asked this question during an interview for a job.I would like to ask this question from Keys in section The Relational Model of Database Management
Answer» The correct choice is (b) PRIMARY The best I can EXPLAIN: The primary key has to be referred in the other relation to FORM a FOREIGN key in that relation.

Discussion

No Comment Found

Related InterviewSolutions

A relational database consists of a collection of(a) Tables(b) Fields(c) Records(d) KeysThis question was posed to me in a job interview.Question is from Relational Database and Database Schema topic in division The Relational Model of Database Management
The most commonly used operation in relational algebra for projecting a set of tuple from a relation is(a) Join(b) Projection(c) Select(d) UnionThe question was asked in an interview for internship.My query is from Relational Query Operations and Relational Operators topic in section The Relational Model of Database Management
A ________ in a table represents a relationship among a set of values.(a) Column(b) Key(c) Row(d) EntryI have been asked this question in an online quiz.Question is taken from Relational Database and Database Schema topic in division The Relational Model of Database Management
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________(a) Referential relation(b) Referencing relation(c) Referenced relation(d) Referred relationThe question was posed to me in class test.Asked question is from Keys in division The Relational Model of Database Management
The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.(a) Join(b) Cartesian product(c) Intersection(d) Set differenceThis question was posed to me in final exam.I'd like to ask this question from Relational Query Operations and Relational Operators in chapter The Relational Model of Database Management
Using which language can a user request information from a database?(a) Query(b) Relational(c) Structural(d) CompilerI have been asked this question during an interview.Asked question is from Relational Query Operations and Relational Operators topic in division The Relational Model of Database Management
The term _______ is used to refer to a row.(a) Attribute(b) Tuple(c) Field(d) InstanceI got this question during an online interview.The above asked question is from Relational Database and Database Schema in chapter The Relational Model of Database Management
Which one of the following attribute can be taken as a primary key?(a) Name(b) Street(c) Id(d) DepartmentI have been asked this question during an interview.I would like to ask this question from Keys in chapter The Relational Model of Database Management
The term attribute refers to a ___________ of a table.(a) Record(b) Column(c) Tuple(d) KeyI had been asked this question at a job interview.Question is taken from Relational Database and Database Schema in division The Relational Model of Database Management
The _______operation performs a set union of two “similarly structured” tables(a) Union(b) Join(c) Product(d) IntersectI got this question in an interview.Asked question is from Relational Query Operations and Relational Operators topic in division The Relational Model of Database Management

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment