Database Systems problems
- 1. In the DBM approach, application programs perform the
Options- A. storage function
- B. processing functions
- C. access control
- D. All of the above
- E. None of the above Discuss
Correct Answer: processing functions
- 2. Which of the following is not characteristic of a relational database model?
Options- A. tables
- B. treelike structure
- C. complex logical relationships
- D. records
- E. None of the above Discuss
Correct Answer: treelike structure
- 3. The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a
Options- A. forecasting report
- B. exception report
- C. regularly scheduled report
- D. on demand report
- E. None of the above Discuss
Correct Answer: on demand report
- 4. In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
Options- A. data field
- B. data record
- C. data file
- D. database
- E. None of the above Discuss
Correct Answer: data field
- 5. In SQL, which command(s) is(are) used to enable/disable a database trigger?
Options- A. ALTER TRIGGER
- B. ALTER DATABASE
- C. ALTER TABLE
- D. MODIFY TRIGGER
- E. All of the above Discuss
Correct Answer: ALTER TRIGGER
- 6. Two files may be joined into a third file if
Options- A. they have a row in common
- B. they have a field in common
- C. they have no records with the same value in the common field
- D. both (b) and (c)
- E. None of the above Discuss
Correct Answer: they have a field in common
- 7. A database management system might consist of application programs and a software package called
Options- A. FORTRAN
- B. AUTOFLOW
- C. BPL
- D. TOTAL
- E. None of the above Discuss
Correct Answer: BPL
- 8. In SQL, which command is used to changes data in a table?
Options- A. UPDATE
- B. INSERT
- C. BROWSE
- D. APPEND
- E. None of the above Discuss
Correct Answer: UPDATE
- 9. A race condition occurs when
Options- A. Two concurrent activities interact to cause a processing error
- B. two users of the DBMS are interacting with different files at the same time
- C. both (a) and (b)
- D. All of the above
- E. None of the above Discuss
Correct Answer: Two concurrent activities interact to cause a processing error
- 10. The distinguishable parts of a record are called
Options- A. files
- B. data
- C. fields
- D. database
- E. None of the above Discuss
Correct Answer: fields
More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.