T490 Spring 2008 Final

Part I, True/False Questions :

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

2. The purpose of class diagrams is to model the interrelationships between the different classes in the database.
True. False.

3. Procedural code is often placed within forms and reports.
True. False.

4. The inner query in a correlated nested query is evaluated only once.
True. False.

5. It is possible to use a WHERE if the query contains a GROUP BY.
True. False.

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

7. A columnar Form presents a single record at a time.
True. False.

8. All database forms should be bound to either a table or a query.
True. False.

9. The developer can follow a specific set of procedures and rules to ensure that a table is in 1NF, 2NF and 3NF.
True. False.

10. The relational database model is a navigational model requiring navigational commands to move from one table to another.
True. False.

11. A table with non-atomic values can be in 1NF.
True. False.

12. A limitation of the UPDATE operation is that it can only change one column at the same time.
True. False.

13. Data triggers only activate after a value in a row is changed.
True. False.

14. A limitation of database systems is that no application outside of the DBMS can gain access to the data.
True. False.

15. Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required.
True. False.

16. Using an IN operator is an alternative to using a group of OR clauses in a WHERE statement.
True. False.

17. SQL provides visually oriented tools for developing applications.
True. False.

18. To get subtotals for different grouped data, use the SQL GROUP BY and SUBTOTAL commands.
True. False.

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

20. In a university database, the normal multiplicity for a relationship between courses and students would be many to many.
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. Including the DISTINCT operator in a query will always result it less than or equal to the number of records returned when the DISTINCT operator is not used.
True. False.

23. Database cursor is used to indicate your current position in a database.
True. False.

24. Many to Many associations solve many problems in database designs.
True. False.

25. There is no specific set of procedures and rules to ensure that a table is in DKNF.
True. False.

Part II, Multiple Choice Questions:


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

27. The Table T (A, B, C), where A -> B,C and B -> C is in
A) 2NF
B) 3NF
C) 4NF
D) BCNF

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

29. The process of defining and bundling all of the properties and functions into a class is called _________.
A) encapsulation
B) inheritance
C) polymorphism
D) database design

30. The term for information that describes what type of data is available in a database is _________.
A) index data
B) data dictionary
C) metadata
D) data repository

31. Which of the following is the most appropriate approach to automatically generate purchase order when the inventory level drops to a predetermined level?
A) Input mask
B) Data Trigger
C) Referential Integrity constraint
D) Database Cursor

32. Which SQL command is used to indicate how tables are to be linked together in a query?
A) TABLES
B) GROUP
C) LINK
D) INNER JOIN

33. What is the SQL command to change the structural design of a table?
A) CHANGE STRUCTURE
B) STRUCTURE
C) ALTER TABLE
D) MODIFY DATABASE

34. Which component of the database management system (DBMS) most affects the performance (speed)?
A) Query Processor
B) Security Subsystem
C) Database Engine
D) Data Storage Subsystem

35. The ability to modify the data structure and not have to change the programs using that data is called _________.
A) data independence
B) referential integrity
C) data dictionary
D) data integrity

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

37. The modern database report writer _________.
A) provides the tools for database designer to display information in the desired format
B) is a career path that focuses on creating, managing and supporting the reports generated from databases
C) provides the tools for the database administrator to monitor and report on database use and activity
D) provide limited control over how information is displayed and reported.

38. Which SQL clause is used to specify the tables used in the query?
A) WHERE
B) TABLES
C) FROM
D) SOURCE

39. Why is it a good idea to use special associations when drawing class diagrams?
A) Specialized tools are available to create these special associations.
B) They hide the detail concerning the database structure, making them easier to understand
C) It is necessary. It is impossible to draw some diagrams without using these special structures.
D) They convey more information about the underlying structure of the database, making them easier to understand.

40. What negative effect can triggers have on a database?
A) Makes it more complicated for the end user
B) Since the execution order is only defined at run time, results can be unpredictable
C) They can create security holes if not done properly
D) Cascading triggers can slow down the database

41. Tables in second normal form (2NF) _________.
A) have a composite key
B) have all non-key fields depend on the whole primary key
C) eliminate the possibility of a insertion anomalies
D) eliminate all hidden dependencies

42. A reflexive association is drawn using which symbol _________.
A) small triangle at the end of a line connecting the aggregated item and multiple component items
B) small open diamond at the end of a line connecting two tables
C) small closed diamond at the end of a line connecting two tables
D) a line which loops back onto the same table

43. Which type of join would you use to join two tables based on one value in one table falling within a range of values from the second table rather than exact matches between the two tables?
A) Outer Join
B) Reflexive Join
C) Range Join
D) Inequality Join

44. A table is in Boyce-Codd Normal Form (BCNF) if the table is in 3NF and ________.
A) referential integrity is enforced
B) the table is indexed
C) no hidden dependencies exist between non-key fields and key fields
D) data integrity is enforced

45. Which of the following best illustrates the principle of consistency as related to transactions.
A) The process by which Ann transfers money from her checking to saving account is the same as the process Bob uses to transfers money from his checking to saving account (where each use their own account numbers)
B) Access to the account balances using an ATM is always done in the same way
C) If no money is deposited or withdrawn from a no interest account, the balance today will be the same as the balance tomorrow.
D) The amount of money withdrawn from a checking account equal the amount transferred to the saving account

46. One approach used by databases to handle the differences in fonts used by different languages (i.e., English, Russian, Chinese, etc.) is the support of ______________?
A) UNIX
B) Unicode
C) ASCII
D) Perl

47. What role does the isolation level play in serialization?
A) Deals with the connectivity of transaction to transaction
B) Deals with the referential integrity constraints imposed in the database
C) Determines which data elements must be protected to insure the integrity of the process
D) None of the above

48. Which SQL clause is used to specify the criteria for selecting records in the query?
A) WHEN
B) WHERE
C) RULE
D) CONDITION

49. Assume you are creating a database to handle the data associated with instruction at a university. What is the most appropriate special association to model degree requirements (for example, required number of credit hours in general university requirements, specialty requirements, and electives)?
A) reflexive association
B) composition association
C) generalization association
D) n-ary association

50. A key distinction between abstract data types and subtables is that _________.
A) abstract data types aggregate multiple fields from the base table into a single column, while subtables will keep the fields in separate columns
B) abstract data types support the use of methods while subtables do not
C) subtables support inheritance and abstract data types do not
D) abstract data types support inheritance and subtables do not

Quiz script provided by
JavaScriptKit.com