Hello my dear readers, In this article Chapter wise Quiz Informatics Practices Class 12 I will provide you with some questions based on Informatics practices class 12. So let’s start now and assess yourself. Best of luck!

Chapter wise Quiz Informatics Practices Class 12

Let’s begin Chapter-wise Quiz Informatics Practices Class 12 with the topic series quiz.

120
Created on By 327b17da83fb23335e447ee18d77e3f1?s=32&d=mm&r=gtutorialaicsip

Data handling using pandas Series Class 12 Quiz

tail spin

1 / 20

Which of the following one of the most popular data structures of python pandas support tabular data?

2 / 20

Which of the following is one dimensional data structure of Pandas?

3 / 20

The word pandas is derived from

4 / 20

Which of the following is the correct command to install pandas on the command line?

5 / 20

The module allows working with a set of collections and arrays in python. Select an appropriate module name.

6 / 20

Which of the following is one of the data structures of python pandas?

7 / 20

Which of the following is not a type of data structure supported by Pandas?

8 / 20

A ________ is a specialized format to store, organize, process and manage the data in a systematic way.

9 / 20

Which of the following is correct about series indexes?

10 / 20

Which of the following is correct about the series data?

11 / 20

The data labels in series are numeric values starting from 0 by default is known as _____________

12 / 20

Which of the following statement is used to change the marks of Nadiya to 25?

 

dataframe series

13 / 20

Which of the following is correct statement to display 3 elements using slicing from a series object - s?

14 / 20

In which of the following method user extract a part of a series by specifying the start and end parameters with the series name?

15 / 20

___________ takes any user defined label index to access data from a series.

16 / 20

Nishchay has created a series using a dictionary. As you know the dictionary is key: value pair. So when a series is created with a dictionary, how the keys are associated with dictionaries?

17 / 20

Consider a situation when the value and indexes of a series are not the same. Which of the following error is raised?

18 / 20

Priya wants to create a series from the one-dimensional array. Which of the following syntax is correct? (Assume numpy module is imported as np)

19 / 20

Which of the following is the correct syntax to create a series with three elements?

20 / 20

Select a statement to print the last 3 elements of a series using slicing for the below given series:

dataframe series

Your score is

The average score is 67%

0%

MCQ Questions Dataframe

0%
80
Created on By 327b17da83fb23335e447ee18d77e3f1?s=32&d=mm&r=gtutorialaicsip

Python Pandas Dataframe Quiz 1

tail spin

1 / 20

To access each row of dataframe individually, which of the following function is used?

2 / 20

Dataframe is ________ data structure of Python Pandas.

3 / 20

Which of the following statement is correct for iloc?

4 / 20

Manisha is a student of class XII. She is learning about the attributes of DataFrame. Help her to memorize the concepts and find which of the following is not a dataframe attribute from following.

5 / 20

Nadiya wants to delete row number 4 and 6  from dataframe DF. Select an appropriate option for her.

6 / 20

Shiv has created a dataframe with 6 rows. Now he wants to display alternate rows from dataframe. Which of the following is the correct statement for him?

7 / 20

Which of the following statement is not correct for the pandas dataframe?

8 / 20

Consider the following code:

import pandas as pd
d={'A':[10,20],'B':[30,40],'C':[50,60]}
df=pd.DataFrame(d)
df[:]=100

Select an appropriate option for what this code will do.

9 / 20

Hemang wants to create an empty dataframe. Select appropriate option for him:

10 / 20

Sumona wants to remove a row with the label 'R1' from dataframe DF. Select the correct option from the following:

11 / 20

Adnan wants to display the total number of elements present in the DataFrame. Which of the following attribute is used to accomplish his task?

12 / 20

Isha wants to create a dataframe from the below given lists:

l1=['Aman',56]

l2=['Chaman',67]

Help him to create a dataframe using which one of the following functions?

13 / 20

Kaushal wants to display the first n number of rows from a dataframe DF. Which of the following statement is correct?

14 / 20

Dataframe is intersection of ________ and ___________

15 / 20

Bablu is trying to access a column from dataframe. But the column does not exist in the dataframe. Which of the following error will be returned?

16 / 20

Kish wants to delete a column labeled 'C1' from dataframe DF. Which of the following command can be used to delete a column?

17 / 20

Which of the following is not a correct way to create a dataframe?

18 / 20

Laksh wants to display row labels of DataFrame df. Suggest to him an option from the following.

19 / 20

Which of the following is not an option to add a new row into a Dataframe DF?

20 / 20

Krish has to select an option to create a dataframe. So he needs to import required module for the same. Which of the following is a correct statement?

Your score is

The average score is 50%

0%

Important MCQ Questions Data Visualization

14
Created by 327b17da83fb23335e447ee18d77e3f1?s=32&d=mm&r=gtutorialaicsip

Important MCQ Questions Data Visualization Class 12

tail spin

Please provide your correct name and email address:

1 / 30

1. Jaimit is trying to import matplotlib into his program. Help him by select an appropriate option:

2 / 30

2. Kaushikee wants to create a figure using pyplot. Suggest her the function which is used to create pyplot.

3 / 30

3. Which of the following python library helps to plot data on chart?

4 / 30

4. A ____________ plot is used to visualize growth or decline in data over a time interval.

5 / 30

5. Which of the following is not a part of plot figure?

6 / 30

6. Which of the following is an example of visualization in our routine life?

