3024.S09.T1.KEY

3024.S09.T1.KEY - ISE 3024 Data Management for IEs, S09 -...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 ISE 3024 Data Management for IEs Name (print): Spring 2009 Test #1 Closed Book, Closed Notes (one 8.5 x 11 in. sheet allowed) PART I – Multiple Choice. CIRCLE the single BEST answer for each problem (10 x 2.5 = 25 pts.) 1. Which of the following would be a good choice for a computerized file-based system? a) Relationships exist between the various data items. b) Main need is for single-file queries. c) Multiple users need to access the data at the same time. d) Main need is for cross-referenced queries. 2. What can you do in Excel to prevent a user from deleting the active worksheet? a) Protect the worksheet. b) Protect the workbook windows. c) Protect the workbook structure. d) Tell the worker he/she will be in big trouble if they delete the worksheet. 3. How should null values be employed in a database design? a) Use as little as possible, to reduce confusion and ambiguity. b) Use whenever possible, in order to reduce the amount of computer memory needed. c) Use whenever possible, to reduce data entry time. d) Use as little as possible, to keep the user active. 4. Which of the following is not a good approach for dealing with macro security? a) Put the macros in a trusted location (directory). b) Enable all macros. c) Disable macros, but let the user decide whether to allow them to run or not. d) Only allow ‘secure’ macros (e.g., digital signature) to run. 5. Attributes for which the values can be calculated from other existing, stored values are known as a) Discriminators. b) Key attributes. c) Multivalued attributes. d) Derived attributes. Signature:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ISE 3024 Data Management for IEs, S’09 - Test #1 2 6. Which of the following is often referred to as the “blueprint” for a database design? a) Relational schema b) Conceptual schema c) External schema d) Logical model 7. Which of the following is a good rule to remember when establishing primary and secondary keys for an entity class? a) Single-attribute primary key, single-attribute secondary key. b) Multiple-attribute primary key, multi-valued, single-attribute secondary key. c) Make the primary and secondary key the same thing. d) Single-attribute primary key, secondary key attribute values easy to remember. 8. Say you have an Excel file having annual sales ($) for each store of a large retail chain, along with each store’s type (A, B, or C) and state where located. What is the best way to show the annual sales for each store type in each state?
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/22/2010 for the course ISE 3024 taught by Professor Staff during the Spring '08 term at Virginia Tech.

Page1 / 6

3024.S09.T1.KEY - ISE 3024 Data Management for IEs, S09 -...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online