Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
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
- Correct Answer
- Two concurrent activities interact to cause a processing error
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. 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
- 6. The distinguishable parts of a record are called
Options- A. files
- B. data
- C. fields
- D. database
- E. None of the above Discuss
- 7. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
Options- A. report writer
- B. query language
- C. data manipulation language
- D. transaction log
- E. None of the above Discuss
- 8. An operation that will increase the length of a list is
Options- A. Insert
- B. Look-up
- C. Modify
- D. All of the above
- E. None of the above Discuss
- 9. A set of programs that handle a firm's data base responsibilities is called a
Options- A. Data Base Management System (DBMS)
- B. Data Base Processing System (DBPS)
- C. Data Management System (DMS)
- D. All of the above
- E. None of the above Discuss
- 10. In SQL, which command(s) is(are) used to create a synonym for a schema object?
Options- A. CREATE SCHEMA
- B. CREATE SYNONYM
- C. CREATE SAME
- D. All of the above
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: UPDATE
Correct Answer: BPL
Correct Answer: they have a field in common
Correct Answer: ALTER TRIGGER
Correct Answer: data field
Correct Answer: fields
Correct Answer: transaction log
Correct Answer: Insert
Correct Answer: All of the above
Correct Answer: CREATE SYNONYM
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.