University:
California State University, Northridge
Course:
COMP 440 | Database Design
Academic year:

2021
Views:

450

Pages:

1
Author:

5prinzg1s

[Sample Questions for Practice] 1. In order to meet performance requirements, portions of the database design may 2. Normalization represents a micro view of the entities within the ERD. /F) 3. Dependencies that are based on only a part of a composite primary key are called transitive dependencies. (T/ ) 4. Since a partial dependency can exist only if a table's primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF. ( /F) 5. A relational table must not contain a(n) _____. a. entity b. attribute c. relationship repeating group 6. A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____. b. 2NF c.3NF d. 4NF 7. Mathematical operators cannot be used to place restrictions on character-based attributes. (T/ ) 8. To list the contents of a table, you must use the DISPLAY command. (T/ ) 9. SQL requires the use of the ADD command to enter data into a table. (T/ 10. The conditional LIKE must be used in conjunction with wildcard characters. /F) 11. An alias cannot be used when a table is required to be joined to itself in a recursive query. (T/ ) 12. The SQL command that allows a user to permanently save data changes is _____. COMMIT a. INSERT b. SELECT d. UPDATE 13. The _____ command would be used to delete the table row where the P_CODE is 'BRT-345'. WHERE P_CODE = 'BRT-345'; b. REMOVE FROM PRODUCT WHERE P_CODE = 'BRT-345'; c. ERASE FROM PRODUCT WHERE P_CODE = 'BRT-345'; d. ROLLBACK FROM PRODUCT WHERE P_CODE = 'BRT-345'; 14. The special operator used to check whether an attribute value is within a range of values is _____. b. NULL d. IN c. LIKE 15. Selecting database management system (DBMS) software is part of the _____ phase of the Database Life Cycle (DBLC). a. database initial study c. implementation and loading d. testing and evaluation