Practice Test: Question Set - 08
1. Data Manipulation Language (DML) is not to
- (A) Create
information table in the Database
- (B) Insertion
of new information into the Database
- (C) Deletion
of information in the Database
- (D) Modification
of information in the Database
2. In precedence of set operators the expression is evaluated from:
- (A) Left to Left
- (B) Left to
Right
- (C) Right to
Right
- (D) Right to
Left
3. The minimal set of super key is called
- (A) Primary key
- (B) Secondary
key
- (C) Candidate
key
- (D) Foreign key
4. A type of query that is placed within a WHERE or HAVING clause of another query is called
- (A) Super query
- (B) Sub query
- (C) Master query
- (D) Multi-query
5. A data dictionary doesn't provide information about:
- (A) Where data
is located
- (B) The size of
the disk storage device
- (C) It allows a
many-to-many relationship
- (D) It is
conceptually simple
6. In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
- (A) Data field
- (B) Data record
- (C) Data file
- (D) Database
7. A report generator is used to
- (A) Update files
- (B) Print files
on paper
- (C) Data entry
- (D) None of the
above
8. Related fields in a data base are grouped to form
- (A) Data file
- (B) Data record
- (C) Menu
- (D) Bank
9. A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
- (A) Specialized
file
- (B) Log file
- (C) Master file
- (D) Update file
10. In SQL, which command is used to remove a stored function from the database?
- (A) REMOVE
FUNCTION
- (B) DELETE
FUNCTION
- (C) DROP
FUNCTION
- (D) ERASE
FUNCTION
11. Versatile report generators can provide
- (A) Columnar
totals
- (B) Subtotals
- (C) Calculations
- (D) All of the
above
12. In SQL, which command is used to select only one copy of each set of duplicable rows
- (A) SELECT
DISTINCT
- (B) SELECT
UNIQUE
- (C) SELECT
DIFFERENT
- (D) All of the
above
13. The distinguishable parts of a record are called
- (A) Files
- (B) Data
- (C) Fields
- (D) Database
14. The model for a _______ resembles the hierarchical model in many respects.
- (A) Network
database
- (B) Relational database
- (C) Distributed
database
- (D) Hierarchical
database
15. 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
Next Tests:
Blogger Comment
Facebook Comment