Tree-based indexes are best for looking up values based on the range tests because they keep references to data in sorted order.

 First normal form requires that all domain values in a relation are atomic.

Non-relational DB is characterized by (select ALL that apply):

What normal form the following table is in? 

A tuple in formal terms is like a row in informal terms.

Which of the following is not a possible meaning of the SQL marker NULL?

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?

In respect to Transaction ACID properties, Atomic property stands for the fact that  

INSERT SQL statement can be used to do the following:

As discussed in this class, the JDBC automatically closes connection when not used by the application