Quiz 2

Question 1

Which of the following statements is not true for an enterprise-class database system?
a. The DBMS accesses the database data.
b. The application generates SQL statements.
c.The database application(s) directly access(es) the database data.
d.The database application(s) interact(s) with the DBMS.

Answer 1

c.The database application(s) directly access(es) the database data.

Question 2

Which of the following statements is true for primary keys in a relational database system?

a.They uniquely identify a row in a table.
b.They must contain numeric data.
c. They can be used to create relationships between fields.
d.They cannot be part of relational integrity constraints.

Answer 2

a. They uniquely identify a row in a table.

Question 3

Database professionals use a set of principles called ________ to guide and assess database design.
a. database extraction
b. entity-relationship data modeling
c. normalization
d. data models

Answer 3

c. normalization

Question 4

Which statement is not true about the relational model?

a. It was first proposed in 1970.
b. It was developed by E. F. Codd.
c. It was developed at Oracle.
d. It resulted in the DBMS product DB2.

Answer 4

c. It was developed at Oracle.

Question 5

The CODASYL DBTG model structured data relationships as a tree structure.
True or
False

Answer 5

False