Practice Test: Question Set - 11
1. The term ________ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
- (A) Database
- (B) Table
- (C) Flat file
- (D) Data
structure
2. With respect to data input, the most accurate description of batch control is
- (A) Dividing
documents to be entered into batches
- (B) Controlling
the input of each input clerk
- (C) Comparing to
a pre-calculated figure the total of a data item summed across a batch records
put into the system
- (D) None of the
above
3. A data dictionary is a special file that contains
- (A) The names of
all fields in all files
- (B) The data
types of all fields in all files
- (C) The widths
of all fields in all files
- (D) All of the
above
4. Which of the following is not a Storage Manager Component?
- (A) Transaction
Manager
- (B) Logical
Manager
- (C) Buffer
Manager
- (D) File Manager
5. Which of the following is not a Schema?
- (A) Database
Schema
- (B) Physical
Schema
- (C) Critical
Schema
- (D) Logical
Schema
6. Who proposed the relational model?
- (A) Bill Gates
- (B) E.F. Codd
- (C) Herman
Hollerith
- (D) Charles
Babbage
7. In an Entity-Relationship Diagram “Ellipses” represents
- (A) Attributes
- (B) Weak entity
set
- (C) Relationship
sets
- (D) Multi-valued
Attributes
8. Which of the following is an unary operation?
- (A) Selection
operation
- (B) Generalized
selection
- (C) Primitive
operation
- (D) Projection
operation
9. A table that displays data redundancies yields _________ anomalies
- (A) Insertion
- (B) Deletion
- (C) Update
- (D) All
of the above
10. In SQL, the command(s) is(are) used to create an index for a table or cluster
- (A) CREATE INDEX
- (B) MODIFY
INDEX
- (C) SET INDEX TO
FILE
- (D) All of the
above
11. The index consists of
- (A) A list of
keys
- (B) Pointers to
the master list
- (C) Both (a) and
(b)
- (D) None of the
above
12. If a piece of data is stored in two places in the database, then
- (A) Storage
space is wasted
- (B) Changing the
data is one spot will cause data inconsistency
- (C) It can be
more easily accessed
- (D) Both (a) and
(b)
13. The Management Information system (MIS) structure with one main computer system is called a
- (A) Hierarchical
MIS structure
- (B) Distributed
MIS structure
- (C) Centralized
MIS structure
- (D) Decentralized
MIS structure
14. Data item characteristics that are important in data management include
- (A) Punctuation
- (B) Language
- (C) Spelling
- (D) Width
15. If you want to group the records in the abc database, you could use the Job code as the _________.
- (A) Delete
- (B) Update
- (C) Sort Key
- (D) Index
Next Tests:
Blogger Comment
Facebook Comment