1. In SQL, the CREATE VIEW command is used
A. to recompile view
B. to define a view of one or more tables or views
C. to recompile a table
D. to create a trigger
E. None of the above
Answer: B
2. A ____ contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
A. File structure
B. Records
C. Fields
D. Database
E. None of the above
Answer: C
3. In the DBM approach, application programs perform the
A. storage function
B. processing functions
C. access control
D. All of the above
E. None of the above
Answer: B
4. In SQL, which command is used to create a database user?
A. ADD USER TO DATABASE
B. MK USER
C. CREATE USER
D. All of the above
E. None of the above
Answer: C
5. When performing a look-up operation using a form
A. you enter the search value into the form
B. you look at each form sequentially until you see the one you want
C. you type the key in an entry line, and the correct form is displayed
D. All of the above
E. None of the above
Answer: A
6. A _____ means that one record in a particular record type is related to only one record of another record type.
A. One-to-one relationship
B. One-to-many relationship
C. Many-to-one relationship
D. Many-to-many relationship
E. None of the above
Answer: A
7. A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
A. Network
B. Hierarchical
C. Relational
D. Object-Oriented
E. None of the above
Answer: C
8. In SQL, which command(s) is(are) used to redefine an index's future storage allocation
A. ALTER INDEX
B. REDEFINE INDEX
C. MODIFY INDEX
D. DO INDEX
E. None of the above
Answer: A
9. Which of the following is a serious problem of file management systems?
A. difficult to update
B. lack of data independence
C. data redundancy
D. program dependence
E. All of the above
Answer: E
10. 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. All of the above
E. None of the above
Answer: C
11. The model for a _____ resembles the hierarchical model in many respects.
A. Network database
B. Relational database
C. Distributed database
D. Hierarchical database
E. None of the above
Answer: A
12. A set of programs that handle a firm's data base responsibilities is called a
A. Data Base Management System (DBMS)
B. Data Base Processing System (DBPS)
C. Data Management System (DMS)
D. All of the above
E. None of the above
Answer: D
13. In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
A. data field
B. data record
C. data file
D. database
E. None of the above
Answer: A
14. Long-range planning report produced in an MIS are primarily designed for
A. top management
B. middle management
C. lower management
D. All of the above
E. None of the above
Answer: A
15. The model for a record management system might be
A. handwritten list
B. a Rolodex card file
C. a business form
D. All of the above
E. None of the above
Answer: D
16. The designer of a form includes
A. filed designators
B. prompts
C. data
D. both (a) and (b)
E. None of the above
Answer: D
17. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
A. report writer
B. query language
C. data manipulation language
D. transaction log
E. None of the above
Answer: D
18. Two files may be joined into a third file if
A. they have a row in common
B. they have a field in common
C. they have no records with the same value in the common field
D. both (b) and (c)
E. None of the above
Answer: B
19. Characteristic(s) of a distributed MIS structure is
A. interactive sharing of the workload
B. a multiprocessing environment
C. computers supporting local DP operations
D. All of the above
E. None of the above
Answer: D
20. The data-base environment has all of the following components except:
A. users
B. separate files
C. data base
D. data-base administrator
E. None of the above
Answer: B
21. The way a particular application views the data from the data base that the application uses is a :
A. module
B. relational model
C. schema
D. subschema
E. None of the above
Answer: D
22. A compound key
A. is made up a several pieces of information
B. uniquely identifies an item in a list
C. both (a) and (b)
D. is a combination of each unique key
E. None of the above
Answer: C
23. The distinguishable parts of a record are called
A. files
B. data
C. fields
D. database
E. None of the above
Answer: C
24. Large collections of files are called
A. fields
B. records
C. databases
D. file system
E. None of the above
Answer: C
25. The index consists of
A. a list of keys
B. pointers to the master list
C. both (a) and (b)
D. All of the above
E. None of the above
Answer: C
| < Prev | Next > |
|---|