This set of Database Questions and Answers for Aptitude test focuses on “Organization of Records in Files”.
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
View Answer
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
View Answer
Explanation: This is more useful for all recovery actions.
3. Large collection of files are called ____________
a) Fields
b) Records
c) Database
d) Sectors
View Answer
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
View Answer
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
View Answer
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
View Answer
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
View Answer
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
View Answer
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
View Answer
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
View Answer
Explanation: Database application is the interface with the user to access the database.
Sanfoundry Global Education & Learning Series – Database Management System.
If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]
- Apply for Computer Science Internship
- Practice Programming MCQs
- Check Programming Books
- Practice Computer Science MCQs
- Check Computer Science Books