{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ITE 100 MCQ 1 (1)

A memo c currency b text d object 12 is a common data

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

View Full Document Right Arrow Icon
a. Memo c. Currency b. Text d. Object 12.____ is a common data type that consists of lengthy text entries. a. Numeric c. Currency b. Memo d. Object 13.____ is a common data type that consists of Web addresses that connect to a document or Web page. a. Hyperlink or links c. Yes/No or Boolean b. AutoNumber d. Currency
Background image of page 3

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

View Full Document Right Arrow Icon
14.Users usually add new records to a database ____. a. when a record no longer is needed c. when they obtain new data b. to correct inaccurate data d. to update old data with new data 15.Generally, users change the content of existing records in a file ____. a. when they obtain new data records b. to correct inaccurate data or to update old data with new data c. when a record is no longer needed d. whenever they feel like it 16.____________ a user deletes (the data or the record) from a file. a. To correct inaccurate data, c. To update old data with new data, b. When new data record is obtained, d. When a record no longer is needed, 17.When a program flags a deleted record, the record ____ process it. a. is deleted physically from the disk and is deleted logically because the program will NOT b. is deleted physically from the disk but remains logically because the program will c. remains physically on the disk but is deleted logically because the program will NOT d. remains physically on the disk and remains logically because the program will
Background image of page 4
18.Deleting unneeded files on a hard drive ____ storage space. a. increases the size of individual files and frees up b. increases the size of individual files and increases c. reduces the number of files and reduces available d. increases the amount of available 19.If the lowest monthly fee at a Gold’s Gym fitness center is $49.95 and the highest is $79.95, a(n) ____ on the Monthly Fee field ensures it is a value between $49.95 and $79.95. a. range check c. consistency check b. completeness check d. alphabetic/numeric check 20.A(n) ____ tests the data in two or more associated fields to ensure that the relationship is logical and reasonable. (For example, your graduation date cannot be before your birth date) a. range check c. consistency check b. completeness check d. alphabetic/numeric check 21.A(n) ____ verifies that a required field contains data such as a credit card number. a. range check c. consistency check b. completeness check d. alphabetic/numeric check 22.A check digit is a number or character that is appended to a primary key value. If the primary key is 913457 the two check digits would be _____ and the new primary key would be ________ (Page 523 of textbook) a. 10 91345710 c. 12 91345712 b. 11 91345711 d. 13 91345713
Background image of page 5

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

View Full Document Right Arrow Icon
23. A major weakness of older file processing systems is that ____. a. they have redundant data and they isolate data
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page3 / 10

a Memo c Currency b Text d Object 12 is a common data type...

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

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