Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
A report generator is used to
Options- A. update files
- B. print files on paper
- C. data entry
- D. All of the above
- E. None of the above
- Correct Answer
- print files on paper
- 1. Which command is used to remove an index from the database in SQL?
Options- A. DELETE INDEX
- B. DROP INDEX
- C. REMOVE INDEX
- D. ROLL BACK INDEX
- E. None of the above Discuss
- 2. When you have finished entering information into a form
Options- A. the template is written to the data file
- B. the contents of the form are written to the data file
- C. the contents of the form can be printed
- D. All of the above
- E. None of the above Discuss
- 3. If the record management system allows you to edit values before they are recorded on disk, you can
Options- A. correct spelling changes before they are recorded
- B. change the name of a field
- C. change the width of a field
- D. All of the above
- E. None of the above Discuss
- 4. If a calculation is embedded in a form
Options- A. the result of the calculations are stored with the form
- B. the calculations are stored with the form
- C. the result of the calculations are printed in report
- D. All of the above
- E. None of the above Discuss
- 5. A top-to-bottom relationship among the items in a database is established by a
Options- A. Hierarchical schema
- B. Network schema
- C. Relational schema
- D. All of the above
- E. None of the above Discuss
- 6. An-owner-member set in the CODASYL specifications may have
Options- A. only one owner but many owner occurrences
- B. only one member but many member occurrence
- C. more than one member but only one occurrence per member
- D. All of the above
- E. None of the above Discuss
- 7. Sophisticated report generators can
Options- A. print row-oriented reports
- B. perform arithmetic operations
- C. selectively retrieve and print portions of a list
- D. All of the above
- E. None of the above Discuss
- 8. A database management system
Options- A. allows simultaneous access to multiple files
- B. can do more than a record management system
- C. is a collection of programs for managing data in a single file
- D. both (a) and (b)
- E. None of the above Discuss
- 9. Which command is used to remove a table from the database in SQL?
Options- A. DELETE TABLE
- B. DROP TABLE
- C. ERASE TABLE
- D. UNATTACH TABLE
- E. None of the above Discuss
- 10. Periodically adding, changing and deleting file records is called file
Options- A. Updating
- B. upgrading
- C. restructuring
- D. renewing
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: DROP INDEX
Correct Answer: the contents of the form are written to the data file
Correct Answer: correct spelling changes before they are recorded
Correct Answer: the calculations are stored with the form
Correct Answer: Hierarchical schema
Correct Answer: only one owner but many owner occurrences
Correct Answer: All of the above
Correct Answer: both (a) and (b)
Correct Answer: DROP TABLE
Correct Answer: Updating
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.