Home → Resource

10th – Computer Science – Chapter 5 – Introduction to Data Science

MCQs

  1. Data cleaning involves standardizing formats. Which of the following is an example?
    a) Deleting all data b) Adding more columns c) Making sure Cricket is not written as CRICKET in the same column d) Sorting alphabetically
  2. What does the SQL command SELECT * FROM Sports retrieve?
    a) All data from the Sports table b) Only the first row c) Row count only d) Sports names only
  3. MySQL and SQLite are examples of which of the following?
    a) Operating systems b) DBMS (Database Management Systems) c) Programming languages d) Visualization tools
  4. What is the primary purpose of analyzing data?
    a) Delete old data b) Decorate data c) Find patterns and make decisions d) Upload to the internet
  5. Microsoft Access is an example of which of the following?
    a) Spreadsheet b) Word processor c) DBMS d) Visualization platform
  6. What is a record in a database?
    a) A column b) A single row (entry) in a table c) The table name d) A query
  7. Which method is most suitable for gathering opinions from many students?
    a) IoT Devices b) Survey c) Web Scraping d) Database
  8. Which step comes first in the Data Science Life Cycle (DSLC)?
    a) Collecting Data b) Visualizing Data c) Understanding the Problem d) Analyzing the Data
  9. Under which category does Google Sheets fall?
    a) A database b) A programming language c) A spreadsheet d) A text editor
  10. A pie chart is most suitable for showing:
    a) Changes over time b) Parts of a whole or percentages c) Group comparisons d) Correlations
  11. Which statement best describes Data Science?
    a) Only storing data in databases b) Programming websites c) Designing graphics d) Using data to find patterns and make smart decisions
  12. Which tool is most suitable for beginners who want to create charts?
    a) Tableau b) Python c) Google Sheets d) Hadoop
  13. In what form does a relational database store information?
    a) Slides b) Tables c) Blocks d) Layers
  14. Which of the following is an example of a data source?
    a) YouTube b) Whiteboard c) Slide show d) Survey form
  15. What must be done before data is stored?
    a) Add animations b) Encrypt it c) Translate it d) Clean and validate it
  16. What does SQL stand for?
    a) Structured Query Language b) Standard Queue Logic c) System Query Loop d) Simple Queue Language
  17. A line chart is most suitable for showing:
    a) Group comparisons b) Parts of a whole c) Changes over time d) Geographic data
  18. What does DBMS stand for?
    a) Data Block Management Service b) Database Management System c) Digital Backup Memory Store d) Data Binary Merge System
  19. What does DSLC stand for?
    a) Data Storage and Loading Cycle b) Data Science Life Cycle c) Digital System Learning Code d) Database Structured Language Cycle
  20. What is meant by “bias” in data?
    a) Very large data size b) Unfair or one-sided data c) Well-cleaned data d) High-speed data
  21. Data validation ensures that:
    a) Data is printed correctly b) Data is correct, complete, and in the right format before use c) Data is stored in cloud only d) Data is encrypted
  22. Why does a dashboard display multiple visuals together?
    a) To only list numbers b) To tell a clear data story at a glance c) To store source code d) To display hardware info
  23. What is a field in a database?
    a) A table b) A specific column that stores one type of information c) A query d) A row
  24. Which chart type is most suitable for comparing groups?
    a) Pie Chart b) Bar Chart c) Line Chart d) Area Chart
  25. Which SQL keyword is used to add new data into a table?
    a) INSERT INTO b) SELECT c) UPDATE d) DELETE
  26. Which of the following is an advanced data visualization platform?
    a) MS Paint b) Google Data Studio c) Notepad d) WhatsApp
  27. Which DSLC step asks ‘what do we want to find out’?
    a) Data collection b) Understanding the problem c) Data cleaning d) Data visualization
  28. How is Tableau best described?
    a) Advanced data visualization platform b) Spreadsheet tool c) DBMS d) Programming language
  29. What should be done with duplicate rows in a dataset?
    a) Removed as they cause incorrect results b) Kept as they add value c) Highlighted in red d) Converted to NULL
  30. What does IoT stand for?
    a) Internet of Things b) Input of Technology c) Interface of Tools d) Index of Tasks

Short Questions

(i) Name two data visualization tools and one advantage of each.
(ii) What does analyzing data in the DSLC involve?
(iii) Why is it important to store cleaned data in an organized format?
(iv) What is observational data collection? Give an example.
(v) Describe when a bar chart, pie chart, and line chart are each most useful.
(vi) What do we mean by “cleaning” data?
(vii) What is an SQL query, and what is it used for?
(viii) Why is it important to validate data before using it?
(ix) Write two steps you will follow to clean a messy survey.
(x) What is the difference between a spreadsheet and a database?
(xi) What is data validation, and why is it important?
(xii) Write the SQL query to find all students who like Cricket from a Sports table.
(xiii) Give two examples of data collection methods.
(xiv) What are missing values in a dataset, and how should they be handled?
(xv) What does SQL INSERT INTO do? Give an example.
(xvi) How does bias in data affect results?
(xvii) Name any two tools used for creating charts.
(xviii) What is the purpose of visualizing data using charts?
(xix) What steps are followed to clean a messy dataset?
(xx) What is the communicating results step in DSLC?
(xxi) What is the importance of understanding a problem before collecting data?
(xxii) What are the six steps of the Data Science Life Cycle?
(xxiii) What is a database table, and what are its rows and columns called?
(xxiv) Name any two methods of collecting data and give one example of each.
(xxv) What is the difference between DBMS and SQL?
(xxvi) What is data bias,s and how does it affect results?
(xxvii) What is the purpose of a dashboard in data science?
(xxviii) What is web scraping as a method of data collection?
(xxix) What are the basic steps to create a bar chart in Google Sheets?

Long Questions

  1. Give a detailed comparison between Bar Chart, Pie Chart, and Line Chart with examples.
  2. Write a Query in SQL to get all data of a student whose roll_number is 15 from the student table.
  3. Explain the six steps of the Data Science Life Cycle (DSLC) in one line each.
  4. Differentiate between DBMS and SQL.

Answer Key

  1. c) Making sure Cricket is not written as CRICKET in the same column
  2. a) All data from the Sports table
  3. b) DBMS (Database Management System)
  4. c) Find patterns and make decisions
  5. c) DBMS
  6. b) A single row (entry) in a table
  7. b) Survey
  8. c) Understanding the Problem
  9. c) A spreadsheet
  10. b) Parts of a whole or percentages
  11. d) Using data to find patterns and make smart decisions
  12. c) Google Sheets
  13. b) Tables
  14. d) Survey form
  15. d) Clean and validate it
  16. a) Structured Query Language
  17. c) Changes over time
  18. b) Database Management System
  19. b) Data Science Life Cycle
  20. b) Unfair or one-sided data
  21. b) Data is correct, complete, and in the right format before use
  22. b) Tell a clear data story at a glance
  23. b) A specific column that stores one type of information
  24. b) Bar Chart
  25. a) INSERT INTO
  26. b) Google Data Studio
  27. b) Understanding the problem
  28. a) Advanced data visualization platform
  29. a) Removed, as they cause incorrect results
  30. a) Internet of Things

Leave a Reply

Your email address will not be published. Required fields are marked *