1233

A relational database is ________.

• a set of metadata

• a collection of forms and reports that support a given purpose

• a set of applications and the data sets for those applications

• a library of queries and data files for querying

The Microsoft Access application generator is not responsible for ________.

 

• a. creating forms

• creating queries

• creating reports

• storing queries

• creating tables

Which of the following is not a basic component of a database system?

• . DBMS

• . Database

• Database Applications

• ERD

A key that contains more than one attribute is called a(n) ________.

• composite key

• n-key

• foreign key

• candidate key

• complex key

A primary key is ________.

• . used to represent columns in relationships

• . not required to be unique

• .  a candidate key

• . comprised of exactly one attribute

• always automatically generated by the DBMS

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called ________.

 

• primary key constraint

• check constraint

• synchronization

• a referential integrity constraint
  key matching constraint

• foreign key constraint

Given the relations:

STUDENT (SID, StudentName, Major, AdvisorID)

ADVISOR (AdvisorID, AdvisorName, Office, Phone)

such that each student is assigned to one advisor, which of the following is true?

 

• Major is a candidate key.

• Phone is a candidate key.

• AdvisorName is a determinant.

• AdvisorID of STUDENT table is a foreign key.

•  SID is both a primary key and a foreign key.

In practice, tables may have duplicate rows even when the primary key has been defined

Select one:

• True

• False

• Depending on the number of columns of the Primary Key

Which of the following is NOT true about null values?

• A null value can mean that the value is unknown.

• A null value is ambiguous

• A null value can mean that the value is known to be blank.

• Null values cannot be avoided.

1.    Which type of key in a relational database is a minimal super key

• Foreign Key

• Primary Key

• Candidate Key

• Composite Key