Practice Test: Question Set - 10
1. Which of the following hardware components is the most important to the operation of a database management system?
- (A) High-resolution
video display
- (B) Printer
- (C) High
speed, large-capacity disk
- (D) Plotter
2. In SQL, GRANT command is used to
- (A) Allow
user to access databases
- (B) Allow
user to create databases
- (C) Grant
system privileges, roles, and object privileges to uses and roles
- (D) Choose
auditing for specific SQL commands
3. In SQL, which command is used to select data in rows and column from one or more tables?
- (A) CHOOSE
- (B) SELECT
- (C) LIST
- (D) BROWSE
4. After you _______ a record, many data management the environments require you to issue a command to save the changes you made.
- (A) Delete
- (B) Update
- (C) Sort key
- (D) Index
5. 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) None of the
above
6. Batch processing is appropriate if
- (A) A large
computer system is available
- (B) Only a small
computer system is available
- (C) Only a few
transactions are involved
- (D) None of the
above
7. Characteristic(s) of a distributed MIS structure is
- (A) Interactive
sharing of the workload
- (B) A
multiprocessing environment
- (C) Computers
supporting local DP operations
- (D) All of the
above
8. A file that is organized in uniform format is formally referred to as a _______ or a database file.
- (A) Document
- (B) Database
- (C) Record
- (D) Structured
data file
9. A set of programs that handle a firm's data base responsibilities is called a
- (A) Data Base
Management System (DBMS)
- (B) Data Base
Processing System (DBPS)
- (C) Data
Management System (DMS)
- (D) All of the
above
10. A top-to-bottom relationship among the items in a database is established by a
- (A) Hierarchical
schema
- (B) Network
schema
- (C) Relational
schema
- (D) None of the
above
11. A condition that led to the development of databases was
- (A) A demand for
more data to support information needs
- (B) An increase
in the amount of data handled by organizations
- (C) The
proliferation of data files
- (D) All of the
above
12. In SQL, the CREATE TABLESPACE is used
- (A) To create a
place in the database for storage of scheme objects, rollback segments, and
naming the data files to comprise the table-space
- (B) To create a
database trigger
- (C) To
add/rename data files, to change storage
- (D) All of the above
13. In SQL, the CREATE TABLE is used
- (A) To create a
table, defining its columns, integrity constrains, and storage allocation
- (B) To add a
column/integrity constraint to a table
- (C) To redefine
a column
- (D) To change a
table's storage characteristics
14. The model for a record management system might be
- (A) Handwritten
list
- (B) A Rolodex
card file
- (C) A business
form
- (D) All of the
above
15. In SQL, the ________ command is used to recompile a view
- (A) COMPILE VIEW
- (B) DEFINE VIEW
- (C) CREATE VIEW
- (D) ALTER VIEW
Next Tests: