Making sure all ____ are identified is a very important part of a database designer’s job.

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

Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com