MCQs
- 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 - 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 - MySQL and SQLite are examples of which of the following?
a) Operating systems b) DBMS (Database Management Systems) c) Programming languages d) Visualization tools - 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 - Microsoft Access is an example of which of the following?
a) Spreadsheet b) Word processor c) DBMS d) Visualization platform - 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 - Which method is most suitable for gathering opinions from many students?
a) IoT Devices b) Survey c) Web Scraping d) Database - 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 - Under which category does Google Sheets fall?
a) A database b) A programming language c) A spreadsheet d) A text editor - A pie chart is most suitable for showing:
a) Changes over time b) Parts of a whole or percentages c) Group comparisons d) Correlations - 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 - Which tool is most suitable for beginners who want to create charts?
a) Tableau b) Python c) Google Sheets d) Hadoop - In what form does a relational database store information?
a) Slides b) Tables c) Blocks d) Layers - Which of the following is an example of a data source?
a) YouTube b) Whiteboard c) Slide show d) Survey form - What must be done before data is stored?
a) Add animations b) Encrypt it c) Translate it d) Clean and validate it - What does SQL stand for?
a) Structured Query Language b) Standard Queue Logic c) System Query Loop d) Simple Queue Language - A line chart is most suitable for showing:
a) Group comparisons b) Parts of a whole c) Changes over time d) Geographic data - What does DBMS stand for?
a) Data Block Management Service b) Database Management System c) Digital Backup Memory Store d) Data Binary Merge System - 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 - 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 - 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 - 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 - 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 - Which chart type is most suitable for comparing groups?
a) Pie Chart b) Bar Chart c) Line Chart d) Area Chart - Which SQL keyword is used to add new data into a table?
a) INSERT INTO b) SELECT c) UPDATE d) DELETE - Which of the following is an advanced data visualization platform?
a) MS Paint b) Google Data Studio c) Notepad d) WhatsApp - Which DSLC step asks ‘what do we want to find out’?
a) Data collection b) Understanding the problem c) Data cleaning d) Data visualization - How is Tableau best described?
a) Advanced data visualization platform b) Spreadsheet tool c) DBMS d) Programming language - 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 - 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
- Give a detailed comparison between Bar Chart, Pie Chart, and Line Chart with examples.
- Write a Query in SQL to get all data of a student whose roll_number is 15 from the student table.
- Explain the six steps of the Data Science Life Cycle (DSLC) in one line each.
- Differentiate between DBMS and SQL.
Answer Key
- c) Making sure Cricket is not written as CRICKET in the same column
- a) All data from the Sports table
- b) DBMS (Database Management System)
- c) Find patterns and make decisions
- c) DBMS
- b) A single row (entry) in a table
- b) Survey
- c) Understanding the Problem
- c) A spreadsheet
- b) Parts of a whole or percentages
- d) Using data to find patterns and make smart decisions
- c) Google Sheets
- b) Tables
- d) Survey form
- d) Clean and validate it
- a) Structured Query Language
- c) Changes over time
- b) Database Management System
- b) Data Science Life Cycle
- b) Unfair or one-sided data
- b) Data is correct, complete, and in the right format before use
- b) Tell a clear data story at a glance
- b) A specific column that stores one type of information
- b) Bar Chart
- a) INSERT INTO
- b) Google Data Studio
- b) Understanding the problem
- a) Advanced data visualization platform
- a) Removed, as they cause incorrect results
- a) Internet of Things
