Home > Computer Engineering > Quizzes > Database Management Systems: Introduction to Database Concepts
Database Management Systems: Introduction to Database Concepts
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 13% Most missed: “The tuples of the relations can be of ________ order.”
Database Management Systems: Introduction to Database Concepts
Time left 00:00
19 Questions

1. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
2. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
3. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
4. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
5. The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
6. 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.
7. The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
8. The term _______ is used to refer to a row.
9. Using which language can a user request information from a database?

10. The _________ provides a set of operations that take one or more relations as input and return a relation as an output.
11. 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.
12. The tuples of the relations can be of ________ order.
13. A relational database consists of a collection of
14. Student(ID, name, dept name, tot_cred) - In this query which attributes form the primary key?
15. Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
16. Using which language can a user request information from a database?

17. Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
18. The term attribute refers to a ___________ of a table.
19. A ________ in a table represents a relationship among a set of values.