The ____ command is used to restore the table’s contents to their previous values.

Week 8 : Final - Final Exam

Time Remaining: Save Answers Submit for Grading

Page: 1 2 3

Page 1

1. (TCO 1) The middle name of SQL means (Points : 5)

Store data Maintain data Retrieve information Process information

2. (TCO 2) A(n) ____ is anything about which data are to be collected and stored. (Points : 5)

attribute entity relationship constraint

3. (TCO 2) A ____ relationship exists when two entities are associated. (Points : 5)

unary binary ternary weak

4. (TCO 2) A(n) ____ join links tables by selecting only the rows with common values in their common attribute(s). (Points : 5)

equal unique foreign natural

Student Exam http://takeexam.next.ecollege.com/(NEXT(6155f2819b944e4d827686e0...

1 of 4 10/22/2014 7:11 LateBird

5. (TCO 2) The existence of a(n) ____ relationship indicates that the minimum cardinality is 1 for the mandatory entity. (Points : 5)

mandatory optional multivalued single-valued

6. (TCO 2) Making sure all ____ are identified is a very important part of a database designer's job. (Points : 5)

business rules cardinalities derived attributes relationships

7. (TCO 2) Controlled ____ makes a relational database work. (Points : 5)

relations logic chaos redundancy

8. (TCO 2) A ____ contains at least all of the attribute names and characteristics for each table in the system. (Points : 5)

data dictionary relational schema logical schema join

9. (TCO 3) A ____ entity is composed of the primary keys of each of the entities to be connected. (Points : 5)

bridge composite unary binary

10. (TCO 3) ____ relationships are most common. (Points : 5)

Unary Binary Ternary Higher-degree

Student Exam http://takeexam.next.ecollege.com/(NEXT(6155f2819b944e4d827686e0...

2 of 4 10/22/2014 7:11 LateBird

11. (TCO 4) Some RDBMSs (like Oracle) will automatically ____ data changes when issuing data definition commands. (Points : 5)

ROLLBACK COMMIT UPDATE INVOKE

12. (TCO 4) The ____ command is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another. (Points : 5)

SELECT ONLY V_CODE FROM PRODUCT;

SELECT UNIQUE V_CODE FROM PRODUCT;

SELECT DIFFERENT V_CODE FROM PRODUCT;

SELECT DISTINCT V_CODE FROM PRODUCT;

13. (TCO 4) The ____ query will output the table contents when the value of V_CODE is not equal to 21344. (Points : 5)

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344;

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <= 21344;

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;

14. (TCO 4) The SQL command that lets you permanently save data changes is ____. (Points : 5)

INSERT SELECT COMMIT UPDATE

Student Exam http://takeexam.next.ecollege.com/(NEXT(6155f2819b944e4d827686e0...

3 of 4 10/22/2014 7:11 LateBird

15. (TCO 4) The ____ command is used to restore the table's contents to their previous values. (Points : 5)

COMMIT; RESTORE; COMMIT; BACKUP; COMMIT; ROLLBACK; ROLLBACK;

16. (TCO 4) The command to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE and V_CONTACT fields from the VENDOR table, where the value of V_CODE match and the output is ordered by the Price is ____. (Points : 5)

SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; ORDER BY P_PRICE;

SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY P_PRICE;

SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY P_PRICE;

SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY P_PRICE;

Page: 1 2 3

Time Remaining: Save Answers Submit for Grading

Student Exam http://takeexam.next.ecollege.com/(NEXT(6155f2819b944e4d827686e0...

4 of 4 10/22/2014 7:11 LateBird