TN 12th Computer Science Unit 5 - Data visualization using pyplot : line chart, pie chart and bar chart - New Sample Question Papers Study Material - QB365 Set A

1.

Which SQlite clause is used to filter data base on the group functions?

(a)

WHERE

(b)

HAVING

(c)

ORDER

(d)

FILTER

2.

Which of the following clause will not work in SQlite?

(a)

DISTINCT

(b)

HAVING

(c)

FETCHALL

(d)

WHERE

3.

In Python matplotlib is a

(a)

control structure

(b)

dictionary

(c)

library

(d)

list

4.

Which method uses the SQL command to get all the data from the table?

(a)

get

(b)

select

(c)

execute

(d)

Query

5.

Which of the following is not a type of visualization under matplotlib?

(a)

Histogram

(b)

Pie chart

(c)

Box plot

(d)

SQLite

6.

The function to make a pie chart with Matplotlib:

(a)

plt.bar()

(b)

pie.plt()

(c)

bar.plt()

(d)

plt.pie()

7.

_____________ is a type of chart which displays information as a series of data points connected by straight line segments.

(a)

csv

(b)

Piechart

(c)

Barchart

(d)

All the above

(e)

Line Chart or Line Graph

8.

Which of the following module should be imported to visualize data and information in Python?

(a)

csv

(b)

getopt

(c)

mysql

(d)

matplotlib

9.

Which of the following feature is used to represent data and information graphically?

(a)

Data List

(b)

Data Type

(c)

Classes and Objects

(d)

Data Visualization

10.

Which is a python package used for 2D charts?

(a)

matplotlib.pyplot

(b)

matplotlib.pip

(c)

matplotlib.numpy

(d)

matplolib.plt

11.

Which of the following interface used for interfacing with C programs?

(a)

MicGW

(b)

Boost

(c)

Ctypes

(d)

Cython

12.

Which of the following is a scripting language?

(a)

Ruby

(b)

ASP

(c)

TCI

(d)

All of these

13.

Which of the following is not a scripting language?

(a)

Ruby

(b)

DBMS

(c)

Perl

(d)

JavaScript

14.

Which of the following function retrieves the average of a selected column of rows in a table?

(a)

Add()

(b)

SUM()

(c)

AVG()

(d)

AVERAGE()

15.

Which of the following is a control structure used to traverse and fetch the records of the database?

(a)

Pointer

(b)

Key

(c)

Cursor

(d)

Insertion point

16.

Which of the following is an organized collection of data?

(a)

Database

(b)

DBMS

(c)

Information

(d)

Records

17.

The module which allows you to interface with the Windows operating system is

(a)

OS module

(b)

sys module

(c)

csv module

(d)

getopt module

18.

The expansion of API is

(a)

Application Programming Interpreter

(b)

Application Programming Interface

(c)

Application Performing Interface

(d)

Application Programming Interlink

19.

In Excel, the default CSV files should open automatically by

(a)

Single click

(b)

Right click

(c)

Double click

(d)

None of these

20.

Which of the following is not a scripting language?

(a)

JavaScript

(b)

PHP

(c)

Perl

(d)

HTML

21.

Which of the following is a human readable text file where each line has fields?

(a)

CSV file

(b)

CSV module

(c)

CSV sheet

(d)

CSV text

22.

The python file mode opens a file for exclusive creation:

(a)

w

(b)

x

(c)

b

(d)

a

23.

Making some changes in the data of the existing file or adding more data is called

(a)

Editing

(b)

Appending

(c)

Modification

(d)

Alteration

24.

Which of the following is a string used to terminate lines produced by writer() method of csv module?

(a)

Line Terminator

(b)

Enter key

(c)

Form feed

(d)

Data Terminator

25.

Which of the following module is provided by Python to do several operations on the CSV files?

(a)

py

(b)

xls

(c)

csv

(d)

os

26.

Which processing skills of SQL includes commands of access rights to creations and views of tables?

(a)

View definition

(b)

Integrity

(c)

Authorization

(d)

Transaction control

27.

Find out the odd man out :

(a)

MS SQL servers

(b)

Microsoft Access

(c)

IBM DB2

(d)

Dbase

28.

The original version of SQL is released in the year ______________

(a)

1970

(b)

1980

(c)

1986

(d)

1992

29.

The clause used to sort data in a database

(a)

SORT BY

(b)

ORDER BY

(c)

GROUP BY

(d)

SELECT

30.

The command to delete a table including the structure is

(a)

DROP

(b)

DELETE

(c)

DELETE ALL

(d)

ALTER TABLE

TN 12th Computer Science Unit 5 - Data visualization using pyplot : line chart, pie chart and bar chart - New Sample Question Papers Study Material - QB365 Set A

QB365 Student Learing Managemnet System

Std: 12th Standard - Computer Science

chapter: Unit 5 - Data visualization using pyplot : line chart, pie chart and bar chart - New - Sample Question Papers

Visit QB365-SLMS - https://www.qb365.in/slms/ Complete Questions and Answers

Questions:

Visit QB365-SLMS - https://www.qb365.in/slms/

Answers Key:

NEW MCQ Practice Test - Tamilnadu Stateboard Class 12

Computer Science Tamilnadu Stateboard Class 12 MCQ Practice Test

Tamilnadu Stateboard Class 12 MCQ Practice Test

12th Standard Study Materials