8. Which is not a benefit of the database approach?

A. Centralized information control
B. Compactness
C. Improved decision support
D. Redundancy

Answer . B. Compactness

Tag . 8 Database Systems 4

10. Which of the following SQL commands can be used for access control in a database?

A. GRANT
B. SELECT
C. INSERT
D. UPDATE

Answer . A. GRANT

Tag . 8 Database Systems 4

19. Which is not a property of relational database schema?

A. A table is either a Base table or Views.
B. Only view tables are physically stored.
C. A relation has a name that is distinct from all other relation names.
D. Each cell of a relation contains exactly one atomic (single) value.

Answer . B. Only view tables are physically stored.

Tag . 8 Database Systems 4

37. The process of transforming a high-level query into relational algebra query and checking whether the query is syntactically and semantically correct is called:

A. Query decomposition
B. Query evaluation
C. Query optimization
D. Tokenization

Answer . C. Query optimization

Tag . 8 Database Systems 4

39. In a base relation, no attribute of a Primary Key can assume a value of NULL. This means:

A. Referential Integrity
B. Enterprise Integrity
C. Domain Integrity
D. Entity Integrity

Answer . D. Entity Integrity

Tag . 8 Database Systems 4