Practice Test: Question Set - 04
1. Data integrity control
- (A) Is used to
set upper and lower limits on numeric data
- (B) Requires the
use of passwords to prohibit unauthorized access to the file
- (C) Has the data
dictionary keep the date and time of last access last back-up, and most recent
modification for all files
- (D) None of the
above
2. Embedded pointer provide
- (A) A secondary
access path
- (B) A physical
record key
- (C) An inverted
index
- (D) All of the
above
3. The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
- (A) Bits
- (B) Characters
- (C) Data field
- (D) Schema
4. A computer file contains several records. What does each record contain?
- (A) Bytes
- (B) Words
- (C) Fields
- (D) Database
5. In order to use a record management system
- (A) You need to
understand the low-level details of how information in stored
- (B) You need to
understand the model the record management system uses
- (C) Both (a) and
(b)
- (D) None of the
above
6. In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
- (A) CREATE
PACKAGE
- (B) CREATE
SCHEMA
- (C) CREATE
CLUSTER
- (D) None of the
above
7. A _________ Contains fields of data about one entity.
- (A) Record
- (B) File
- (C) Fields
- (D) Document
8. In SQL, the ALTER TABLESPACE command is used
- (A) To
add/rename data files
- (B) To change
storage characteristics
- (C) To take a
table space online/offline
- (D) All of the
above
9. In SQL, which command(s) is(are) used to recompile a stored function?
- (A) SET FUNCTION
- (B) SET STORED
FUNCTION
- (C) ALTER
FUNCTION
- (D) All of the
above
10. Which of the following is not a relational database?
- (A) dBASE IV
- (B) 4th
Dimension
- (C) FoxPro
- (D) Reflex
11. Which of the following is a database administrator's function?
- (A) Database
design
- (B) Backing up
the database
- (C) Performance
monitoring
- (D) All of the
above
12. 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
13. The PROJECT command will create new table that has
- (A) More fields
than the original table
- (B) More rows
than the original table
- (C) Both (a) and
(b)
- (D) None of the
above
14. A logical schema
- (A) Is the
entire database
- (B) Is a
standard way of organizing information into accessible parts
- (C) Describes
how data is actually stored on disk
- (D) None of the
above
15. A compound key
- (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
Next Tests:
Blogger Comment
Facebook Comment