1-1. A Database
Management System (DBMS) is
A. Collection of
interrelated data
B. Collection of
programs to access data
C. Collection of data
describing one particular enterprise
D. All of the above
1-2. Which of the
following is not a level of data abstraction?
A. Physical Level
B. Critical Level
C. Logical Level
D. View Level
1-3. 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
1-4. In an
Entity-Relationship Diagram Rectangles represents
A. Entity sets
B. Attributes
C. Database
D. Tables
1-5. Which of the
following is not a Storage Manager Component?
A. Transaction Manager
B. Logical Manager
C. Buffer Manager
D. File Manager
1-6. Data Manipulation
Language enables users to
A. Retrieval of
information stored in database
B. Insertion of new
information into the database
C. Deletion of
information from the database
D. All of the above
1-7. Which of the
following is not an Schema?
A. Database Schema
B. Physical Schema
C. Critical Schema
D. Logical Schema
1-8. Which of the
following is Database Language?
A. Data Definition
Language
B. Data Manipulation
Language
C. Query Language
D. All of the above
1-9. Which of the
following in not a function of DBA?
A. Network Maintenance
B. Routine Maintenance
C. Schema Definition
D. Authorization for
data access
1-10. 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
Click Here for Answers
1 – D / 2 – B / 3 – D /
4 – A / 5 – B / 6 – D / 7 – C / 8 – D / 9 – A / 10 – D
2-1. Which of the
following represents a relationship among a set of values.
A. A Row
B. A Table
C. A Field
D. A Column
A. A Row
B. A Table
C. A Field
D. A Column
2-2. Column header is
refer as
A. Table
B. Relation
C. Attributes
D. Domain
A. Table
B. Relation
C. Attributes
D. Domain
2-3. 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
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
2-4. In mathematical
term Table is referred as
A. Relation
B. Attribute
C. Tuple
D. Domain
A. Relation
B. Attribute
C. Tuple
D. Domain
2-5. In mathematical
term Row is referred as
A. Relation
B. Attribute
C. Tuple
D. Domain
A. Relation
B. Attribute
C. Tuple
D. Domain
2-6. _______ allow us to
identify uniquely a tuple in the relation.
A. Superkey
B. Domain
C. Attribute
D. Schema
A. Superkey
B. Domain
C. Attribute
D. Schema
2-7. Minimal Superkeys
are called
A. Schema keys
B. Candidate keys
C. Domain keys
D. Attribute keys
A. Schema keys
B. Candidate keys
C. Domain keys
D. Attribute keys
2-8. Which of the
following is not Modification of the Database
A. Deletion
B. Insertion
C. Sorting
D. Updating
A. Deletion
B. Insertion
C. Sorting
D. Updating
2-9. Which of the
following is Relation-algebra Operation
A. Select
B. Union
C. Rename
D. All of the above
A. Select
B. Union
C. Rename
D. All of the above
2-10. Which of the
following in not Outer join?
A. Left outer join
B. Right outer join
C. Full outer join
D. All of the above
A. Left outer join
B. Right outer join
C. Full outer join
D. All of the above
Click Here for Answers
1 – A / 2 – C / 3 – B /
4 – A / 5 – C / 6 – A / 7 – B / 8 – C / 9 – D / 10 – D