Practice Test: Question Set - 09
1. A good query system
- (A) Can accept
English language commands
- (B) Allows
non-programmers to access information stored in a database
- (C) Can be
accessed only by data processing professionals
- (D) Both (a) and
(b)
2. Each of data files has a _______ that describe the way the data is stored in the file.
- (A) File
structure
- (B) Records
- (C) Fields
- (D) Database
3. A ________ contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
- (A) File
structure
- (B) Records
- (C) Fields
- (D) Database
4. In a relational schema, each tuple is divided into fields called
- (A) Relations
- (B) Domains
- (C) Queries
- (D) All of the
above
5. A file produced by a spreadsheet
- (A) Is generally
stored on disk in an ASCII text format
- (B) Can be used
as it by the DBMS
- (C) Can be used
for graphic
- (D) All of the
above
6. A command that lets you change one or more fields in a record is
- (A) Insert
- (B) Modify
- (C) Look-up
- (D) All of the
above
7. The master list of an indexed file
- (A) Is sorted in
ascending order
- (B) Contains
only a list of keys and record numbers
- (C) Has a number
assigned to each record
- (D) Both (b) and
(c)
8. The data-base environment has all of the following components except:
- (A) Users
- (B) Separate
files
- (C) Data base
- (D) Data-base
administrator
9. Which of the following is true of a network structure?
- (A) It is a
physical representation of the data
- (B) It allows a
many-to-many relationship
- (C) It is
conceptually simple
- (D) It will be
the dominant data base of the future
10. In an Entity-Relationship Diagram Rectangles represents
- (A) Entity sets
- (B) Attributes
- (C) Database
- (D) Tables
11. A Relation is a
- (A) Subset of a
Cartesian product of a list of attributes
- (B) Subset of a
Cartesian product of a list of domains
- (C) Subset of a
Cartesian product of a list of tuple
- (D) Subset of a
Cartesian product of a list of relations
12. Set of permitted values of each attribute is called
- (A) Domain
- (B) Tuple
- (C) Relation
- (D) Schema
13. The attribute that can be divided into other attributes is called
- (A) Simple
Attribute
- (B) Composite
Attribute
- (C) Multi-valued
Attribute
- (D) Derived
Attribute
14. Database locking concept is used to solve the problem of
- (A) Lost Update
- (B) Uncommitted
Dependency
- (C) Inconsistent
Data
- (D) All of the
above
15. In DBMS FD stands for _________
- (A) Facilitate
data
- (B) Functional
data
- (C) Facilitate
dependency
- (D) Functional
dependency
Next Tests: