Practice Test: Question Set - 15
1. Sophisticated report generators can
- (A) Print
row-oriented reports
- (B) Perform
arithmetic operations
- (C) Selectively
retrieve and print portions of a list
- (D) All of the
above
2. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
- (A) Record
- (B) Field
- (C) File
- (D) Data base
3. Which of the following is a Data Model?
- (A) Entity-Relationship
model
- (B) Relational
data model
- (C) Object-Based
data model
- (D) All of the
above
4. UML is stands for
- (A) Universal
Modeling Language
- (B) Unified
Modeling Language
- (C) United
Modeling Language
- (D) Uni Modeling
Language
5. Report generators are used to
- (A) Store data
input by a user
- (B) Retrieve
information from files
- (C) Answer
queries
- (D) Both (b) and
(c)
6. In a large DBMS
- (A) Each user
can "see" only a small part of the entire database
- (B) Each user
can access every sub-schema
- (C) Each
subschema contains every field in the logical schema
- (D) All of the
above
7. Information can be transferred between the DBMS and a
- (A) Spreadsheet
program
- (B) Word
processor program
- (C) Graphics
program
- (D) All of the
above
8. In SQL, which command(s) is(are) used to enable/disable a database trigger?
- (A) Modify User
- (B) Change User
- (C) Alter
Trigger
- (D) None of the
above
9. Which of the following is a type of DBMS software?
- (A) Database
manipulation language
- (B) Query
language
- (C) Utilities
- (D) Report
writer
10. Snapshot of the data in the database at a given instant of time is called
- (A) Database
Schema
- (B) Database
Instance
- (C) Database
Snapshot
- (D) All of the
above
11. A functional dependency between two or more non-key attributes is called
- (A) Transitive
dependency
- (B) Partial
transitive dependency
- (C) Functional
dependency
- (D) Partial
functional dependency
12. Sort/report generators
- (A) Are faster
than index/report generators
- (B) Require more
disk space than index/report generators
- (C) Do not need
to sort before generating a report
- (D) Both (a) and
(b)
13. Which of the following is not a logical data-base structure?
- (A) Tree
- (B) Relational
- (C) Network
- (D) Chain
14. Which of the following is not an advantage of the data-base approach?
- (A) Elimination
of the data redundancy
- (B) Ability to
associate related data
- (C) Increased
security
- (D) All of the
above are advantages
15. The highest level in the hierarchy of data organization is called
- (A) Data bank
- (B) Database
- (C) Data file
- (D) Data record
Next Tests:
Blogger Comment
Facebook Comment