WEEK 4- ECET-450 MIDTERM Multiple choices

Question 1. 1. (TCO 1) A collection of related tables is called a(n) ______________________ database. (Points : 4)

Question 2. 2. (TCO 1) "Raw" facts, such as a telephone number, a birth date, and a customer name, are also referred to as ______________________. (Points : 4)

Question 3. 3. (TCO 1) The Data Base Management System makes data management more ____________. (Points : 4)

Question 4. 4. (TCO 1) The response of the DBMS to a query is the ____. (Points : 4)

Question 5. 5. (TCO 2) The term _____________ design is used to refer to the task of creating the conceptual data model represented Entity Relationship Diagram (ERD). (Points : 4)

Question 6. 6. (TCO 2) ____ data can have only a true or false (yes or no) condition. (Points : 4)

Question 7. 7. (TCO 2) In a relational database, each table must have (Points : 4)

Question 8. 8. (TCO 2) A primary key _________________________. (Points : 4)

Question 9. 9. (TCO 2) A ___________ key is a key that is composed of more than one attribute. (Points : 4)

Question 10. 10. (TCO 2) A relationship is an association among (Points : 4)

Question 11. 11. (TCO 2) The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text. (Points : 4)

Question 12. 12. (TCO 5) The ___________ model is both software and hardware dependent. (Points : 4)

Question 13. 13. (TCO 5) If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship. (Points : 4)

Question 14. 14. (TCO 3) A table is said to be in ________ if it has all key attributes defined, all its attributes dependent on the primary key, and no repeating groups. (Points : 4)

Question 15. 15. (TCO 3) All of the following are true about a prime attribute except (Points : 4)

Question 16. 16. (TCO 3) ____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely. (Points : 4)

Question 17. 17. (TCO 3) Improving ____ leads to more flexible queries. (Points : 4)

Question 18. 18. (TCO 3) A table that is in 1NF and includes no partial dependencies only is said to be in (Points : 4)

Question 1. 1. (TCO 4) The SQL command that lets you insert row(s) into a table is ____. (Points : 4)

Question 2. 2. (TCO 4) The most recent version of standard SQL prescribed by the ANSI is ____. (Points : 4)

Question 3. 3. (TCO 4) The ____ query will output the table contents when the value of V_CODE is less than or equal to 21344. (Points : 4)

Question 4. 4. (TCO 4) When you issue the DELETE FROM tablename command without specifying a where condition ____. (Points : 4)

Question 5. 5. (TCO 4) To list all the contents of the PRODUCT table, you would use ____. (Points : 4)

Question 6. 6. (TCO 4) The ____ query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1. (Points : 4)

Question 7. 7. (TCO 4) The command used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the Product table in ascending order by P_PRICE is ____. (Points : 4)

Question 8. 8. (TCO 4) The SQL command to output the contents of the Employee table sorted by last name, first name, and initial is ____. (Points : 4)

Question 9. 9. (TC 4) A(n) ____ is an alternate name given to a column or table in any SQL statement. (Points : 4)

Question 10. 10. (TCO4) The ____ command uses columns and column aliases to determine the total value of inventory held on hand and to display the results in a column labeled TotValue. (Points : 4)

Question 11. 11. (TCO 4) The special operator used to check whether an attribute value is within a range of values is ____. (Points : 4)

Question 12. 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 : 4)