T490 Fall 2009 Final

Part I, True/False Questions :

1. Form design can impact data entry efficiency.
True. False.

2. In a client / server environment, data independence causes client side applications to be essentially independent of the database stored on the server side.
True. False.

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

4. To include a title at the top of each page in a report, the required text would be placed in the report header.
True. False.

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

6. A reflexive association links one class back to itself
True. False.

7. If you use a GROUP BY command, you can not see the non aggregated data in the same query.
True. False.

8. The employee – manager association is an example of a reflexive relationship
True. False.

9. A class will participate in a reflexive relationship using two different roles
True. False.

10. Data normalization minimizes data redundancy.
True. False.

11. SQL does not allow you to use the same table in a subquery as is being used in the outer query (i.e., the query that includes the subquery).
True. False.

12. SQL provides visually oriented tools for developing queries.
True. False.

13. The data seen by the end-user should be stored in the database in exactly the same format
True. False.

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

15. From a Human Factors Design perspective, issues surrounding aesthetics involves the visual appeal of the user form.
True. False.

16. To build and manage databases you need to have either a data definition language, a data manipulation language, or a general-purpose host language.
True. False.

17. A view will always produce up-to-date results, even if the underlying data changes, but we cannot always update a view directly.
True. False.

18. The SQL CASE function is used to create output categories based on certain criteria.
True. False.

19. Form design can impact user performance.
True. False.

20. The query processor analyses the user queries and produces implementation plans for them with the help of the data dictionary
True. False.

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

22. 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.

23. A relation that has a simple primary key (non-composite) must be in BCNF
True. False.

24. From a Human Factors Design perspective, it is good practice for forms to provide Feedback only visually.
True. False.

25. The Object oriented database model is the most common database model in use today.
True. False.

Part II, Multiple Choice Questions:


26. In referential integrity, in order to ensure that all matching records in a referring table are deleted when the matching record is deleted in the referenced relation, we can use:
A) Cascade Delete
B) Delete All
C) Delete-Matching
D) None of the above

27. A hidden dependency exists if ____________________.
A) There is no foreign key defined
B) The dependency is not explicitly captured in a table
C) There is no composite key defined
D) The defining and dependent columns are in different tables

28. Which SQL keyword is used to eliminate duplicates in query results?
A) NO-DUPLICATES
B) ELIMINATE
C) DISTINCT
D) UNIQUE

29. What is the purpose of the SQL clause BETWEEN?
A) To modify the JOIN command
B) Impose a query constraint covering a range of values
C) Indicate that two tables have an association
D) To establish the sequence of columns for a query

30. The part of the database design process concerned with storing the data in tables in the most efficient way is called:
A) Defragmentation
B) Compression
C) Normalisation
D) Optimisation

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

32. When the user clicks a ______________, a pre-defined event is triggered, and some action will be performed.
A) combo button
B) command button
C) unbound control
D) none of the above

33. The following associations can be dealt with by relational databases:
A) One to One
B) One to Many
C) Both A and B above
D) One to One, One to Many and Many to Many

34. What is the order of processing if both a BEFORE UPDATE row trigger and BEFORE UPDATE table trigger are activated by the same event?
A) It is indeterminate, and will vary depending on system activity
B) Row trigger followed by table trigger
C) Table Trigger followed by Row Trigger
D) It depends on how the triggers are defined

35. You would use this SQL command to remove a table and all its contents from the database schema?
A) SEQUENCE BY
B) ERASE TABLE
C) DROP TABLE
D) DELETE FROM

36. Which type of query combines every row from the left table with every row from the right table and inserts a NULLs where appropriate?
A) INNER JOIN
B) OUTER JOIN
C) FULL JOIN
D) THETA JOIN

37. DELETE, coupled with the appropriate modifiers, is used ________________.
A) Only to remove rows or columns from a table
B) Remove rows or columns from a table, as well as replace specific property values with a null
C) Only to remove rows from a table
D) Only to remove columns from a table

