DAS_2

Properties that describe the characteristics of entities are called __________.

• objects

• attributes

• identifiers

• relationships

Which of the following statements is FALSE about databases?

• You can store large amounts of data.

• You can quickly search for a specific record.

• You do not need any training on how to use the database.

• You can easily add or amend records.

The DELETE statement in SQL helps to _____________.

• create a table

• provide access privileges on a table

• removes one or more rows from a table

• removes a table permanently from a database

The ______________ stores metadata about the structure of the database.

• query pre-processor

• query analyser

• data dictionary

• transaction manager

The entity integrity rule requires that ____.

• all primary key entries are unique

• a part of the key may be null

• foreign key values do not reference primary key values

• duplicate object values are allowed

The following query was written to select ________________.

SELECT DISTINCT AuthorName

FROM Author

• all the outstanding author

• author names without duplicates

• author names that are duplicates

• all author names

"A non-null foreign key value must match the primary key value in the table to which it is related”. This rule is referred to as the ________________.

• transitive dependency

• insertion anomaly

• entity integrity constraint

• referential integrity constraint

Recursive relationships are also known as _____________ relationships.

• unary

• binary

• ternary

• quatenary

Based on the relational schema shown below identify the relationship that exists between the Department and Project relations. Note: Primary keys are underlined and foreign key are denoted in italics.

Department (DeptID, DeptName, Location, Phone, Fax)

Project (ProjectNo, ProjectName, StartDate, DeptID)

• One to one

• One to many

• Many to one

• Many to many

Which of the following statements best defines the Second Normal Form?

• A relation may contain more than one value in each cell.

• There is no transitive functional dependency between non-key attributes.

• Every non-key attribute is fully functionally dependent on the primary key.