Database Questions and Answers – Organization of Records in Files

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

Answer: d
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

Answer: b
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

Answer: c
Explanation: The operator tree has a tree like format where the evaluation starts from root of the tree .
advertisement
advertisement

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

Answer: c
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

Answer: a
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

Answer: d
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

Answer: b
Explanation: All the data are stored in form of memory in the disk.
advertisement

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

Answer: a
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

Answer: d
Explanation: The data dictionary is structured in tables and views, just like other database data.
advertisement

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

Answer: a
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]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.