SQL_2

What is in the centre of Canada’s flag?

• Leaf

• Bear

• Maple Leaf

• Red

How many bones does an adult human have?

• 105

• 207

• 200

• 206

What is partial dependency?

• When a non-key attribute determined by another non-key attribute

• When an attribute is determined by part of the primary key

• When a determinant is matched with a set of values

• When the value of an attribute can determine the value of another

Which of the following is NOT a characteristic of a relation?

• Each column has a unique name

• Rows contain data about an entity

• Columns contain data about attributes of the entities

• The order of the columns is important

Which of the following clause allows us to extract data in a range?

• RANGE

• BETWEEN

• FIND IN

• LIKE

Which of the following statements about the MAX function in SQL are true?

• It can be used with numeric, date-time and char data types.

• • Returns the max value of the attribute.

• • It is an aggregate function.

• • All of the above statements are true.

What is the purpose of the Boyce-Codd Normal Form (BCNF) in database design?

• To eliminate transitive dependencies

• To eliminate duplicate records

• To enforce referential integrity

• To ensure all columns are atomic

What is the primary purpose of normalization in a relational database?

• Increase Data Redundancy

• Improve Data integrity

• Simplify data Retrieval

• Speed up data insertion

Third Normal Form (3NF) allows transitive dependencies in a relational database.

• True

• False

Which operator would you use to change the sorting of a query?

• GROUP BY

• ORDER BY

• HAVING

• SORT