The functions of a DBMS are:

Consider the following schema: Employees (Empcode, Name, Sex, Salary, Dept) If this query is executed, what is it going to display? SELECT Dept FROM Employees WHERE Sex = ‘M’ GROUP by Dept HAVING AVG (Salary) > (SELECT AVG (Salary) FROM Employees)

What will this SQL statement do?   SELECT PART, SUPPLIER, PARTS.PROD#, PRODUCT, PRICE FROM PARTS LEFT OUTER JOIN PRODUCTS ON PARTS.PROD#=PRODUCTS.PROD# AND PRODUCTS.PRICE>10.00;

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?