Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
Periodically adding, changing and deleting file records is called file
Options- A. Updating
- B. upgrading
- C. restructuring
- D. renewing
- E. None of the above
- Correct Answer
- Updating
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. 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 Discuss
- 6. A file produced by a spreadsheet
Options- A. is generally stored on disk in an ASCII text format
- B. can be used as it by the DBMS
- C. can be used for graphic
- D. All of the above
- E. None of the above Discuss
- 7. The data dictionary tells the DBMS
Options- A. what files are in the database
- B. what attribute are possessed by the data
- C. what these files contain
- D. All of the above
- E. None of the above Discuss
- 8. Updating a database means
Options- A. revising the file structure
- B. reorganizing the database
- C. modifying or adding record occurrences
- D. All of the above
- E. None of the above Discuss
- 9. What is the language used by most of the DBMSs for helping their users to access data?
Options- A. High level language
- B. Query language
- C. SQL
- D. 4GL
- E. None of the above Discuss
- 10. Which of the following hardware components is the most important to the operation of a database management system?
Options- A. high-resolution video display
- B. printer
- C. high speed, large-capacity disk
- D. plotter
- E. mouse Discuss
Database Systems problems
Search Results
Correct Answer: DROP TABLE
Correct Answer: both (a) and (b)
Correct Answer: All of the above
Correct Answer: only one owner but many owner occurrences
Correct Answer: print files on paper
Correct Answer: is generally stored on disk in an ASCII text format
Correct Answer: All of the above
Correct Answer: modifying or adding record occurrences
Correct Answer: Query language
Correct Answer: high speed, large-capacity disk
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.