T490 Spring 2006 Final

Part I, True/False Questions :

1. If a table does not have a composite key, then it is in 2NF.
True. False.

2. It is always possible to properly design a database and avoid using composite keys.
True. False.

3. The SQL keyword DISTINCT is used to indicate that an attribute must have unique values in the original table used in the query.
True. False.

4. A subtable is a just portion of a larger table.
True. False.

5. From a Human Factors Design perspective, it is good practice for forms to provide Feedback through visual, text, sound or a combination of media.
True. False.

6. In procedural languages the developer specifies what is to be done and the system figures out how to do it.
True. False.

7. It is possible to change a method or prope1°ty inherited from a higher level class.
True. False.

8. A tabular form would be appropriate for a banking application where you only want to display a single user's record at one time.
True. False.

9. All data triggers only activate after a value in a row is changed.
True. False.

10. All queries can be designed to avoid subqueries.
True. False.

11. The relational database model is the predominant method of storing data today.
True. False.

12. The SQL UPDATE operation changes the table structure while leaving the data intact.
True. False.

13. In a university database, the normal multiplicity for a relationship between courses and students would be one to many.
True. False.

14. The employee - manager association is an example of an inheritance relationship.
True. False.

15. WHERE is used to place a constraint on aggregated properties.
True. False.

16. A View is a saved query and can be used in other queries.
True. False.

17. A single-row form would be appropriate for a banking application where you only want to display a single user's record at one time.
True. False.

18. The employee - manager association is an example of a reflexive relationship.
True. False.

19. SQL is not a procedural language.
True. False.

20. A reflexive join means that a table is joined to itself.
True. False.

Part II, Multiple Choice Questions:


21. Which ofthe following types of isolation levels provides the MOST protection against concurrency problems?
A) SERIALIZABLE
B) REPEATABLE READ
C) READ COMMITTED
D) READ UNCOMMITTED

22. Procedural code can often be placed in which of the following?
A) Only in forms and reports
B) Only in the query system
C) Only in external programs
D) All of the above

23. Which ofthe following is not one of the primary tasks of a query language?
A) Deiine the structure of the database
B) Locate and retrieve data contained in the database
C) Change and manage the information stored in the database
D) All the above are primary tasks of a query language

24. What is the component of a DBMS that is responsible for storing, retrieving, and updating data?
A) Database engine
B) Query engine
C) Data management engine
D) Data dictionary

25. A SQL keyword that is commonly used to answer questions involving some reference to 'every' item in a certain iield (i.e., such a students that have taken every MIS class offered, or who has had every Accounting faculty for at least one c1ass)?
A) EVERY
B) EXISTS
C) IN
D) ALL

26. When creating a query, what is the purpose of including a column Alias?
A) To control the sort order
B) To give the query designer control over the column name
C) To maintain anonymity
D) The real name is not known

27. The tool which assists in generating input screens is referred to as .
A) input screen tool
B) data dictionary
C) report generator
D) forms generator

28. What is the purpose of the SQL operator IN?
A) Specifies that the sort order should be increasing
B) Used in the GROUP BY statement to indicate sub-groups
C) Used to test if one value appears in a set of values
D) Indicates which table each field can be found

Assume that you are dealing with a database dealing with a university curriculum and have created the table Schedule to capture which instructor is teaching each course under the following business rules:
Schedule (CourseNo, Discipline, Instructor)
Business rules:
1) CourseNo uniquely defines each course offering
2) Faculty have a single discipline area (i.e., Finance, Marketing, or Information Systems), and only teach classes in that area
3) There are many faculty in each discipline
4) Students can have more than one faculty for classes in a certain discipline (you can have different instructors for Accounting l and Accounting 2).

29. Assume you want to add student registration information to the database, capturing which student is enrolled in which course. What is the best way to incorporate this data?
A) Add another table with only two colurrms, CourseNo, StudentlD, which is then associated with the Schedule table
B) Add another table with Student infonnation including all courses they are taking (i.e.,Student(ID, Name, address, (other personal information fields), Coursel, Course2, ...,CourseN)
C) Add another table which list the CourseNo, followed by a column for each student (i.e.,CourseNo, Studentl, Student2, , StudentN)
D) Add a column in the schedule table for each student (i.e., CourseNo, Discipline,Instructor, Studentl, Student2, , StudentN)

30. Assume that you have a Customer table and an Order table, where Referential Integrity constraints require that a customer record be entered before an order can be entered. Also Cascade on delete is enforced. If you delete a Customer record, ______.
A) the Customerid in the order table will be set to null for those records which previously referred to the now deleted customer.
B) the system will prevent you from deleting the customer until the orders placed by that customer are deleted first by the user.
C) orders by that customer will be deleted.
D) nothing will happen to the order table (it will be unchanged).

31. Assume you are creating a database to handle the data associated with assembling PCs from components (The PC itself is not considered a component). What is the most appropriate special association to model the PCS' makeup (for example, motherboard,case, power supply, hard disk drive, CD reader, monitor, ....etc.) ?
A) reflexive association
B) composition association
C) generalization association
D) n-ary association

32. The type of form that displays data from two tables that have a one-to-many relationship is called a ______.
A) referential form
B) relational form
C) subform
D) crosstab form

33. In some SQL systems you can create your own data types with what command?
A) DEFINE DATA
B) CREATE DATA
C) DEFINE VARIABLE
D) CREATE DOMAIN

34. What does a Null value represent in a database?
A) Missing data
B) A negative or false value
C) A text string full of spaces
D) An error, such as 'illegal value'

35. After conceptually designing your database, the information contained in a single class would normally be stored in a ______.
A) field
B) property
C) table
D) database

36. The purpose of am N-ary Association is
A) to deal with one to many relationships
B) to represent an inheritance relationship
C) to capture a parent-child relationship
D) to deal with relationships that involve more than two tables

37. A hidden dependency exists if ______.
A) the defining and dependent columns are in the same table
B) there is no composite key defined
C) the dependency is not explicitly captured in a table
D) there is no foreign key defined

38. In a database context, what is a transaction?
A) Any process which either accesses or changes the contents of one or more records in a database
B) Any interaction with the database (insertion, deletion, update, creation of new tables, etc.)
C) A set of changes that must all be made together
D) Any database action that involves the exchange of information between two users of the database

39. Human factors design research has found all of the following important factors to consider when building forms and reports EXCEPT which of the following?
A) Confirmation of deletions and changes to existing data
B) Integrated feedback in response to user actions
C) Support of multiple operating systems
D) Ability to customize form to user's preference

40. Direct manipulation of objects is a consequence of what advancement in computer systems.
A) Increase emphasis of graphical user interfaces
B) The world wide web
C) Faster and more poweriiil processors
D) Increased connectivity through networks

Quiz script provided by
JavaScriptKit.com