4.2.2 Dataset and Database
9 Computer Science · Chapter 4: Data and Analysis · Federal Board (FBISE)
4.2.2 Dataset and Database from Federal Board 9 Computer Science (9th Class) Chapter 4, Data and Analysis: 6 short and long questions and 9 MCQs with answers.
Explains the difference between a dataset and a database, and the role of a DBMS in creating, modifying and retrieving data. It compares relational databases (MySQL, Oracle) with non-relational NoSQL databases (MongoDB, Cassandra).
Dataset and Database MCQs
- Q1
An organized collection of data stored in multiple datasets or tables is a:
Show answer
Correct answer: D. Database
A database holds many tables that can be accessed electronically.
- Q2
DBMS stands for:
Show answer
Correct answer: A. Database Management System
DBMS means Database Management System.
- Q3
The interface between the database and the end user is the:
Show answer
Correct answer: C. DBMS
A DBMS lets users create, modify and retrieve data.
- Q4
Relational databases store data in:
Show answer
Correct answer: B. Tables
Relational databases use tables.
- Q5
Which is a relational DBMS?
Show answer
Correct answer: D. MySQL
MySQL stores data in tables, so it is a relational DBMS. MongoDB and Cassandra are NoSQL.
- Q6
MongoDB and Cassandra manage:
Show answer
Correct answer: A. Non-relational databases
They manage non-relational databases.
- Q7
Non-relational DBMS are also called:
Show answer
Correct answer: C. NoSQL DBMS
Non-relational DBMS do not use tables, so they are called NoSQL DBMS.
- Q8
Which is NOT a form in which non-relational databases store data?
Show answer
Correct answer: D. Rows and columns of tables
Tables are used by relational databases.
- Q9
Which of the following is a NoSQL DBMS?
Show answer
Correct answer: C. MongoDB
MongoDB manages non-relational data. The others are relational DBMS.
Dataset and Database short questions
What is a database?
ImportantWhat is the main difference between relational and non-relational databases?
ImportantWhat is a relational database?
ImportantDifferentiate between database and dataset.
ImportantGive examples of popular DBMS used in data science.
Dataset and Database long questions
Differentiate between dataset and database. Explain DBMS and its types with examples.
Important