38. In an Orders database, what is the appropriate min-max multiplicity for an association linking Orders to Items? Focus on the numbers placed next to the 'Orders' side of the association.
A) 1..*
B) 1..1
C) *..*
D) 0..1

39. What is the purpose of a SAVEPOINT in a transaction.
A) Provides a stable position in the middle of a transactions where the process and data can be 'rolled back' to if the transaction fails mid-process
B) Tracks the progress of the transaction from start to finish
C) Provides a backup of data in the database
D) It is the location where intermediate results are stored without impacting the original data

40. A table is in Boyce-Codd Normal Form (BCNF) if ______.
A) It is in 3NF and no hidden dependencies exist between non-key fields and key fields
B) The table is indexed using a non-key attribute
C) It is in 2NF and data integrity is enforced
D) Referential integrity is enforced

41. What is the main strength of Relational Databases?
A) Flexibility an efficiency in accessing data
B) Do not enforce a rigid navigational structure
C) Are widely used
D) All of the above

42. A reflexive association is drawn using which symbol __________________.
A) A line which loops back onto the same class with a single role name
B) Small open diamond at the end of a line connecting two classes
C) Small triangle at the end of a line connecting the aggregated item and multiple component items
D) A line which loops back onto the same class with two role names

43. When designing a form, the general term that refers to the objects you place on the form used to display basic text and data is ___________________.
A) Widgets
B) Input boxes or text boxes
C) Tools
D) Beans

Use the following to answer question 44:
The following functional dependencies apply to a job training table:
Training (StudentID, Training-Course, Trainer, Score)
(StudentID, Training-Course) Trainer, Score
Trainer Training-Course
44. What is the highest normal form to which this table conforms?
A) 3NF
B) 1NF
C) 4NF
D) 2NF

45. 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

46. Which of the following cannot be done using Triggers?
A) Prevent actions that would violate business rules that have been defined in the database
B) Examine changes/updates to the database and ensure they conform to business rules before they are implemented
C) Execute required actions that are necessary after data has been changed/updated in the database implemented
D) All of the above can be done using triggers

47. Which of the following are not SQL Data Definition Commands?
A) CREATE SCHEMA
B) SELECT FROM
C) ALTER TABLE
D) CREATE TABLE

48. A simple class diagram for a university database has only three classes: Teachers, Students and Courses. How many binary associations will be sufficient to establish whether Teacher X is teaching Course Y to student Z?
A) 2
B) 3
C) 1
D) None of the above

49. The following query is supposed to List the Items that have sold for a price higher than the average for Items of the same Type:
SELECT A1.ItemID, A1.ItemName, A1.Type, SaleItem.SalePrice
FROM Items As A1 INNER JOIN SaleItem
ON A1.ItemID = SaleItem.ItemID
WHERE (SaleItem.SalePrice >

Which of the following correctly completes this query?
A) (SELECT Avg(SaleItem.SalePrice)
FROM Items AS A2 INNER JOIN SaleItem ON Items.ItemID = SaleItem.ItemID
WHERE (Items.Type = Items.Type) ) );
B) (SELECT Avg(SaleItem.SalePrice)
FROM Items As A2 INNER JOIN SaleItem
ON A2.ItemID = SaleItem.ItemID
WHERE (A2.Type = A1.Type) ) );
C) (SELECT Avg(SaleItem.SalePrice)
FROM Items INNER JOIN SaleItem ON Items.ItemID = SaleItem.ItemID
WHERE (Items.Type = Items.Type) ) );
D) (SELECT Avg(SaleItem.SalePrice)
FROM Items AS A1 INNER JOIN SaleItem
ON A1.ItemID = SaleItem.ItemID
WHERE (A2.Type = A1.Type) ) );

50. The data dictionary is:
A) A glossary of technical terms used in the database technology
B) A spell checker for the database
C) A description of the contents of the database
D) A language reference to locate definitions of words used in the database

Quiz script provided by
JavaScriptKit.com