Database Questions and Answers – Relational Query Operations and Relational Operators mcq

1. Which language can be used by user to request information from a database?

  • Relational
  • Query
  • Compiler
  • Structural

2. Student(ID, name, dept name, tot_cred)
In this query which attributes form the primary key?

  • ID
  • Tot_cred
  • Dept
  • Name

3. Which  of the following is a procedural language?
  • Tuple relational calculus
  • Relational algebra
  • Domain relational calculus
  • Query language

4. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
  • Join
  • Select
  • Intersection
  • Union

5. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
  • Cartesian product
  • Intersection
  • Set difference
  • Join

6. The _______operation performs a set union of two “similarly structured” tables
  • Union
  • Product
  • Join
  • Intersect

7. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is?
  • Select
  • Projection
  • Join
  • Union

8. The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
  • Intersect
  • Projection
  • Difference
  • Union

9. A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
  • Relational algebra
  • Schema diagram
  • Schema flow
  • Database diagram

10. The _________ provides a set of operations that take one or more relations as input and return a relation as an output.
  • Relational algebra
  • Schematic representation
  • Scheme diagram
  • Relation flow




























Post a comment

0 Comments