mis3376 database exam (ch1-6)
1. The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of 'database' system? A) Hierarchical B) Network C) Object oriented D) Relational
A
1. Which of the following is not true about the Query by Example (QBE) method of accessing data in a database? A) Can totally replace the need to learn and use SQL B) Easier for beginners to use than SQL C) Provides a visually-oriented tools to query the database D) All of the options above are true.
A
10. What is the purpose of the SQL clause BETWEEN? A) Impose a query constraint covering a range of values B) Indicate that two tables have an association C) To establish the sequence of columns for a query D) To modify the JOIN command
A
11. The association role defines ____________________. A) how tables are related in the database B) the relationship between the class diagram and the tables in the database C) the tables that each attribute is contained D) which attribute is the table's primary key
A
12. Tables in first normal form (1NF) __________________. A) do not have any repeating groups B) does not have any replicated data C) eliminate the possibility of a insertion anomalies D) have a composite key
A
13. WHERE is used to place a constraint on non-aggregated properties. A) True B) False
A
15. To use the SQL HAVING keyword you must also use the GROUP BY keyword. A) True B) False
A
16. Query-by-Example provides visually oriented tools for developing queries. A) True B) False
A
17. If you use a GROUP BY command, you can not see the non aggregated data in the same query. A) True B) False
A
17. The employee - manager association is an example of a reflexive relationship A) True B) False
A
18. It is possible to use a WHERE if the query contains a GROUP BY. A) True B) False
A
19. To build and manage databases you need a data definition language, data manipulation language, and a data query language. A) True B) False
A
20. In a university database, the normal multiplicity for a relationship between courses and students would be many to many. A) True B) False
A
20. 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. A) True B) False
A
24. What SQL operator would you use in the following WHERE statement to restrict the result such that saledate is greater than all the values returned from the subquery? WHERE saledate > __________________ (subquery result) A) ALL B) ANY C) IN D) INTERSECTION
A
27. A bad choice for a primary key for the university's student database is the student phone number. A) True B) False
A
31. Tables with no composite primary keys (i.e., primary keys that are based on a single column) are always in second normal form. A) True B) False
A
32. The purpose of class diagrams is to model the interrelationships between the different classes in the database. A) True B) False
A
33. Using an IN operator is an alternative it using a group of OR clauses in a WHERE statement. A) True B) False
A
34. A data type that creates unique numbers for key columns in Microsoft Access is ___________. A) autonumber B) Boolean C) sequential key D) sequential number
A
36. Nested queries can be split into separate parts and then combined to get the final result. A) True B) False
A
37. Data normalization minimizes data redundancy. A) True B) False
A
37. UNION and INTERSECT are operators used to compare tables having similar structure (i.e., having common field names and data types). A) True B) False
A
39. A subquery uses the same syntax as a regular query. A) True B) False
A
4. Which SQL command is used to specify the tables used in the query? A) FROM B) SOURCE C) TABLES D) WHERE
A
40. In a university environment, what is the appropriate multiplicity for an association linking courses with their list of pre-requisite courses? Focus on the numbers placed next to the 'Pre-requisite courses' side of the association. A) 0..* B) 1..* C) 0..1 D) 1..1
A
41. Properties of an object are stored as columns in a table. A) True B) False
A
45. A difference between a list box and a combo box is ______________. A) A combo box allows the user to enter a value that is not in the list, which is not allowed in a list box B) A combo box can be bound to a property in a table, whereas a list box can not C) A list box can be bound to a property in a table, whereas a combo box can not D) The user can not select an entry from a list box (it is only for informational purposes) but can with a combo box
A
45. Database system modelers use this type of diagram to graphically represent both the data structure and how the different objects are interrelated. A) Class Diagram B) Data Diagram C) Object Diagram D) Table Relationship Diagram
A
47. Individual objects are stored as rows in a table. A) True B) False
A
49. Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required. A) True B) False
A
51. From a Human Factors Design perspective, it is good practice for forms to provide Feedback through either visual, text and sound. A) True B) False
A
51. Specifying a zero (0) for the lower bound for the association multiplicity on a class diagram indicates that the item is optional. A) True B) False
A
52. 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 the different elements contained in each classroom (i.e., projection equipment, blackboard type, computer support, etc)? A) composition association B) generalization association C) n-ary association D) reflexive association
A
52. From a Human Factors Design perspective, issues surrounding aesthetics involves support for physically handicapped users. A) True B) False
A
53. 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. A) True B) False
A
53. Specifying an asterisk (*) for the association multiplicity on a class diagram indicates that the quantity of the item is unknown, and can have many items associated with it. A) True B) False
A
54. The developer can follow a specific set of procedures and rules to ensure that a table is in 1NF, 2NF and 3NF. A) True B) False
A
54. To include a title at the top of each page in a report, the required text would be placed in the page header. A) True B) False
A
55. A bound control is linked to the contents of a specific table property, allowing the contents to be displayed and changed. A) True B) False
A
57. A Tabular Form presents the data in a form similar to a spreadsheet. A) True B) False
A
58. A switchboard form is designed to provide the user interface to your database application. A) True B) False
A
58. N-ary associations are used to convert Many to Many relationships to multiple 1 to Many relationships. A) True B) False
A
59. A columnar Form presents a single record at a time. A) True B) False
A
60. Form design can impact user performance. A) True B) False
A
62. The primary difference between the Relational database (RDB) and Object Oriented database (OODB) models is ____________________. A) OODB incorporates methods in with the definition of the data structure, while RDB does not B) OODB supports multiple objects in the same database while RDB only supports a single table per database C) RDB allows the definition of the relationships between the different tables, while OODB does not allow the relationships to be defined between objects D) RDB supports indexes, while OODB does not support indexes
A
63. DBMS stores data efficiently with little wasted space. A) True B) False
A
64. A primary goal of a database system is to share data with multiple users. A) True B) False
A
7. Business rules can be represented in the database through ________________. A) associations (or relationships) B) attributes C) properties D) secondary keys
A
Use the following to answer questions 28-30: 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 1 and Accounting 2). 29. What should the primary key be for the Schedule table? A) CourseNo B) CourseNo & Discipline C) CourseNo, Discipline & Instructor D) You need to add a surrogate key that is an autonumber
A
14. SQL does not permit a given table from being included in a query more than once. A) True B) False
B
18. If a table is in 3NF, it is also in 1NF. A) True B) False
B
2. Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is a _________________. A) data dictionary B) database management system (DBMS) C) decision support system D) relational database
B
21. Not all queries can be constructed in a single SELECT statement. They have to be built up using the results of one query as building blocks for the larger query. What is the term used for these smaller queries that are integrated together to build the final query? A) Schema B) Subquery C) Sub-Schema D) View
B
21. The database design that uses a hierarchical data structure, but incorporates multiple data entry points is called a ________________. A) Hierarchical database B) Network database C) Object oriented database D) Relational database
B
24. A composition association is drawn using which symbol _______________. A) A line which loops back onto the same table B) Small closed diamond at the end of a line connecting two tables C) Small open diamond at the end of a line connecting two tables D) Small triangle at the end of a line connecting the aggregated item and multiple component items
B
3. The term referring to a physical item existing in the real world that you want to track is called ____________________. A) class B) entity C) object D) table
B
31. A Subquery and a View are two terms for the same concept. A) True B) False
B
34. All queries can be designed to avoid subqueries. A) True B) False
B
39. Databases do not have the ability to do numerical calculations. A) True B) False
B
4. The tool which assists in generating input screens is referred to as ____________. A) data dictionary B) forms generator C) input screen tool D) report generator
B
40. Using an ALL operator is an alternative it using a group of OR clauses in a WHERE statement. A) True B) False
B
43. Assume you are dealing with a purchasing database involving a single table. This table contains information on the customer, sale, and items purchased, where the sales order number is the primary key.Using this database design, the system will prevent you from entering any information on new products unless they are involved in a sale. This is an example of ______________. A) a hidden dependency B) an insertion anomaly C) an update anomaly D) referential data integrity
B
44. Most databases allow multiple records that are identical (i.e., records that have the same values for all properties). A) True B) False
B
46. Direct manipulation of objects is a consequence of what advancement in computer systems? A) Faster and more powerful processors B) Increase emphasis of graphical user interfaces C) Increased connectivity through networks D) The world wide web
B
46. One of the first phases of a new database project that involves critical areas, expensive hardware or software within the organization is called ___________. A) analysis phase B) feasibility study C) investigation stage D) system design
B
48. If you wanted to ensure that the title and project name is printed on the top of every page, this information would be placed in ______________. A) detail header B) page header C) report header D) title header
B
5. A good choice for a primary key for the university's student database is the student phone number. A) True B) False
B
5. Which SQL command is used to indicate how tables are linked together? A) GROUP B) JOIN C) LINK D) TABLES
B
55. The process to properly define the database tables to provide flexibility, minimize redundancy, and ensure data integrity is called ___________________. A) class diagram B) data normalization C) database design D) design rationalization
B
56. Which component of the database management system (DBMS) most affects the performance (speed)? A) Data Storage Subsystem B) Database Engine C) Query Processor D) Security Subsystem
B
6. The primary key need not be unique for a given table. A) True B) False
B
60. Aggregation associations are used to convert Many to Many relationships to multiple 1 to Many relationships. A) True B) False
B
65. When building a database, the data dealing with an entity is modeled as a _____ . A) attribute B) class C) object D) table
B
7. Which SQL command would you use to match field values to a template value (i.e., finding all customers with a last name starting with "G")? A) HAVING B) LIKE C) MASK D) STARTS WITH
B
8. In a university database, the normal multiplicity for a relationship between courses and students would be one to many. A) True B) False
B
8. Which SQL command is used to control the order that records are displayed in a query? A) INDEX BY B) ORDER BY C) SELECT BY D) SEQUENCE
B
9. To aggregated data so you can use set-based operations (i.e., COUNT, AVERAGE, MAX, etc.) you would use which SQL command? A) AGGREGATE B) GROUP BY C) ORDER BY D) SUM
B
23. Data integrity constraints are used to _____________________. A) control who is allowed access to the data B) ensure that duplicate records are not entered into the table C) improve the quality of data entered for a specific property (i.e., table column) D) prevent users from changing the values stored in the table
C
25. Referential Integrity Constraints are used to ________________. A) enforce one to many relationships B) enforce the uniqueness of the values entered as primary keys C) ensure that foreign keys can be entered only if the corresponding value exists in the originating table D) ensure that values entered for a certain property (i.e., table column) are appropriate
C
3. What basic question is addressed with the SQL keyword WHERE? A) How are the tables connected together B) What do you already know (or what constraints are given) C) What output do you want to see D) What tables are involved
C
38. The fields in one table that link to the primary key in another table are called _________. A) composite key B) dependent key C) foreign key D) metadata
C
42. A problem created with repeating groups is ___________________. A) creates a deletion anomaly B) creates an update anomaly C) inefficient use of space D) slows down the system
C
42. Which standard user controls on a Control Menu Box allow the user to move the scroll horizontally and vertically within the displayed window? A) Bound controls B) Drag and Drop C) Scroll Bars D) Window option buttons
C
44. When the clicks a ______________, a predefined event is triggered, and some action will be performed. A) bound control B) combo button C) command button D) option button
C
47. If you want to include some introductory material for your report which is only printed once at the front of the document, it would be placed in the __________________. A) page header B) preamble C) report header D) title header
C
48. The property (or set of properties) that uniquely defines each row in a table is called the ___________________. A) identifier B) index C) primary key D) symmetric key
C
57. Two different terms are used to describe the characteristics of interest for an entity. They are attributes and _____________. A) classes B) entities C) properties D) traits
C
59. Data integrity can be improved by which of the following means ____________. A) adding indexes B) entering appropriate terms into the data dictionary C) incorporating business rules when defining the data D) using inheritance
C
61. The role of the query system is to __________________. A) present the data in a user friendly format B) provide data security C) retrieve and manipulate data D) support data integrity
C
9. The term used for the functions and procedures that work on class data is ______. A) Attributes B) Entity C) Methods D) objects
C
Use the following to answer questions 28-30: 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 1 and Accounting 2). 28. Assume you want to add the student roster to the database, capturing which student is enrolled in which course. What is the best way to incorporate this data? A) Add a column in the schedule table for each student (i.e., CourseNo, Discipline, Instructor, Student1, Student2, ... , StudentN) B) Add another table which list the CourseNo, followed by a column for each student (i.e., CourseNo, Student1, Student2, ... , StudentN) C) Add another table with only two columns, CourseNo, StudentID, which is then associated with the Schedule table D) Add another table with Student information including all courses they are taking (i.e., Student(ID, Name, address, (other personal information fields), Course1, Course2, ..., CourseN)
C
Use the following to answer questions 28-30: 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 1 and Accounting 2). 30. Assuming that the appropriate primary key is used in Schedule, what normal form is it in? A) First & Second Normal Form B) First Normal only C) First, Second & third Normal Form D) Second Normal Form only
C
10. Tables in third normal form (3NF) _______________. A) do not have any repeating groups B) eliminate the possibility of a insertion anomalies C) have a composite key D) have all non-key fields depend on nothing but the primary key
D
11. The SQL command TOP is used to ________________________. A) append records to the front of the list B) go to the beginning of the SQL command C) move to the top of the list D) restrict the output to a limited number of record
D
14. Tables in second normal form (2NF) ___________________. A) eliminate all hidden dependencies B) eliminate the possibility of a insertion anomalies C) have a composite key D) have all non-key fields depend on the whole primary key
D
16. Tables in fourth normal form (4NF) if the table is in 3NF and ____________. A) data integrity is enforced B) it contains a composite key C) referential integrity is enforced D) there are no hidden dependencies
D
36. The database design that consists of multiple tables that are linked together through matching data stored in each table is called a ___________________. A) Hierarchical database B) Network database C) Object oriented database D) Relational database
D
41. 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) Clarity or purpose and terminology B) Layout consistency C) Presentation Aesthetics D) Support of multiple users
D
43. The type of form that displays multiple records at a time in rows and columns is called a _______________. A) crosstab form B) spreadsheet form C) switchboard form D) tabular form
D
50. The database model that utilizes multiple tables interconnected through common attributes to store and manage information is called a ______________. A) Class Database B) Matrix Database C) Network Database D) Relational Database
D
6. If you want to get a list of your customers that have purchased from you in the last year, but you only want to list each customer once, how can you prevent multiple listings of the same customer? A) INDEX BY B) ORDER BY C) SELECT BY D) DISTINCT
D
