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