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

  1. Q1

    An organized collection of data stored in multiple datasets or tables is a:

    1. ADataset
    2. BSpreadsheet
    3. CSensor
    4. DDatabase
    Show answer

    Correct answer: D. Database

    A database holds many tables that can be accessed electronically.

  2. Q2

    DBMS stands for:

    1. ADatabase Management System
    2. BData Backup Management Software
    3. CDigital Base Memory System
    4. DData Block Mining System
    Show answer

    Correct answer: A. Database Management System

    DBMS means Database Management System.

  3. Q3

    The interface between the database and the end user is the:

    1. ADataset
    2. BSensor
    3. CDBMS
    4. DBrowser
    Show answer

    Correct answer: C. DBMS

    A DBMS lets users create, modify and retrieve data.

  4. Q4

    Relational databases store data in:

    1. AGraphs
    2. BTables
    3. CKey-value pairs
    4. DDocuments
    Show answer

    Correct answer: B. Tables

    Relational databases use tables.

  5. Q5

    Which is a relational DBMS?

    1. AMongoDB
    2. BCassandra
    3. CHadoop
    4. DMySQL
    Show answer

    Correct answer: D. MySQL

    MySQL stores data in tables, so it is a relational DBMS. MongoDB and Cassandra are NoSQL.

  6. Q6

    MongoDB and Cassandra manage:

    1. ANon-relational databases
    2. BRelational databases
    3. CSpreadsheets
    4. DPrinters
    Show answer

    Correct answer: A. Non-relational databases

    They manage non-relational databases.

  7. Q7

    Non-relational DBMS are also called:

    1. ASQL DBMS
    2. BTable DBMS
    3. CNoSQL DBMS
    4. DFlat DBMS
    Show answer

    Correct answer: C. NoSQL DBMS

    Non-relational DBMS do not use tables, so they are called NoSQL DBMS.

  8. Q8

    Which is NOT a form in which non-relational databases store data?

    1. AKey-value pairs
    2. BColumn families
    3. CGraphs
    4. DRows and columns of tables
    Show answer

    Correct answer: D. Rows and columns of tables

    Tables are used by relational databases.

  9. Q9

    Which of the following is a NoSQL DBMS?

    1. AMySQL
    2. BOracle
    3. CMongoDB
    4. DIBM Db2
    Show answer

    Correct answer: C. MongoDB

    MongoDB manages non-relational data. The others are relational DBMS.

Dataset and Database short questions

  1. What is a database?

    Important
  2. What is the main difference between relational and non-relational databases?

    Important
  3. What is a relational database?

    Important
  4. Differentiate between database and dataset.

    Important
  5. Give examples of popular DBMS used in data science.

Dataset and Database long questions

  1. Differentiate between dataset and database. Explain DBMS and its types with examples.

    Important

Chapter 4 study material

A little trouble connecting

We could not reach IlmiDunya. Your connection may be slow or interrupted. Check your connection and try again.

If you were saving or submitting, check the result before trying again.

Account blocked

You are blocked from using IlmiDunya. Contact support to unblock your account.