T490 Fall 2006 Final

Part I, True/False Questions :

1. Properties of an object are stored as rows in a table.
True. False.

2. It is not possible to access data stored in a database using a program written in Visual Basic or COBOL.
True. False.

3. De Morgan's Law is used to simplify complex constraints.
True. False.

4. DBMS stores data efficiently with little wasted space.
True. False.

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

6. A primary goal ofa database system is to share data with multiple users.
True. False.

7. Multiple constraints can be included in a single query.
True. False.

8. Specifying an asterisk (*) forthe association multiplicity on a class diagram indicates that the item is required.
True. False.

9. Specifying a zero (0) for the lower bound for the association multiplicity on a class diagram indicates that the item is required
True. False.

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

1 1. If a table is in 3NF, it is also in 2N`F.
True. False.

12. The primary key does not necessarily have to be be unique for a given table.
True. False.

13. A subquery uses the same syntax as a regular query.
True. False.

14. Procedural code is often placed within fonns and reports.
True. False.

15. A View is a saved query.
True. False.

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

17. Including the DISTINCT operator in a query will always result it less than or equal to the number of records retumed when the DISTINCT operator is not used.
True. False.

18. A bad choice for a primary key for the university's student database is the student phone number.
True. False.

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

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

Part II, Multiple Choice Questions:


21. When creating a query, what is the purpose of assigning a table Alias?
A) To prevent correlated sub queries
B) The real name is not known
C) To distinguish between two instances of the same table
D) To maintain anonymity

22. The database design that uses a hierarchical data structure, but incorporates multiple data entry points is called a ______ .
A) Object oriented database
B) Hierarchical database
C) Relational database
D) Network database

23. If there is a relationship between two tables, this indicates that ______ .
A) the data contained in the two tables are related to each other in some way
B) the structure of the one table is inherited from the other table
C) information from both tables is always used together
D) the data from one table is inherited from the other table

24. The fields in one table that 1i11k to the primary key in another table are called ______ .
A) metadata
B) composite key
C) dependent key
D) foreign key

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

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

27. A table on the many side of a one to many or many to many relationship must______ .
A) be in Third Normal Form (3NF)
B) have a composite key
C) be in domain-key normal form (DKNF)
D) be in Boyce-Codd Normal Form (BCNF)

28. Which of the following is an example where an Online Transaction Processing system would not be used?
A) Clerk recording your purchases at the grocery checkout
B) Checking the current order status
C) The inventory warehouse pulling parts to till an order
D) None of the above. All of the above applications would use Online Transaction Processing.

29. The process that stores copies of a table and stores it in several different locations at the same time is called ______ ?
A) Partitioning
B) Segmentation
C) Data mirroring
D) Replication

30. The definition of primary and foreign key relationships are set using SQL ______ .
A) Keys
B) Assignments
C) Rules
D) Constraints

31. Advantages of a DBMS include all but which of the following?
A) Ease of application development
B) Data Independence
C) Uniform security, privacy and integrity
D) Decentralized administration of the data

32. What is the impact of not including a JOIN command when using multiple tables in a query?
A) The primary keys in each table are joined together
B) The query will not work - an error is generated
C) The foreign keys in each table are linked to the primary keys in the other tables
D) All records in each table are associated with all records in the other tables

33. How does an outer join differ from an inner join?
A) Inner joins involve only one table while an outer join involves multiple tables.
B) Inner joins are processed with the irmer most command first, while the outer join processes the outer most command first.
C) Inner joins only connects records that have matching values in each table, where as an outer join includes records without a match in the other table
D) Inner joins connect tables within the database while outer joins forms a connect to a table outside the database

34. A Database Cursor _______ .
A) Tracks all concurrency locks for the database
B) Defines a Select statement and allows you to loop through the set of data and execute instructions on each row
C) Identities where you are in the database much like a bookmark
D) Manages the isolation level controls for the database

35. What is the purpose of the serialization process?
A) Forces the operations within a transaction to be run in a specific, predefined sequence
B) In a two-phase commit scheme, it ensures that everyone has obtained locks on resources before committing to the change.
C) Allocates access time to the database to make sure it is fair
D) Forces transactions to run separately so that result consistency is maintained

36. If indexes speed data retrieval, then why don't we index all fields in a database?
A) It would take a lot of disk space
B) The overhead of maintaining the index may outweigh the benefits derived.
C) This is actually commonly done in industry.
D) Indexing some fields would violate data integrity constraints

37. With regards to system maintenance, what is the purpose of defining database roles?
A) Decision Support Systems will have different operational characteristics than Expert Systems
B) Simplifies the assigmnent of access privileges by creating logical groups with consistent access needs
C) Categorizes the purpose and administrative requirements of the database
D) Defining database roles helps in the system development process

38. What is metadata?
A) The specifics about the DBMS (i.e., publisher, version number, copyright information, etc.)
B) Operational metrics dealing with the database (i.e., number of users, average response time, number of records accessed, etc.)
C) Database information that is made available on the intemet.
D) Descriptive information about the data stored in the database

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

40. The most popular distributed database configuration, where users (typically using desktop computers) request and receive data from a powerful computer is called _______ .
A) File server system
B) Terminal system
C) Client/ server system
D) Local area network

Quiz script provided by
JavaScriptKit.com