Using SQL Language: 3 a) suppose that we have 2 relations, the first one has 8 rows and 6 columns and the second one has
Posted: Sat May 14, 2022 8:32 pm
Using SQL Language:
3
a)
suppose that we have 2 relations, the first one has 8 rows and 6
columns and the second one has 5 rows and 4 columns. What would be
the degree of the resulted table when we carry out a cartesian
product between these two tables?
10
40
24
13
b)
Which of the following is used to denote the projection
operation in relational algebra?
Pi
Sigma
Lambda
Omega
C)
True, false and ________ are three value could be assigned to a
Boolean variable.
1
Null
Unknown
0
D)
A table is not in ____________ if an attribute of a composite
key is dependent on an attribute of another composite key.
2NF
3NF
BCNF
1NF
e)
Triggers are supported in
Delete, update, insert
Conditions
Views
None of the above
3
a)
suppose that we have 2 relations, the first one has 8 rows and 6
columns and the second one has 5 rows and 4 columns. What would be
the degree of the resulted table when we carry out a cartesian
product between these two tables?
10
40
24
13
b)
Which of the following is used to denote the projection
operation in relational algebra?
Pi
Sigma
Lambda
Omega
C)
True, false and ________ are three value could be assigned to a
Boolean variable.
1
Null
Unknown
0
D)
A table is not in ____________ if an attribute of a composite
key is dependent on an attribute of another composite key.
2NF
3NF
BCNF
1NF
e)
Triggers are supported in
Delete, update, insert
Conditions
Views
None of the above