Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
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
- Correct Answer
- Update
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. 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
- 6. 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
- 7. 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
- 8. 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
- 9. 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
- 10. 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
Database Systems problems
Search Results
Correct Answer: ALTER TRIGGER
Correct Answer: load the software into your micro¬computer
Correct Answer: both (a) and (b)
Correct Answer: Master file
Correct Answer: Data field
Correct Answer: Look-up
Correct Answer: require more disk space than index/report generators
Correct Answer: Hierarchical database
Correct Answer: INSERT
Correct Answer: COMMIT
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.