Database Systems problems
- 1. A report form
Options- 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 Discuss
Correct Answer: is used during report generation to format data
- 2. A form can be used to
Options- A. modify records
- B. delete records
- C. format printed output
- D. All of the above
- E. None of the above Discuss
Correct Answer: All of the above
- 3. A _____ Contains fields of data about one entity.
Options- A. Record
- B. File
- C. Fields
- D. Document
- E. None of the above Discuss
Correct Answer: Record
- 4. One data dictionary software package is called
Options- A. DB/DC dictionary
- B. TOTAL
- C. ACCESS
- D. any of the above
- E. None of the above Discuss
Correct Answer: DB/DC dictionary
- 5. Batch processing is appropriate if
Options- A. a large computer system is available
- B. only a small computer system is available
- C. only a few transactions are involved
- D. All of the above
- E. None of the above Discuss
Correct Answer: None of the above
- 6. What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
Options- A. DASD
- B. FMS
- C. EMMS
- D. DBMS
- E. None of the above Discuss
Correct Answer: DBMS
- 7. Queries to a database
Options- A. are written in English
- B. can use aggregate functions like SUM and COUNT
- C. both (a) and (b)
- D. All of the above
- E. None of the above Discuss
Correct Answer: can use aggregate functions like SUM and COUNT
- 8. Related fields in a data base are grouped to form
Options- A. data file
- B. data record
- C. menu
- D. bank
- E. None of the above Discuss
Correct Answer: data record
- 9. A good query system
Options- 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 Discuss
Correct Answer: allows non-programmers to access information stored in a database
- 10. A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
Options- 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 Discuss
Correct Answer: Many-to-many relationship
More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.