Database Systems problems
- 1. Each of data files has a _____ that describe the way the data is stored in the file.
Options- A. File structure
- B. Records
- C. Fields
- D. Database
- E. None of the above Discuss
Correct Answer: File structure
- 2. Which of the following is true of a network structure?
Options- A. It is a physical representation of the data
- B. It allows a many-to-many relationship
- C. It is conceptually simple
- D. It will be the dominant data base of the future
- E. None of the above Discuss
Correct Answer: It allows a many-to-many relationship
- 3. Which of the following is not a logical data-base structure?
Options- A. tree
- B. relational
- C. network
- D. chain
- E. All of the above Discuss
Correct Answer: chain
- 4. The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
Options- A. Bits
- B. Characters
- C. Data field
- D. Schema
- E. None of the above Discuss
Correct Answer: Data field
- 5. A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
Options- A. Specialized file
- B. Log file
- C. Master file
- D. Update file
- E. None of the above Discuss
Correct Answer: Master file
- 6. A form defines
Options- A. where data is placed on the screen
- B. the width of each field
- C. both (a) and (b)
- D. All of the above
- E. None of the above Discuss
Correct Answer: both (a) and (b)
- 7. When using a database management system, the first thing that you must do is to
Options- A. create a database file
- B. activate file editor
- C. load the software into your micro¬computer
- D. keep a floppy disk in readiness
- E. None of the above Discuss
Correct Answer: load the software into your micro¬computer
- 8. In SQL, which command(s) is(are) used to enable/disable a database trigger?
Options- A. MODIFY USER
- B. CHANGE USER
- C. ALTER TRIGGER
- D. All of the above
- E. None of the above Discuss
Correct Answer: ALTER TRIGGER
- 9. After you _____ a record, many data management the environments require you to issue a command to save the changes you made.
Options- A. Delete
- B. Update
- C. Sort key
- D. Index
- E. None of the above Discuss
Correct Answer: Update
- 10. Primitive operations common to all record management systems include
Options- A. Print
- B. Sort
- C. Look-up
- D. All of the above
- E. None of the above Discuss
Correct Answer: Look-up
More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.