Database Systems problems
- 1. The language used in application programs to request data from the DBMS is referred to as the
Options- A. DML
- B. DDL
- C. query language
- D. All of the above
- E. None of the above Discuss
Correct Answer: DML
- 2. In SQL, the ALTER TABLESPACE command is used
Options- A. to add/rename data files
- B. to change storage characteristics
- C. to take a tablespace online/offline
- D. to begin/end a backup
- E. All of the above Discuss
Correct Answer: All of the above
- 3. Characteristic(s) of a distributed MIS structure is
Options- A. interactive sharing of the workload
- B. a multiprocessing environment
- C. computers supporting local DP operations
- D. All of the above
- E. None of the above Discuss
Correct Answer: All of the above
- 4. A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
Options- A. File structure
- B. Records
- C. Fields
- D. Database
- E. None of the above Discuss
Correct Answer: Fields
- 5. A _____ means that one record in a particular record type may be related to more than one record of another record type.
Options- A. One-to-one relationship
- B. One-to-many relationship
- C. Many-to-one relationship
- D. Many-to many relationship
- E. None of the above Discuss
Correct Answer: One-to-many relationship
- 6. In SQL, which command is used to add a column/integrity constraint to a table
Options- A. ADD COLUMN
- B. INSERT COLUMN
- C. MODIFY TABLE
- D. ALTER TABLE
- E. None of the above Discuss
Correct Answer: ALTER TABLE
- 7. An indexing operation
Options- A. sorts a file using a single key
- B. sorts file using two keys
- C. establishes an index for a file
- D. both (b) and (c)
- E. None of the above Discuss
Correct Answer: establishes an index for a file
- 8. In a large DBMS
Options- A. each user can "see" only a small part of the entire database
- B. each user can access every sub¬schema
- C. each subschema contains every field in the logical schema
- D. All of the above
- E. None of the above Discuss
Correct Answer: each user can "see" only a small part of the entire database
- 9. The designer of a form includes
Options- A. filed designators
- B. prompts
- C. data
- D. both (a) and (b)
- E. None of the above Discuss
Correct Answer: both (a) and (b)
- 10. An audit trail
Options- A. is used to make back-up copies
- B. is the recorded history of operations performed on a file
- C. can be used to restore lost information
- D. All of the above
- E. None of the above Discuss
Correct Answer: is the recorded history of operations performed on a file
More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.