Explore BrainMass
Share

Explore BrainMass

    Database Design Questions

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com October 9, 2019, 6:53 pm ad1c9bdddf
    https://brainmass.com/computer-science/c/database-design-questions-100977
    $2.19