Data Basics MCQs with Answers

Data Basics MCQs with Answers. Find the most important and more conceptual multiple-choice questions (MCQs) with answers on the database for the interview and final examinations of intermediate for all boards of Pakistan and entry test for admission in universities i.e., ECAT.

 

We tried our best to provide the most important and best multiple-choice questions (MCQs) from this chapter named Data Basics. This post covers the topics i.e., data, information, databases,  database manipulation (classifying, calculations, sorting, summarizing), record, file, types of files, components of databases, types of database models (i.e., Hierarchical model, Network model, and Relational model), DBMS (Database Management System), objectives of DBMS (i.e., shareability, availability, evolvability, and database integrity), advantages, and disadvantages of DBMS.

  

➤ Basic Concepts & Terminology of Databases - MCQs
➤ Basic Concepts & Terminology of Databases - Short Questions
➤ Data Basics - Short Questions
➤ Getting Started with C - MCQs
➤ Getting Started with C - Short Questions
➤ Elements of C - MCQs
➤ Elements of C - Short Questions
➤ Input/Output - MCQs
➤ Input/Output - Short Questions
➤ Input/Output - Exercise Programs
➤ Decision Constructs - MCQs
➤ Decision Constructs - Short Questions
➤ Decision Constructs - Exercise Programs
➤ Loop Constructs - MCQs
➤ Loop Constructs - Exercise Solution
➤ Loop Constructs - Short Questions
➤ Functions in C - MCQs
➤ Functions in C - Short Questions
➤ Functions in C - Exercise Programs
➤ File Handling - MCQ
➤ File Handling - Short Questions

Chapter No.1: Data Basics

Database MCQs | Online Quiz

 

1. A program used for generating on screen reports or printed documents is called?
   1.   printer
   2.   DBMS
   3.   softcopy
   4.   report generator
2. An online commercial site like amazon.com is an example of?
   1.   single-user database app
   2.   multi-user database app
   3.   e-commerce database app
   4.   all of these
3. In database, the centralization of data refers to?
   1.   data integrity
   2.   data independence
   3.   data integration
   4.   none of these
4. In ___ model, a child can have more than one parent?
   1.   network
   2.   hierarchical
   3.   relational
   4.   ER
5. The complexity in network model leads to?
   1.   slow access
   2.   difficult maintenance
   3.   slow access + difficult maintenance
   4.   none of these
6. The feature of DBMS to change itself according to growing user needs and advanced technologies is called?
   1.   availability
   2.   evolvability
   3.   shareability
   4.   none of these
7. The file with (.mdb) extension is an example of?
   1.   master file
   2.   data file
   3.   transaction file
   4.   program file
8. The process of dividing students into cricket and hockey teams refers to?
   1.   calculation
   2.   classification
   3.   summarizing
   4.   none of these
9. The structure related information of data is stored in?
   1.   database
   2.   data dictionary
   3.   data file
   4.   backup file
10. The top most mode in hierarchical model is called?
    1.   root
    2.   child
    3.   parent
    4.   none of these
11. The transaction files can be?
    1.   temporary files
    2.   permanent files
    3.   temporary + permanent files
    4.   none of these
12. Which of the followings can be used for data manipulation?
    1.   database
    2.   DBMS
    3.   table
    4.   none of these
13. Which of the followings component is involved in database system?
    1.   hardware
    2.   end user
    3.   software
    4.   all of these
14. Which of the followings feature of database allows us modification in program without reorganization of data?
    1.   data integrity
    2.   data interdependence
    3.   data integration
    4.   none of these
15. Which of the followings file belongs to files with storage point of view category?
    1.   sequential files
    2.   indexed sequential file
    3.   direct file
    4.   all of these
16. Which of the followings file requires more storage space?
    1.   sequential files
    2.   random files
    3.   indexed sequential files
    4.   all of these
17. Which of the followings is not an objective of DBMS?
    1.   availability
    2.   system overhead
    3.   evolvability
    4.   shareability
18. Which of the followings is not part of data manipulation?
    1.   classification
    2.   sorting
    3.   summarizing
    4.   storage and retrieval
19. Which of the followings is primary capability of DBMS?
    1.   data integrity
    2.   online security
    3.   backup / recovery
    4.   all of these
20. Which of the followings model stores data in the form of table?
    1.   hierarchical
    2.   relational
    3.   network
    4.   all of these