A report form
A. appears on the computer monitor during data entry
B. is used during report generation to format data
C. both (a) and (b)
D. All of the above
E. None of the above
Select an option to see the answer and solution.
A computer file can be best described as
A. a single data item
B. a general collection of data items
C. an orderly collection of data items
D. a random collection of data items
E. None of the above
Select an option to see the answer and solution.
A good query system
A. can accept English language commands
B. allows non-programmers to access information stored in a database
C. can be accessed only by data processing professionals
D. both (a) and (b)
E. None of the above
Select an option to see the answer and solution.
If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
A. Delete
B. Update
C. Sort Key
D. Index
E. None of the above
Select an option to see the answer and solution.
The modify operation is likely to be done after
A. Delete
B. Look-up
C. Insert
D. All of the above
E. None of the above
Select an option to see the answer and solution.
One data dictionary software package is called
A. DB/DC dictionary
B. TOTAL
C. ACCESS
D. any of the above
E. None of the above
Select an option to see the answer and solution.
One approach to standardizing storing of data
A. MIS
B. structured programming
C. CODASYL specifications
D. All of the above
E. None of the above
Select an option to see the answer and solution.
What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
A. Special purpose packages
B. Custom made programs
C. Single function application packages
D. Data management packages
E. None of the above
Select an option to see the answer and solution.
A multiple-form file management system
A. lets you define different forms for different operations
B. lets you create a look-up form with an associated read-only password to prevent access by unauthorized users
C. both (a) and (b)
D. allow you to entry data in all the forms
E. None of the above
Select an option to see the answer and solution.
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
E. None of the above
Select an option to see the answer and solution.
A _____ Contains fields of data about one entity.
A. Record
B. File
C. Fields
D. Document
E. None of the above
Select an option to see the answer and solution.
A condition that led to the development of databases was
A. a demand for more data to support information needs
B. an increase in the amount of data handled by organizations
C. the proliferation of data files
D. All of the above
E. None of the above.
Select an option to see the answer and solution.
The _____ command is used to allocates an extent for the table in SQL
A. MODIFY ALLOCATES
B. MODIFY TABLE
C. ALTER TABLE
D. REDEFINE TABLE
E. None of the above
Select an option to see the answer and solution.
Embedded pointer provide
A. a secondary access path
B. a physical record key
C. an inverted index
D. All of the above
E. None of the above
Select an option to see the answer and solution.
Which of the following is a type of DBMS software?
A. database manipulation language
B. query language
C. utilities
D. report writer
E. All of the above
Select an option to see the answer and solution.
Data items grouped together for storage purposes are called a
A. record
B. title
C. list
D. string
E. None of the above
Select an option to see the answer and solution.
The activity of a file
A. is a low percentages of number of records added or deleted from a file
B. if high, reduces processing efficiency for sequential and nonsequential files
C. is a measure of the percentage of existing records updated during a run
D. refers to how closely the files fits into the allocated
E. None of the above.
Select an option to see the answer and solution.
Versatile report generators can provide
A. Columnar totals
B. Subtotals
C. Calculations
D. All of the above
E. None of the above
Select an option to see the answer and solution.
Related fields in a data base are grouped to form
A. data file
B. data record
C. menu
D. bank
E. None of the above
Select an option to see the answer and solution.
A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
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
Select an option to see the answer and solution.