Author: Anonymous

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?

What is data granularity of a DB?

SQL would never allow you to execute a join on a table with itself.

The order of a B-Tree is: