multiple choice

1) __________ exists when it is possible to make changes in the data storage characteristics without affecting an application programs ability to access data.

		Data dependence
		Data independence
		Data Integrity
		Data redundancy

2)The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is _____.

		SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
		SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
		SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
		SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

3) The following SQL statement uses a(n) SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE=VENDOR. V_CODE

		"old-style" join
		natural join
		set operator
		procedural statement

4) The PL/SQL block starts with the _____ section.

		IS
		BEGIN
		DECLARE
		OPEN

5) The entity relationship diagram (ERD) represents the _____ database as viewed by the end user.

		physical
		logical
		condensed
		conceptual

6) A relation is in third normal form (3NF) if and only if it is in 2NF and ________.

		every candidate key is a determinant
		all non-key attributes are determined by the entire primary key
		every attribute is a candidate key
		there are no non-key attributes determined by another non-key attribute