Free Test Relational Calculus – Databas...

Q1: Relational Calculus is a?

A. Declarative query language B. Procedural query language C. Data definition language D. Data manipulation language

Q2: Which of the following is a type of relational calculus?

A. Tuple Relational Calculus B. Relational Algebra C. SQl D. ER Model

Q3: Domain Relational Calculus is?

A. Based on domain variables B. Based on tuples C. Based on relations D. Based on schemas

Q4: Tuple Relational Calculus uses?

A. Tuple variables B. Domain variables C. Attributes D. Tables

Q5: Which of the following relational calculus expressions is valid?

A. {t | t ∈ R AND t.age > 25} B. {R | t.age > 25} C. {t | age > 25} D. {t.age | t ∈ R}

Q6: In relational calculus, the expression {t | P(t)} means?

A. The set of all tuples t that satisfy predicate P B. The set of all attributes C. The set of all tables D. The set of all databases

Q7: Which relational calculus variant uses variables that range over attribute values?

A. Domain Relational Calculus B. Tuple Relational Calculus C. Relational Algebra D. SQL

Q8: Relational calculus is equivalent in power to?

A. Relational algebra B. Procedural programming C. NoSQL D. XML

Q9: Which relational calculus concept ensures safety of queries?

A. Safety condition B. Uniqueness condition C. Consistency condition D. Isolation condition

Q10: Relational calculus is?

A. Non-procedural B. Procedural C. Physical storage D. Schema design

Q11: Which symbol denotes logical AND in relational calculus?

A. ∧ B. ∨ C. ¬ D. ⇒

Q12: Which symbol denotes logical OR?

A. ∨ B. ∧ C. ¬ D. ⇒

Q13: Which symbol denotes negation?

A. ¬ B. ∧ C. ∨ D. ⇒

Q14: Which symbol denotes implication?

A. ⇒ B. ∧ C. ∨ D. ¬

Q15: In tuple relational calculus, variables range over?

A. Tuples B. Attributes C. Doman values D. Tables

Q16: Domain relational calculus variables range over?

A. Attribute domains B. Tuples C. Relations D. Tables

Q17: Relational calculus queries are typically expressed in?

A. Set notation B. Procedural steps C. SQL only D. ER diagrams

Q18: What is a safe query in relational calculus?

A. One that returns finite results B. One that returns infinite results C. One that returns no results D. One that returns all tuples

Q19: Which relational calculus form is closer to first-order predicate logic?

A. Tuple Relational Calculus B. Domain Relational Calculus C. Relational Algebra D. SQL

Quiz for Relational Calculus