1. If a piece of data is stored in two places in the database, then
a) Storage space is wasted
b) Changing the data in one spot will cause data inconsistency
c) In can be more easily accessed
d) Storage space is wasted & Changing the data in one spot will cause data inconsistency
Explanation: The database is always consistent and so there is no duplication.
2. An audit trail ___________
a) Is used to make backup copies
b) Is the recorded history of operations performed on a file
c) Can be used to restore lost information
d) None of the mentioned
Explanation: This is more useful for all recovery actions.
3. Large collection of files are called ____________
a) Fields
b) Records
c) Database
d) Sectors
Explanation: The operator tree has a tree like format where the evaluation starts from root of the tree .
4. Which of the following hardware component is the most important to the operation of a database management system?
a) High resolution video display
b) Printer
c) High speed, large capacity disk
d) Mouse
Explanation: All the data are stored in form of memory in the disk.
5. Which of the following is not true of the traditional approach to information processing
a) There is common sharing of data among the various applications
b) It is file oriented
c) Programs are dependent on the file
d) It is inflexible
Explanation: All the data are stored in form of memory in the disk.
6. Which of these is not a feature of Hierarchical model?
a) Organizes the data in tree-like structure
b) Parent node can have any number of child nodes
c) Root node does not have any parent
d) Child node can have any number of parent nodes
Explanation: The data are traversed using several algorithms.
7. Which of these data models is an extension of the relational data model?
a) Object-oriented data model
b) Object-relational data model
c) Semi structured data model
d) none of the mentioned
Explanation: All the data are stored in form of memory in the disk.
8. The information about data in a database is called _______
a) Metadata
b) Hyper data
c) Tera data
d) None of the mentioned
Explanation: Metadata is information about a data.
9. A data dictionary is a special file that contains?
a) The names of all fields in all files
b) The data types of all fields in all files
c) The widths of all fields in all files
d) All of the mentioned
Explanation: The data dictionary is structured in tables and views, just like other database data.
10. The DBMS acts as an interface between what two components of an enterprise-class database system?
a) Database application and the database
b) Data and the database
c) The user and the database application
d) Database application and SQL
Explanation: Database application is the interface with the user to access the database.