Database Design Questions

1. What function must a file management system perform?
a. Create the file structure.
b. Add data to the file.
c. Delete data from the file.
d. All of the above
e.None of the above

2. In a network database each set is composed of two record types: an
owner record and a _________________ record.
a. root
b. child
c. member
d. renter

3. Data anomalies include:
a. modification anomalies.
b. insertion anomalies.
c. deletion anomalies.
d. All of the above. a and b only

5. Which of the following statements concerning the primary key is
true?
a. All primary key entries are unique.
b. The primary key may be null.
c. The primary key is not required for all tables.
d. The primary key data does not have to be unique.

6. A set of allowable operations for a date field might be:
a. compare two dates.
b. find the difference in days between two dates.
c. create a date by adding or subtracting a number of days from
a given date.
d. convert a date from its internal representation to a different
presentation fore. All of the above

7. Which of the following is a database model building block?
a. relationship
b. entity
c. attribute
d. All of the above

8. The entity relationship diagram is used to graphically represent the
_________ database model.
a. condensed
b. physical
c. logical
d.conceptual

9. The Crow's Foot model is more easily adapted to ____________ tools
than the Chen model.
a. CASE
b. programming
c. model
d. relationship

10. The _________________ model is the representation of the database
as "seen" by the DBMS.
a. internal
b. external
c. physical
d. conceptual

11. ______________ independence means that the model does not depend
on the DBMS software.
a. Software
b. Hardware
c. Model
d.Relationship

12. What is not a condition for a weak entity?
a. It is existence-dependent
b. It has an identifying relationship with its parent entity
c. It has a primary key that is partially or totally derived from
the parent entity in the relationship
d. None of the above

13. A ________________ entity has a primary key that is partially
derived from the parent entity in the relationship.
a. strong
b. weak
c. business
d. relationship

14. In the generalization hierarchy, the ___________ contains the unique
attributes.
a. subtype
b. supertype
c. unary
d. weak

15. The _____________ model combines connectivity and cardinality
information in a single symbol set.
a. Chen
b. Crow's Foot
c. Rein85
d. IDEF1X

16. The _____________ model does not recognize cardinalities explicitly,
relying on connectivities to lead to logical cardinality conclusions.
a. Chen
b. Crow's Foot
c. Rein85
d. IDEF1X

17. The ______________ model is a derivative of the integrated
computer-aided manufacturing studies that were conducted in the
late 1970s.
a. Chen
b. Crow's Foot
c. Rein85
d. IDEF1X

18. The ________ model views the data as part of a table or collection of
tables in which all key values must be identified.
a. relational
b. object-oriented
c. conceptud.external

19. Normalization works through a series of normal:
a. schemas.
b. entities.
c. databases.
d. forms.

20. In a SQL environment a database schema:
a. defines the relationships between objects in a database
b. is associated with all authenticated users of a database
c. belongs to all users and applications associated with a
database
d. a and b
e.b and c

21. To create a query that will output the table content when the value
of the character field P_CODE = 1558-QW1, use the following query:
a. SELECT P_CODE, P_DESCRIPT, P_ONHAND, P_MIN, P_PRICE
FROM PRODUCT
WHERE P-CODE = '1558-QW1'
b. SELECT P_CODE, P_DESCRIPT, P_ONHAND, P_MIN, P_PRICE
FROM PRODUCT
WHERE P-CODE = [1558-QW1]
c. SELECT P_CODE, P_DESCRIPT, P_ONHAND, P_MIN, P_PRICE
FROM PRODUCT
WHERE P-CODE = (1558-QW1)
d. SELECT P_CODE, P_DESCRIPT, P_ONHAND, P_MIN, P_PRICE
FROM PRODUCT
WHERE P-CODE = {1558-QW1}

22. In a mainframe query command, to list all the rows in which the
inventory stock dates occur on or after January 20, 2002 the
command will be as follows:
a. SELECT P_DESCRIPT, P_HAND, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDATE >= '01/20/2002'
b. SELECT P_DESCRIPT, P_HAND, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDATE >= #01/20/2002#
c. SELECT P_DESCRIPT, P_HAND, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDATE >= '20-JAN-2002'
d. SELECT P_DESCRIPT, P_HAND, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDATE >= {01-20-2002}

23. To delete the fifth row from the PRODUCT table, use the
____________ command.
a. KILL
b. DELETE
c. COMMITd.ERASE

24. The first step in developing the conceptual model using E-R
diagrams is to:
a. normalize the entities.
b. complete the initial E-R diagram.
c. identify, analyze, and refine the business rules.
d. define the attrof the entities.

25. A Cartesian product can be formed by what kind of join?
a. An Inner Join
b. An Outer Join
c. A Cross Join
d. All of the above

26. Which of the conceptual design steps identifies the main processes:
insert, update, and delete rules?
a. Database analysis and requirements
b. Entity relationship modeling and normalization
c. Data model verification
d. Distributed database design

27. What is the business rule that is being illustrated in the E-R model
segment in the above figure?
a. Each item belongs to one or more inventory type.
b. Each inventory type belongs to one or more item.
c. Each item belongs to only one inventory type.
d. Each inventory type belongs to only one item.

28. What is the business rule that the E-R model segment in the above
figure is illustrating?
a. Items will not be stored in the locations.
b. Items will be stored in one location. Each storage location
will store only one item.
c. Some items may be stored in zero, one, or more locations.
Each storage locatd. None of the above

29. What is the business rule that the E-R model segment in the above
figure is illustrating?
a. An order references only one vendor, and each vendor can
have zero, one, or many orders.
b. An order references many vendors, and each vendor can have
only one order.
c. A vendor references only one order, and each order can have
zero, one, or many vendors.
d. An order references many vendors, and each vendor can have
only one order.

30. What is the business rule that the E-R model segment in the above
figure is illustrating?
a. Each inventory item corresponds to one inventory type, and
each inventory type can be referenced by one or many order
item lines.
b. Each inventory item corresponds to several inventory types,
and each inventory type can be referenced by only one item
line.
c. Each inventory type corresponds to one inventory item, and
each inventory item can be referenced by one or many order
inventory lines.
d. Each inventory item corresponds to several inventory types,
and each inventory type can be referenced by several order
inventory lines.

31. You never define the foreign key at the entity level for any entity, no
matter what its relationship is to other entities. You must ensure
that the following actions are taken:
a. All the foreign key components that are inherited from
related entities will be properly inserted into each entity that
requires the use of such inherited primary key attribute(s).
b. The foreign keys will always inherit the attribute
characteristics from the primary keys that they point to.
c. The primary keys will always inherit the attribute
characteristics from the foreign key that they point to.
d. All foreign keys will be deleted from the entries to properly
reflect the relationship that you have defined for those
entries.

32. _______________ measures refer to the ability to retrieve information
within a reasonable time and at a reasonable cost.
a. Security
b. Performance
c. Backup
d. Recovery

33. All tables, indexes, and views that were defined during the logical
design phase are created during the database __________ phase.
a. conversion
b. procedure
c. loading d. creation

34. A(n) ________ Join returns not only the matching rows, but also the
rows with unmatched attribute values for one or both tables to be
joined.
a. Outer
b. Inner
c. Cross
d.Natural

35. The logical design process is used to translate the conceptual design
into the ________ model for the selected DBMS.
a. external
b. conceptual
c. internal
d.physical

36. _________ enable designers to produce logically ordered output
sequences.
a. Indexes
b. Schemas
c. Models d. Tags