Author: Anonymous

For two union compatible sets R and S, the relational algebra expression R-S will always produce the same results as S-R regardless of the data contained in R and in S.

The ALTER SQL statement can do the following except:

Compared to an INNER JOIN, an OUTER JOIN may

CHECK ALL THAT APPLY : Suppose we have a table constraint, in an SQL Create Table statement for Orders, such as Foreign Key Snumb References Supplier (Snumb) On Delete Cascade. If we execute Delete from Supplier where Snumb = 100, then  …    

Using the relational schema given, suppose that S1 is a foreign key referring to A1. Which of the following statements must be true?      R1                                                                                    R2  

Which of the following is NOT TRUE about a log file used by a DBMS for transaction management:

What normal form the following table is in? 

Given the following schema, Pet (petId: integer, petType: string, petName: string) Cat (petId: integer (FK), furColor: string) Dog (petId: integer (FK), furColor: string) Bird (petId: integer (FK), canFly: boolean)   Which expression can be used to create a list of animals that are either a cat or a dog?

Two operations in a schedule may present a conflict when:

Given the following schema, Pet (petId: integer, petType: string, petName: String, favoriteFood: String) Cat (petId: integer (FK), furColor: string) Dog (petId: integer (FK), furColor: string) Bird (petId: integer (FK), canFly: boolean)   Which relational algebra expression is going to produce a list of distinct bird names for the birds who can fly?