Database Systems problems
- 1. What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
Options- A. Special purpose packages
- B. Custom made programs
- C. Single function application packages
- D. Data management packages
- E. None of the above Discuss
Correct Answer: Data management packages
- 2. The _____ command is used to allocates an extent for the table in SQL
Options- A. MODIFY ALLOCATES
- B. MODIFY TABLE
- C. ALTER TABLE
- D. REDEFINE TABLE
- E. None of the above Discuss
Correct Answer: MODIFY ALLOCATES
- 3. Data encryption techniques are particularly useful for
Options- A. reducing storage space requirements
- B. improving data integrity
- C. protecting data in data communication systems
- D. All of the above
- E. None of the above Discuss
Correct Answer: protecting data in data communication systems
- 4. In order to use a record management system
Options- A. You need to understand the low-level details of how information in stored
- B. You need to understand the model the record management system uses.
- C. Both (a) and (b)
- D. All of the above
- E. None of the above Discuss
Correct Answer: You need to understand the model the record management system uses.
- 5. A logical schema
Options- A. is the entire database
- B. is a standard way of organizing information into accessible parts
- C. describes how data is actually stored on disk
- D. All of the above
- E. None of the above Discuss
Correct Answer: is a standard way of organizing information into accessible parts
- 6. The activity of a file
Options- 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. Discuss
Correct Answer: is a low percentages of number of records added or deleted from a file
- 7. Data items grouped together for storage purposes are called a
Options- A. record
- B. title
- C. list
- D. string
- E. None of the above Discuss
Correct Answer: record
- 8. A multiple-form file management system
Options- 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 Discuss
Correct Answer: both (a) and (b)
- 9. A file that is organized in uniform format is formally referred to as a _____ or a database file.
Options- A. Document
- B. Database
- C. Record
- D. Structured data file
- E. None of the above Discuss
Correct Answer: Structured data file
- 10. It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
Options- A. Database
- B. Table
- C. Record
- D. Flat File
- E. None of the above Discuss
Correct Answer: Database
More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.