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