Structured Query Language or SQL, is a ............... that allows a high-level expression of queries.
Anonymous Quiz
18%
theoretical language
82%
practical language
...............is a useful theoretical language that serves to define more complex languages.
Anonymous Quiz
27%
Structured Query Language
73%
Relational algebra
The sequence of operations in a relation algebra is called relational algebra expression.
Anonymous Quiz
96%
T
4%
F
CARTESIAN PRODUCT ( x )
Anonymous Quiz
7%
Unary Relational Operations
31%
Binary Relational Operations
62%
Relational Algebra Operations
The relation resulting from the SELECT operation has the ........ attributes as R.
Anonymous Quiz
88%
Same
12%
different
The SELECT operator is unary; that is, it is applied to a single relation.
Anonymous Quiz
94%
T
6%
F
The number of tuples in the resulting relation is always............. to the number of tuples in R
Anonymous Quiz
91%
less than or equal
9%
more than or equal
The ............... operation, selects certain columns from the table and discards the other
columns.
columns.
Anonymous Quiz
80%
PROJECT
17%
SELECT
3%
RENAME
the result of the PROJECT operation can be visualized as a vertical partition of the relation into two relations
Anonymous Quiz
91%
T
9%
F
The general form of the PROJECT operation is
Anonymous Quiz
93%
π<attribute list>(R)
7%
(R)<attribute list>π
The result of the PROJECT operation has only the attributes specified in <attribute list> in the same orde they appear in the list.
Anonymous Quiz
86%
T
14%
F
PROJECT degree ........... the number of attributes in < attribute list >.
Anonymous Quiz
78%
=
7%
>
15%
<