Answer Happy

Using SQL Language
1
a)
Union compatibility is met among relations when they
have the same number of attributes and the same domain
have the same number of attributes
have the same table degree
have compatible domains
b)
What is the before trigger
Trigger runs before a particular operation
Trigger runs before an insert, update or delete on a table
trigger runs after an insert, views, update or delete on a
table
None of the above
c)
What would happen when we update a value in a view
Will not change the view
Will not change the table from which it is defined
Will change the table from which it is defined
None of the above
d)
Which of the following is a fundamental operation in relational
algebra?
Set intersection
Cartesian product
Outer join
Division
e)
Tables in second normal form (2NF):
Eliminate all dependencies
Eliminate update anomalies
Have a composite key
No partial dependencies on any column in primary key