Mixed 59.doc

CLICK HERE TO DOWNLOAD THIS ANSWER INSTANTLY

 

  1. (TCO 3) Normalization works through a series of stages called normal forms. Typically _________ stages must be completed before a table can be considered normalized.
    2. (TCO 3) A table that is in 1NF and includes no partial dependencies only is said to be in _________
    1NF.
    2NF.
    3NF.
    4NF.
    BCNF.
    3. (TCO 3) Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the ____ relationship.
    null
    1:1
    1:M
    M:N
    4. (TCO 9) Which of the following is not a valid SQL statement?
    INSERT INTO promotion (gift, minretail, maxretail)
    VALUES (‘FREE BOOK’, 75.01, 89.99)
    INSERT INTO promotion VALUES (‘FREE BOOK’, 75.01, 89.99)
    INSERT INTO promotion (gift, minretail)
    VALUES (‘FREE BOOK’, 75.01, 89.99)
    INSERT INTO promotion (gift, minretail, maxretail)
    VALUES (‘FREE BOOK’, 75.01, NULL)
    5. (TCO 4) Which command is used to restore the table’s contents to their default values?
    COMMIT; RESTORE;
    COMMIT; BACKUP;
    COMMIT; ROLLBACK;
    ROLLBACK;