Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
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
- Correct Answer
- ALTER TRIGGER
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. A _____ means that one record in a particular record type is related to only 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
- 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
- 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
- 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
- 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
- 10. The distinguishable parts of a record are called
Options- A. files
- B. data
- C. fields
- D. database
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: data field
Correct Answer: on demand report
Correct Answer: treelike structure
Correct Answer: processing functions
Correct Answer: One-to-one relationship
Correct Answer: they have a field in common
Correct Answer: BPL
Correct Answer: UPDATE
Correct Answer: Two concurrent activities interact to cause a processing error
Correct Answer: fields
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.