Related InterviewSolutions

• Which is a unary operation:(a) Selection operation(b) Primitive operation(c) Projection operation(d) Generalized selectionThis question was posed to me by my school principal while I was bunking the class.Question is taken from Relational Algebra topic in section Relational Algebra of Database Management
• The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.(a) Union(b) Set-difference(c) Difference(d) IntersectionThis question was addressed to me in an online interview.Asked question is from Relational Algebra in division Relational Algebra of Database Management
• Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.(a) Relational(b) Structural(c) Procedural(d) FundamentalI got this question in final exam.Question is from Relational Algebra topic in division Relational Algebra of Database Management
• For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.(a) Predicates, relation(b) Relation, Predicates(c) Operation, Predicates(d) Relation, OperationThe question was asked in an interview for internship.My query is from Relational Algebra in chapter Relational Algebra of Database Management
• Which is a join condition contains an equality operator:(a) Equijoins(b) Cartesian(c) Natural(d) LeftThe question was asked during an internship interview.This is a very interesting question from Relational Algebra in division Relational Algebra of Database Management
• A query in the tuple relational calculus is expressed as:(a) {t | P() | t}(b) {P(t) | t }(c) {t | P(t)}(d) All of the mentionedThe question was posed to me in final exam.The question is from Tuple Relational Calculus and Domain Relational Calculus topic in section Relational Algebra of Database Management
• Which of the following is a fundamental operation in relational algebra?(a) Set intersection(b) Natural join(c) Assignment(d) None of the mentionedI had been asked this question in an online quiz.This intriguing question comes from Relational Algebra topic in portion Relational Algebra of Database Management
• Which of the following is not outer join?(a) Left outer join(b) Right outer join(c) Full outer join(d) All of the mentionedThis question was addressed to me in examination.I'd like to ask this question from Relational Algebra topic in section Relational Algebra of Database Management
• Which of the following symbol is used in the place of except?(a) ^(b) V(c) ¬(d) ~This question was addressed to me in semester exam.My doubt is from Tuple Relational Calculus and Domain Relational Calculus in division Relational Algebra of Database Management
• Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000 .(a) {t | t ε instructor ∧ t[salary] > 80000}(b) Э t ∈ r (Q(t))(c) {t | Э s ε instructor (t[ID] = s[ID]∧ s[salary] > 80000)}(d) None of the mentionedThis question was posed to me in a job interview.The question is from Tuple Relational Calculus and Domain Relational Calculus in division Relational Algebra of Database Management