Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
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
- Correct Answer
- transaction log
- 1. The distinguishable parts of a record are called
Options- A. files
- B. data
- C. fields
- D. database
- E. None of the above Discuss
- 2. 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
- 3. 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
- 4. 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
- 5. 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
- 6. 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
- 7. 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
- 8. 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
- 9. In SQL, which command is used to create a database user?
Options- A. ADD USER TO DATABASE
- B. MK USER
- C. CREATE USER
- D. All of the above
- E. None of the above Discuss
- 10. A compound key
Options- A. is made up a several pieces of information
- B. uniquely identifies an item in a list
- C. both (a) and (b)
- D. is a combination of each unique key
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: fields
Correct Answer: Two concurrent activities interact to cause a processing error
Correct Answer: UPDATE
Correct Answer: BPL
Correct Answer: they have a field in common
Correct Answer: Insert
Correct Answer: All of the above
Correct Answer: CREATE SYNONYM
Correct Answer: CREATE USER
Correct Answer: both (a) and (b)
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.