intro to basebas

1. (TCO 4) A(n) _____ provides a detailed description of all attributes in the ERD including their datatypes. (Points : 4) entity relationship diagram data dictionary business rule psuedocode

Question 2. 2. (TCO 3) What constraint can only be applied at table level or with an ALTER statement? (Points : 4)

Foreign key Not null Single field primary key Composite primary key

Question 3. 3. (TCO 3) You are creating a table called Department with fields for the primary key DeptID (Integer) and department name (VARCHAR). What (if anything) is wrong with the following code? CREATE TABLE Department ( deptID INTEGER Primary Key, deptName VARCHAR(10) NOT NULL, ); (Points : 4)

You must use curly braces, not parentheses. The comma after NOT NULL must be removed. The keywords cannot be in uppercase. Nothing is wrong.

Question 4. 4. (TCO 6) Given a table orders with fields for orderid, orderdate, and shipdate, which query will display the orderid and shipdate, displaying NOT SHIPPED for those orders that have not shipped? (Points : 4)

SELECT orderid, IFNULL(orderdate, NOT SHIPPED) FROM orders; SELECT orderid, IFNULL(shipdate, NOT SHIPPED) FROM orders; SELECT orderid, shipdate, NOT SHIPPED WHERE shipdate IS NULL; SELECT orderid, shipdate, NOT SHIPPED WHERE shipdate IS NOT NULL;

Question 5. 5. (TCO 6) Which WHERE clause will return data on all books with JAVA anywhere in the title? (Points : 4)

WHERE title LIKE JAVA WHERE title LIKE JAVA% WHERE title LIKE %JAVA% WHERE title LIKE %JAVA

Question 6. 6. (TCO 7) Consider the ERD below. How many tables would be required to create a query to display the customer first and last name along with orderdate of each order they placed? (Points : 4)

One Two Three Four

Question 7. 7. (TCO 7) A left join returns _____. (Points : 4)

rows in the left table that dont satisfy the join condition unmatched rows from both the left and right tables rows in the right table that dont satisfy the join condition the Cartesian product of the two tables

Question 8. 8. (TCO 7) What type of subquery is executed once for each row processed by the main query? (Points : 4)

Correlated Uncorrelated Inner Outer

Question 9. 9. (TCO 7) Which of the following statements is correct? (Points : 4)

WHERE operates on groups formed by aggregate functions and HAVING operates on individual rows. WHERE can only be used along with HAVING. HAVING can only be used along with WHERE. WHERE operates on individual rows and HAVING operates on groups formed by aggregate functions.

Question 10. 10. (TCO 9) Assuming the SELECT statement below is a proper query, which is true regarding the following statement? CREATE VIEW example AS SELECT vendor_name, SUM(invoice_total) AS Invoice Sum FROM vendors JOIN invoices ON vendors.vendor_id = invoices.vendor_id GROUP BY vendor_name ORDER BY vendor_name; (Points : 4)

It will fail because the GROUP BY clause is not allowed in a view. It will fail because SUM function is not allowed in a view. It will fail because ORDER BY clause is not allowed in a view. It will succeed.