Home > Computer Engineering > Quizzes > Database Management Systems: Structured Query Language (SQL)
Database Management Systems: Structured Query Language (SQL)
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 11% Most missed: “The ___________ operation, denoted by −, allows us to find tuples that are in on…”
Database Management Systems: Structured Query Language (SQL)
Time left 00:00
25 Questions

1. For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.
2. The select operation'
3. Statement 1: A tuple is a row in a relation - nbsp;   Statement 2: Existence of multiple foreign keys in a same relation is possible
4. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
5. What is a foreign key?
6. If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.
7. Which of the following is used to denote the selection operation in relational algebra?
8. Here the course_id,sec_id and semester are __________ and course is a _________
9. What does the following relational algebra expression do? - amount > 1200 (loan)
10. The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.
11. Which of the following is not outer join?
12. Which is a unary operation:
13. An attribute is a __________ in a relation.
14. The term _______ is used to refer to a row.
15. Which of the following is the syntax for views where v is view name?
16. A domain is atomic if elements of the domain are considered to be ____________ units.
17. The term attribute refers to a ___________ of a table.
18. What does the 'x'
19. Which of the following is not a relational algebra function?
20. There exists a division operator in Relational Algebra
21. Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
22. Which of the following is a fundamental operation in relational algebra?
23. What is the method of specifying a primary key in a schema description?
24. Which is a join condition contains an equality operator:
25. In precedence of set operators, the expression is evaluated from