itss 4300 exam #1 (quiz 1)

Question 1

The only way to access data in a database is through the DBMS. T/F

Answer 1

T

Question 2

_____ is the result of revealing the meaning of raw facts.

Answer 2

Information

Question 3

Which of the following is true of NoSQL databases?

They do not support very large amounts of sparse data.
They are not based on the relational model.
They do not support distributed database architectures.
They are geared toward transact on consistency rather than performance.

Answer 3

They are not based on the relational model.

Question 4

The CUSTOMER table’s primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of _____ integrity.

Answer 4

entity

Question 5

In implementation terms, an entity is existence-dependent if it has a mandatory primary key.

Answer 5

False

Question 6

A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity. (T/F)

Answer 6

False

Question 7

The decision to store _____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application.

Answer 7

derived

Question 8

The entity supertype contains common characteristics, and the entity subtypes each contain their own unique characteristics. (T/F)

Answer 8

T