Database Systems problems
- 1. 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
Correct Answer: transaction log
- 2. 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
Correct Answer: Insert
- 3. 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
Correct Answer: All of the above
- 4. 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
Correct Answer: CREATE SYNONYM
- 5. 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
Correct Answer: CREATE USER
- 6. 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
Correct Answer: both (a) and (b)
- 7. With respect to data input, the most accurate description of batch control is
Options- A. dividing documents to be entered into batches
- B. controlling the input of each input clerk
- C. comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
- D. All of the above
- E. None of the above Discuss
Correct Answer: comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
- 8. Data security threats include
Options- A. hardware failure
- B. privacy invasion
- C. fraudulent manipulation of data
- D. All of the above
- E. None of the above Discuss
Correct Answer: privacy invasion
- 9. A computer file contains several records. What does each record contain?
Options- A. Bytes
- B. Words
- C. Fields
- D. Database
- E. None of the above Discuss
Correct Answer: Fields
- 10. If you want your database to include methods, you should use a _____ database.
Options- A. Network
- B. Distributed
- C. Hierarchical
- D. Object-Oriented
- E. None of the above Discuss
Correct Answer: Object-Oriented
More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.