Data Analytics Using Python (BCA 4th Sem) - MCQ
Part 1 (Questions 1-50)
Q1. Data Analytics is the process of?
A. Collecting, cleaning and analyzing data
B. Only storing data
C. Only deleting data
D. Only visualizing data
Answer: A
Q2. Which type of analytics answers 'What happened?'
A. Predictive
B. Prescriptive
C. Descriptive
D. Diagnostic
Answer: C
Q3. Python is a?
A. Low-level language
B. High-level language
C. Assembly language
D. Machine language
Answer: B
Q4. Which symbol is used for comments in Python?
A. //
B. #
C. /*
D. --
Answer: B
Q5. Which function is used to display output?
A. scan()
B. input()
C. print()
D. show()
Answer: C
Q6. Which data type stores whole numbers?
A. float
B. str
C. int
D. bool
Answer: C
Q7. Which keyword is used for decision making?
A. for
B. if
C. while
D. def
Answer: A
Q8. Which loop repeats while a condition is true?
A. for
B. while
C. switch
D. case
Answer: B
Q9. Which keyword defines a function?
A. func
B. define
C. def
D. function
Answer: C
Q10. NumPy stands for?
A. Numerical Python
B. Number Python
C. New Python
D. Numeric Package
Answer: A
Q11. Which analytics predicts future outcomes?
A. Descriptive
B. Diagnostic
C. Predictive
D. None
Answer: C
Q12. Which function accepts user input?
A. input()
B. print()
C. scan()
D. read()
Answer: A
Q13. Boolean values are?
A. 0 and 1
B. True and False
C. Yes and No
D. On and Off
Answer: B
Q14. Which operator is used for exponentiation?
A. ^
B. **
C. //
D. %
Answer: B
Q15. List elements are enclosed in?
A. ()
B. {}
C. []
D. <>
Answer: C
Q16. Tuple elements are enclosed in?
A. []
B. ()
C. {}
D. <>
Answer: B
Q17. Dictionary stores data as?
A. Key-value pairs
B. Rows
C. Columns
D. Indexes
Answer: A
Q18. Which module is mainly used for numerical computing?
A. Pandas
B. NumPy
C. Seaborn
D. Tkinter
Answer: B
Q19. Which statement exits a loop?
A. continue
B. pass
C. break
D. exit
Answer: C
Q20. Which analytics suggests actions?
A. Prescriptive
B. Diagnostic
C. Predictive
D. Descriptive
Answer: A
Q21. Pandas is mainly used for?
A. Gaming
B. Data Analysis
C. Networking
D. OS Design
Answer: B
Q22. A Pandas Series is?
A. 1D data structure
B. 2D data structure
C. 3D data structure
D. None
Answer: A
Q23. A DataFrame is?
A. 1D
B. 2D tabular structure
C. Tree
D. Graph
Answer: B
Q24. CSV stands for?
A. Comma Separated Values
B. Computer Saved Values
C. Common Stored Values
D. Column Standard Values
Answer: A
Q25. Which Pandas function reads CSV files?
A. read_csv()
B. open_csv()
C. load_csv()
D. csv_read()
Answer: A
Q26. Missing values in Pandas are represented by?
A. NA/NaN
B. 0
C. -1
D. Blank only
Answer: A
Q27. Which function shows first rows of DataFrame?
A. tail()
B. head()
C. show()
D. first()
Answer: B
Q28. Which function shows last rows?
A. head()
B. tail()
C. last()
D. end()
Answer: B
Q29. Which method removes duplicates?
A. dropna()
B. drop_duplicates()
C. unique()
D. remove()
Answer: B
Q30. Outliers are?
A. Normal values
B. Extreme values
C. Missing values
D. Duplicate values
Answer: B
Q31. Which library is used for visualization?
A. Matplotlib
B. NumPy
C. SQLite
D. Tkinter
Answer: A
Q32. Matplotlib function for line graph?
A. plot()
B. bar()
C. hist()
D. scatter()
Answer: A
Q33. Which plot compares categories?
A. Histogram
B. Bar chart
C. Scatter
D. Pie only
Answer: B
Q34. Histogram is used for?
A. Frequency distribution
B. Comparison
C. Relationship
D. Database
Answer: A
Q35. Scatter plot shows?
A. Distribution
B. Relationship between variables
C. Tables
D. Text
Answer: B
Q36. EDA stands for?
A. Exploratory Data Analysis
B. External Data Access
C. Easy Data Analytics
D. Extra Data Analysis
Answer: A
Q37. Seaborn is built on?
A. Pandas
B. NumPy
C. Matplotlib
D. Dask
Answer: C
Q38. Which plot is useful for trends over time?
A. Line plot
B. Histogram
C. Bar chart
D. Pie chart
Answer: A
Q39. Which command imports Pandas?
A. import pandas as pd
B. import numpy as pd
C. include pandas
D. load pandas
Answer: A
Q40. Which command imports NumPy?
A. import numpy as np
B. import pandas as np
C. load numpy
D. include numpy
Answer: A
Q41. Which function provides DataFrame information?
A. info()
B. describe()
C. shape()
D. type()
Answer: A
Q42. describe() provides?
A. Statistics summary
B. Plots
C. Files
D. Errors
Answer: A
Q43. shape attribute gives?
A. Rows and columns
B. Only rows
C. Only columns
D. Memory
Answer: A
Q44. Which analytics finds causes of events?
A. Diagnostic
B. Predictive
C. Prescriptive
D. None
Answer: A
Q45. Which operator gives remainder?
A. /
B. %
C. //
D. **
Answer: B
Q46. Which keyword skips current loop iteration?
A. pass
B. break
C. continue
D. exit
Answer: C
Q47. JSON stands for?
A. JavaScript Object Notation
B. Java Source Object Network
C. Joint Standard Output Notation
D. None
Answer: A
Q48. Excel files can be read using?
A. read_excel()
B. excel_read()
C. open_excel()
D. load_excel()
Answer: A
Q49. Pandas DataFrame is similar to?
A. Spreadsheet table
B. Image
C. Video
D. Stack
Answer: A
Q50. Data cleaning improves?
A. Data quality
B. Hardware
C. Network speed
D. Storage only
Answer: A