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

## 0 Comments