Midterm FDB USTH_Gen13 (2024-2025)

1. 1. A relational database is

• A. a library...

• B. A set of metadata...

• C. ???

• D. A set of application...

• E. A collection of forms...

2. 2. The Microsoft Access application generator is not responsible for

• a. creating tables

• b. storing queries

• c. creating reports

• d. creating queries

• e. creating forms

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

• a. ERD

• b. database application

• c. database

• d. DBMS

4. 4. Key that contains more than one attribute is called a(n)

• a. complex key

• b. foreign key

• c. candidate key

• d. n-key

• e. composite key

5. 5. A primary key is

• a. used to represent...

• b. comprised of...

• c. a candidate key

• d. not required...

• e. always automatically...

6. 6. 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

• a. check constraint

• b. foreign key constraint

• c. primary key constraint

• d. synchronization

• e. a referential...

7.Given the relations

 

STUDENT (SID. StudentName, Major, AdvisorID)

 

ADVISOR (AdvisorID, Advisor Name, Office, Phone)

 

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

• a. Phone

• b. Major

• c. SID is both...

• d. Advisor of STUDENT...

• e. AdvisorName...

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

• a. depending...

• b. True

• c. False

9.Which of the following is NOT true about null values?

• a. ???

• b. a null ... unknown...

• c. a null... known...

• d. null values... avoided

• e. a null value is ambiguous

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

• a. foreign key

• b. candidate key

• c. composite key

• d. primary key