SQL -Structured Query Language - Sql Select - Select Record Quiz
| # | Quiz |
|---|---|
|
1
Discuss
|
Select Record
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Solution |
|
10
Discuss
|
Select Record
Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Solution |
|
11
Discuss
|
Select Record
A domain is atomic if elements of the domain are considered to be ____________ units.
Solution |
|
12
Discuss
|
Select Record
The tuples of the relations can be of ________ order.
Solution |
|
13
Discuss
|
Select Record
The _________ provides a set of operations that take one or more relations as input and return a relation as an output.
Solution |
|
14
Discuss
|
Select Record
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.
Solution |
|
15
Discuss
|
Select Record
The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
Solution |
|
16
Discuss
|
Select Record
The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
Solution |
|
17
Discuss
|
Select Record
The _______operation performs a set union of two “similarly structured” tables
Solution |
|
18
Discuss
|
Select Record
The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Solution |
| # | Quiz |
