Database Systems problems
- 1. Sort/report generators
Options- A. are faster than index/report generators
- B. require more disk space than index/report generators
- C. do not need to sort before generating a report
- D. both (a) and (b)
- E. None of the above Discuss
Correct Answer: require more disk space than index/report generators
- 2. In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
Options- A. Network database
- B. Relational database
- C. Distributed database
- D. Hierarchical database
- E. None of the above Discuss
Correct Answer: Hierarchical database
- 3. In SQL, which command is used to add new rows to a table?
Options- A. ALTER TABLE
- B. ADD ROW
- C. INSERT
- D. APPEND
- E. None of the above Discuss
Correct Answer: INSERT
- 4. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
Options- A. ZIP
- B. PACK
- C. COMMIT
- D. SAVE
- E. None of the above Discuss
Correct Answer: COMMIT
- 5. The highest level in the hierarchy of data organization is called
Options- A. data bank
- B. database
- C. data file
- D. data record
- E. None of the above Discuss
Correct Answer: database
- 6. A network schema
Options- A. restricts the structure to a one-to-many relationship
- B. permits many-to-many relationŽships
- C. stores data in tables
- D. All of the above
- E. None of the above Discuss
Correct Answer: permits many-to-many relationŽships
- 7. If you want to group the records in the abc database, you could use the Jobcode as the _____.
Options- A. Delete
- B. Update
- C. Sort Key
- D. Index
- E. None of the above Discuss
Correct Answer: Sort Key
- 8. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
Options- A. ALTER TRIGGERS
- B. ALTER TABLE
- C. MODIFY TRIGGERS IN TABLE
- D. All of the above
- E. None of the above Discuss
Correct Answer: ALTER TABLE
- 9. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
Options- A. Full media
- B. Graphics media
- C. Multimedia
- D. Hypertext
- E. None of the above Discuss
Correct Answer: Multimedia
- 10. A number of related records that are treated as a unit is called
Options- A. file
- B. field
- C. data
- D. batch
- E. None of the above Discuss
Correct Answer: file
More in Computer Science:
Programming
Copyright ĐCuriousTab. All rights reserved.