Practice Test: Question Set - 07
1. Which language has recently become the de-facto standard for interfacing application programs with relational database system?
- (A) Oracle
- (B) SQL
- (C) 4GL
- (D) None of the
above
2. A computer file can be best described as
- (A) A single
data item
- (B) A general
collection of data items
- (C) An orderly
collection of data items
- (D) A random
collection of data items
3. The data dictionary tells the DBMS
- (A) What files
are in the database
- (B) What
attribute are possessed by the data
- (C) What these
files contain
- (D) All of the
above
4. A form defines
- (A) Where data
is placed on the screen
- (B) The width of
each field
- (C) Both (a) and
(b)
- (D) None of the
above
5. Which command is used to select distinct subject (SUB) from the table (BOOK)?
- (A) SELECT ALL
FROM BOOK
- (B) SELECT
DISTINCT SUB FROM BOOK
- (C) SELECT SUB
FROM BOOK
- (D) None of the
above
6. One approach to standardizing storing of data
- (A) MIS
- (B) Structured
programming
- (C) CODASYL
specifications
- (D) All
of the above
7. Queries to a database
- (A) Are written
in English
- (B) Can use
aggregate functions like SUM and COUNT
- (C) Both (a) and
(b)
- (D) None
of the above
8. Internal auditors should review data system design before they are
- (A) Developed
- (B) Implemented
- (C) Modified
- (D) All
of the above
9. 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
10. Which of the following is not the responsibility of the utilities component of DBMS software?
- (A) Creating
the physical and logical designs
- (B) Removing
flagged records for deletion
- (C) Creating
and maintaining the data dictionary
- (D) Monitoring
performance
11. It is more accurate to define a _______ as a variety of different record types that are treated as a single unit
- (A) Database
- (B) Table
- (C) Record
- (D) Flat File
12. Disadvantages of File systems to store data is:
- (A) Data
redundancy and inconsistency
- (B) Difficulty
in accessing data
- (C) Data
isolation
- (D) All
of the above
13. Column header is refer as
- (A) Table
- (B) Relation
- (C) Attributes
- (D) Domain
14. Which of the following is Relation algebra Operation?
- (A) Select
- (B) Union
- (C) Rename
- (D) All
of the above
15. Which of the following is not an Aggregate function?
- (A) Min
- (B) Max
- (C) Select
- (D) Avg
Next Tests:
Blogger Comment
Facebook Comment