CLASS 12th PYTHON
TEST
Multiple Choice Questions
UNIT I: DATA HANDLING - PANDAS AND PYPLOT
1. To create an empty Series object, you can use:
2. To specify datatype int16 for a Series object, you can write:
3. To get the number of dimensions of a Series object, ______ attribute is displayed.
4. To get the size of the datatype of the items in Series object, you can display ______ attribute.
5. To get the number of elements in a Series object, ______ attribute may be used.
6. To get the number of bytes of the Series data, ______ attribute is displayed.
7. To check if the Series object contains NaN values, ______ attribute is displayed.
8. To display third element of a Series object S, you will write ______.
9. To display first three elements of a Series object S, you may write ______.
10. To display last five rows of a Series object S, you may write ______.
11. ______ Pandas object cannot grow in size.
12. Given a Pandas series called Sequences, the command which will display the first 4 rows is ______.
13. If a Dataframe is created using a 2D dictionary, then the indexes/row labels are formed from ______.
14. If a dataframe is created using a 2D dictionary, then the column labels are formed from ______.
15. The axis 0 identifies a dataframe’s ______.
16. The axis 1 identifies a dataframe’s ______.
17. To get the number of elements in a dataframe, ______ attribute may be used.
18. To get a number representing number of axes in a dataframe, ______ attribute may be used.
1. To create an empty Series object
✅ Correct Answer: <u><b>(c) pd.Series()</b></u>
Explanation:pd.Series() creates an empty Series.
(a)
pd.Series(empty)→ invalid unlessemptyis defined.(b)
pd.Series(np.NaN)→ creates a Series with NaN value, not empty.(d) Incorrect because only (c) is valid for empty Series.
2. To specify datatype int16 for a Series
✅ Correct Answer: <u><b>(b) pd.Series(data = array, dtype = numpy.int16)</b></u>
Explanation:
The correct way to define dtype is using NumPy datatype like numpy.int16.
(a)
int16alone is undefined unless imported.(c) Syntax is incorrect.
(d) Incorrect because only (b) is valid syntax.
3. Number of dimensions of a Series
✅ Correct Answer: <u><b>(d) ndim</b></u>
Explanation:ndim returns number of dimensions.
A Series is 1-dimensional → S.ndim returns 1.
4. Size of datatype of items in Series
✅ Correct Answer: <u><b>(c) itemsize</b></u>
Explanation:itemsize returns the size (in bytes) of each element.
5. Number of elements in a Series
✅ Correct Answer: <u><b>(b) size</b></u>
Explanation:size returns total number of elements in the Series.
6. Number of bytes of Series data
✅ Correct Answer: <u><b>(b) nbytes</b></u>
Explanation:nbytes gives total memory consumed by data in bytes.
7. To check if Series contains NaN
✅ Correct Answer: <u><b>(a) hasnans</b></u>
Explanation:hasnans returns True if NaN values are present.
8. To display third element of Series S
✅ Correct Answer: <u><b>(b) S[2]</b></u>
Explanation:
Indexing starts from 0.
Third element → index 2.
9. To display first three elements
✅ Correct Answer: <u><b>(a) S[:3]</b></u>
Explanation:
Slice notation → S[:3] returns elements 0,1,2.
10. To display last five rows
✅ Correct Answer: <u><b>(d) tail(5)</b></u>
Explanation:tail(5) returns last 5 rows.head() returns first rows.
11. Pandas object cannot grow in size
✅ Correct Answer: <u><b>(c) Panel</b></u>
Explanation:
Panel (3D structure, now deprecated) had fixed dimensions and cannot grow dynamically like DataFrame or Series.
12. Display first 4 rows
✅ Correct Answer: <u><b>(a) print(Sequences.head(4))</b></u>
Explanation:head(4) returns first 4 rows.
Python is case-sensitive → Head(), heads() invalid.
13. DataFrame created using 2D dictionary – row labels
✅ Correct Answer: <u><b>(c) outer dictionary’s keys</b></u>
Explanation:
In a dictionary of dictionaries:
Outer keys → row labels
Inner keys → column labels
14. DataFrame created using 2D dictionary – column labels
✅ Correct Answer: <u><b>(b) inner dictionary’s keys</b></u>
Explanation:
Inner dictionary keys become column names.
15. Axis 0 identifies
✅ Correct Answer: <u><b>(a) rows</b></u>
Explanation:
Axis 0 → Row-wise operations.
16. Axis 1 identifies
✅ Correct Answer: <u><b>(b) columns</b></u>
Explanation:
Axis 1 → Column-wise operations.
17. Number of elements in a DataFrame
✅ Correct Answer: <u><b>(a) size</b></u>
Explanation:size = rows × columns.
18. Number of axes in DataFrame
✅ Correct Answer: <u><b>(d) ndim</b></u>
Explanation:ndim returns number of axes.
DataFrame is 2D → ndim = 2.
✅ Final Answer Key (Quick View)
(c)
(b)
(d)
(c)
(b)
(b)
(a)
(b)
(a)
(d)
(c)
(a)
(c)
(b)
(a)
(b)
(a)
(d)
Multiple Choice Questions
UNIT I: DATA HANDLING - PANDAS AND PYPLOT
Page 5
1. To get the transpose of a dataframe D1, you can write ______.
2. To extract row/column from a dataframe, ______ function may be used.
3. To display the 3rd, 4th and 5th columns from the 6th to 9th rows of a dataframe DF, you can write _____.
4. To change the 5th column’s value at 3rd row as 35 in dataframe DF, you can write ______.
5. Which among the following options can be used to create a DataFrame in Pandas?
6. Identify the correct statement:
7. To delete a column from a DataFrame, you may use ______ statement.
8. To delete a row from a DataFrame, you may use ______ statement.
9. To iterate over horizontal subsets of dataframe, ______ function may be used.
10. To iterate over vertical subsets of a dataframe, ______ function may be used.
11. To add two dataframes’ values, ______ function may be used.
12. To subtract the values of two dataframes, ______ function may be used.
13. To divide the values of two dataframes, ______ function may be used.
14. Which of the following two functions will produce the same result?
15. To get the 3 bottommost rows from a dataframe, you may use ______ function.
16. Which of the following arguments lets you specify index labels of dataframe through DataFrame()?
17. To get top 5 rows of a dataframe, you may use ______ function.
18. Which of the following can be used to specify data for creating a DataFrame?
19. All Pandas’ data structures are ______ mutable but not always ______ mutable.
20. Which of the following statement will import Pandas library?
21. What will be the output for the following code?
import pandas as pd s = pd.Series([1,2,3,4,5], index = ['a','b','c','d','e']) print(s['a'])
22. What will be the output for the following code?
import pandas as pd import numpy as np s = pd.Series(np.random.randn(2)) print(s.size)
23. What will be the output for the following code?
import pandas as pd import numpy as np s = pd.Series(np.random.randn(4)) print(s.ndim)
24. What is the purpose of using ndim attribute?
25. PyPlot is an interface of Python’s ______ library.
Multiple Choice Questions
UNIT I: DATA HANDLING - PANDAS AND PYPLOT
Page 7 & 8
1. For 2D plotting using a Python library, which library interface is often used?
2. Which of the following is not a valid chart type?
3. Which of the following is not a valid plotting function of pyplot?
4. Which of the following plotting functions does not plot multiple data series?
5. The plot which tells the trend between two graphed variables is the ______ graph/chart.
6. Which of the following functions is used to create a line chart?
7. Which of the following function will produce a bar chart?
8. Which of the following function will create a vertical bar chart?
9. Which of the following function will create a horizontal bar chart?
10. The datapoints plotted on a graph are called ______.
11. A ______ graph is a type of chart which displays information as a series of data points connected by straight line segments.
12. Which argument of bar() lets you set the thickness of bar?
13. Which function lets you set the title of the plot?
14. The command used to give a heading to a graph is ______.
15. Which function would you use to set the limits for x-axis of the plot?
16. Which function is used to show legends?
17. Which argument must be set with plotting functions for legend() to display the legends?
18. Which function is used to create a histogram?
19. Which of the following is not a valid plotting function of pyplot?
20. Which of the following plotting functions does not plot multiple data series?
21. The plot which tells the trend between two graphed variables is the ______ graph/chart.
22. A CSV file can take ______ character as separator.
23. In order to work with CSV files from Pandas, you need to import ______, other than pandas.
24. The correct statement to read from a CSV file in a dataframe is:
25. Which argument do you specify with read_csv() to specify a separator character?
26. To suppress first row as header, which of the following arguments is to be given in read_csv()?
27. To read specific number of rows from a CSV file, which argument is to be given in read_csv()?
28. To skip first 5 rows of CSV file, which argument will you give in read_csv()?
29. To skip 1st, 3rd and 5th rows of CSV file, which argument will you give in read_csv()?
30. While reading from a CSV file, to use a column’s values as index labels, argument given in read_csv() is:
31. While writing a dataframe onto a CSV file, which argument would you use in to_sql() for NaN values’ representation as NULL?
Multiple Choice Questions
UNIT II: DATABASE QUERY USING SQL
MOVE FAST WITH INFORMATICS PRACTICES – XII
1. Which of the following is a group of one or more attributes that uniquely identifies a row?
2. Which of the following attributes cannot be considered as a choice for primary key?
3. An attribute in a relation is a foreign key if it is the ______ key in any other relation.
4. Consider the table with structure as: Student(ID, name, dept_name, tot_cred)
In the above table, which attribute will form the primary key?
5. Which of the following is not a legal sub-language of SQL?
6. Which of the following attributes can be considered as a choice for primary key?
7. What is the full form of SQL?
8. What is the full form of DDL?
9. What does DML stand for?
10. Which of the below given tasks cannot be performed through Data Manipulation Language (DML) commands?
11. Which is the subset of SQL commands used to manipulate database structures, including tables?
12. Which sublanguage of SQL is used to define the structure of the relation, deleting relations and relating schemas?
13. Which sublanguage of SQL is used to query information and modify tuples in the database?
14. Which of the following is a DDL command?
15. Consider following SQL statement. What type of statement is this?
SELECT * FROM employee;
16. In SQL, which of the following will select only one copy of duplicable rows?
17. ______ keyword is used to eliminate duplicates from the query result.
18. Best data type for fixed length alphanumeric field in MySQL?
19. SELECT ______ dept_name FROM Company; (Display unique values)
20. SELECT ______ dept_name FROM Company; (Display all values)
21. The ______ clause allows selecting rows satisfying a condition.
22. Which operator can take wildcard characters?
23. Which operator checks a value against a range?
24. Which SQL command retrieves data from table(s)?
25. Which clause is used to sort the query result?
26. By default, ORDER BY lists results in ______ order.
27. The ______ operator displays a record if all conditions are true.
28. The ______ operator displays a record if one condition is true.
29. Which subset of SQL is used to add, delete and modify data rows?
30. In SQL, which command is used to change table structure?
31. ______ defines rules regarding allowed values in columns.