7 / 30

7. Which of the following is not a valid letter for color?

8 / 30

8. A _________ is the overall window where the outputs of pyplot functions are plotted.

9 / 30

9. Laksh wants to show grid lines for the chart. Which of the following is the correct syntax to complete his task?

10 / 30

10. Which chart is useful to plot the data that shows the comparison?

11 / 30

11. Krish wants to save the figure generated by the plot function. Suggest to him an appropriate function to accomplish his task from the following:

12 / 30

12. Krishn is working on a chart. He wants to display chart with the names and colors of each series of data. Help him by selecting a function to fulfill his needs.

13 / 30

13. The values marked on the horizontal axis are called ____________

14 / 30

14. A _______ is any symbol that represents a data value in a line chart or a scatter plot.

15 / 30

15. Consider the following statement:

import matplotlib.pyplot as plt

Here plt is considered as

16 / 30

16. Which of the following letter is used to apply black color to chart lines or bars?

17 / 30

17. Which of the following is not a valid marker symbol?

18 / 30

18. The default width of the line is _____ pixels.

19 / 30

19. Which of the following is not a valid line style?

20 / 30

20. While plotting data from dataframe the index will be automatically placed at ________ on the chart.

21 / 30

21. To apply marker as filled X wich of the following symbol is used?

22 / 30

22. Which of the following parameter of the plot() method accepts a string indicating the type of plot?

23 / 30

23. A bar chart contains

24 / 30

24. Which of the following letter is used to apply marker as plus (filled)?

25 / 30

25. ________ are column-charts, where each column represents a range of values, and the height of a column corresponds to how many values are in that range.

26 / 30

26. Shiv wants to create a bar chart for month-wise sales reports. Which of the following function help him to his job?

27 / 30

27. The purpose of plotting data is

28 / 30

28. The figure parameter in plot function indicates

29 / 30

29. To plot data on a histogram, the data is sorted into ___________

30 / 30

30. In the following statement pyplot is considered as:

import matplotlub.pyplot

Your score is

The average score is 46%

0%

Important MCQ questions Database Query using SQL

23
Created on By 327b17da83fb23335e447ee18d77e3f1?s=32&d=mm&r=gtutorialaicsip

Database Query using SQL

tail spin

1 / 31

1. Krishn is working on a table that contains a column with short forms in lower letters. Now he is asked to display them into capital letters. Which of the function(s) help him?

i) upper()

ii) ucase()

iii) capital()

iv caps()

2 / 31

2. Which of the following numeric/math function?

3 / 31

3. Predict the output for given query:

select round(25.60,-1);

4 / 31

4. What will be the output of the following query?

select mid('informatics practices',3,3);

5 / 31

5. What will be the output of following query?

select power(5,0)

6 / 31

6. Shiv wants to extract the first 3 letters from "TutorialAICSIP". Select the appropriate query for the same.

i) select left('TutorialAICSIP',3)

ii) select mid('TutorialAICSIP',1,3)

iii) select sub('TutorialAICSIP',1,3)

iv) select first('TutorialAICSIP',3)

7 / 31

7. ____________ is used to perform some particular task and it returns zero or more values as a result.

8 / 31

8. Single-row functions are also known as ______________ functions.

9 / 31

9. Select the output for the following:

select left('Informatics Practices',4)

10 / 31

10. Which of the following is a scalar function?

11 / 31

11. What will be the output of the following query?

select instr('Informatics Practices','for')

12 / 31

12. Which function is used to remove the extra spaces from the string from the beginning and end?

13 / 31

13. Select a function that returns a number of characters of the specified string.

14 / 31

14. Which of the following is not a category of functions in MySQL?

15 / 31

15. What will be the output of:

select lower('IP')

16 / 31

16. Which of the following is string function?

17 / 31

17. What will be the output of the following query?

select power(2,-2);

18 / 31

18. What will be the output of following query?

select round(5.54785,1);

19 / 31

19. Which function is used to extract a word starting from a specific position to a number of characters from the string in SQL?

i) mid()

ii) sub()

iii) substr()

 

20 / 31

20. Krish has a salary column in emp. This salary is given as a monthly salary. Now he has computed daily salary and wants to display leftover value. Suggest to him a suitable function to perform this task.

21 / 31

21. Which of the following functions are applied on a single value and return a single value?

22 / 31

22. Which function returns n number of characters from the end of the string?

23 / 31

23. Shiv is working on a table of a team India which contains records of the T20 World cup. He computed the net run rate but it is coming to 5.98776544. Now his teacher asked him to display the result with two decimal places only. Suggest to him a suitable function for the same.

24 / 31

24. Which of the following function is a date function?

25 / 31

25. What will be the output of the following:

select pow(insrt('TutorialAICSIP','t'),2)

26 / 31

26. Laksh has written these queries:

i) select mod(56,3);

ii) select mod(2,5);

iii) select mod(5,0)

What are the correct outputs:

27 / 31

27. Which SQL function returns n number of characters from the beginning of the string?

28 / 31

28. What will be the output of the given query:

select trim(5 from 55255255);

29 / 31

29. What is the output of the given query?

select instr('Informatics Practices','Com')

30 / 31

30. Adnan wants to compute the cube of the specific column from the table. Which function he can use?

31 / 31

31. what will be the output of the following query?

select round(25.56,0);

Your score is

The average score is 50%

0%

Leave a Reply

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