1. Data security threats include
A. hardware failure
B. privacy invasion
C. fraudulent manipulation of data
D. All of the above
E. None of the above
Answer: B
2. An operation that will increase the length of a list is
A. Insert
B. Look-up
C. Modify
D. All of the above
E. None of the above
Answer: A
3. In SQL, which command is used to add a column/integrity constraint to a table
A. ADD COLUMN
B. INSERT COLUMN
C. MODIFY TABLE
D. ALTER TABLE
E. None of the above
Answer: D
4. In SQL, which command(s) is(are) used to enable/disable a database trigger?
A. ALTER TRIGGER
B. ALTER DATABASE
C. ALTER TABLE
D. MODIFY TRIGGER
E. All of the above
Answer: A
5. In a relational schema, each tuple is divided into fields called
A. Relations
B. Domains
C. Queries
D. All of the above
E. None of the above
Answer: B
6. In SQL, which command is used to changes data in a table?
A. UPDATE
B. INSERT
C. BROWSE
D. APPEND
E. None of the above
Answer: A
7. What name is given to the collection of facts, items of information or data which are related in some way?
A. Database
B. Directory information
C. Information tree
D. Information provider
E. None of the above
Answer: A
8. In a large DBMS
A. each user can "see" only a small part of the entire database
B. each user can access every sub-schema
C. each subschema contains every field in the logical schema
D. All of the above
E. None of the above
Answer: A
9. Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
A. COMPILE PROCEDURE
B. ALTER PROCEDURE
C. MODIFY PROCEDURE id) All of the above
D. None of the above
Answer: B
10. Internal auditors should review data system design before they are
A. developed
B. implemented
C. modified
D. All of the above
E. None of the above
Answer: D
11. A _____ means that one record in a particular record type may be related to more than one record of another record type.
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
Answer: B
12. Which command(s) is(are) used to redefine a column of the table in SQL ?
A. ALTER TABLE
B. DEFINE TABLE
C. MODIFY TABLE
D. All of the above
E. None of the above
Answer: A
13. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
A. DEFINE TABLE
B. MODIFY TABLE
C. ALTER TABLE
D. All of the above
E. None of the above
Answer: C
14. In SQL, the ALTER TABLESPACE command is used
A. to add/rename data files
B. to change storage characteristics
C. to take a tablespace online/offline
D. to begin/end a backup
E. All of the above
Answer: E
15. The language used in application programs to request data from the DBMS is referred to as the
A. DML
B. DDL
C. query language
D. All of the above
E. None of the above
Answer: A
16. A database management system might consist of application programs and a software package called
A. FORTRAN
B. AUTOFLOW
C. BPL
D. TOTAL
E. None of the above
Answer: C
17. An audit trail
A. is used to make back-up copies
B. is the recorded history of operations performed on a file
C. can be used to restore lost information
D. All of the above
E. None of the above
Answer: B
18. A race condition occurs when
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
Answer: A
19. An indexing operation
A. sorts a file using a single key
B. sorts file using two keys
C. establishes an index for a file
D. both (b) and (c)
E. None of the above
Answer: C
20. The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a
A. forecasting report
B. exception report
C. regularly scheduled report
D. on demand report
E. None of the above
Answer: D
21. In SQL, which command(s) is(are) used to create a synonym for a schema object?
A. CREATE SCHEMA
B. CREATE SYNONYM
C. CREATE SAME
D. All of the above
E. None of the above
Answer: B
22. If you want your database to include methods, you should use a _____ database.
A. Network
B. Distributed
C. Hierarchical
D. Object-Oriented
E. None of the above
Answer: D
23. In SQL, which of the following is not a data Manipulation Language Commands?
A. DELETE
B. SELECT
C. UPDATE
D. CREATE
E. None of the above
Answer: D
24. Which of the following is not characteristic of a relational database model?
A. tables
B. treelike structure
C. complex logical relationships
D. records
E. None of the above
Answer: B
25. A computer file contains several records. What does each record contain?
A. Bytes
B. Words
C. Fields
D. Database
E. None of the above
Answer: C
| < Prev | Next > |
|---|