Which of the following provides modularity?

(a)

Datatypes

(b)

Subroutines

(c)

Classes

(d)

Abstraction

Which of the following are functions that build the abstract datatypet?

(a)

Constructors

(b)

Destructors

(c)

Selectors

(d)

All of these

________are the representation for Abstract Data types.

(a)

Objects

(b)

Classes

(c)

Functions

(d)

Lists

___________is a selective restriction of access to data in a program?

(a)

Control variable

(b)

System authentication

(c)

Access control

(d)

Module

How many components required to find the space required by an algorithm?

(a)

4

(b)

3

(c)

6

(d)

2

Pick odd one in connection with collection data type

(a)

List

(b)

Tuple

(c)

Dictionary

(d)

Loop

What is the use of type() function in python?

(a)

To create a Tuple

(b)

To know the type of an element in tuple.

(c)

To know the data type of python object

(d)

To create a list.

Which of the following DBMS components controls everything in a database?

(a)

Hardware

(b)

Square

(c)

Methods

(d)

Procedures

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

Which of the following creates an object which maps data to a dictionary?

(a)

listreader()

(b)

reader()

(c)

tuplereader()

(d)

DictReader ()

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

(a)

Editing

(b)

Appending

(c)

Modification

(d)

Alteration

Which of the following is not a scripting language?

(a)

JavaScript

(b)

PHP

(c)

Perl

(d)

HTML

Which is a programming language designed for integrating and communicating with other programming languages?

(a)

Modular language

(b)

Procedural language

(c)

Scripting language

(d)

Procedural language

Read the following code: Identify the purpose of this code and choose the right option from the following.
C:\Users\Your Name\AppData\Local\Programs\Python\Python36-32\Scripts>pip list

(a)

List installed packages

(b)

list command

(c)

Install PIP

(d)

packages installed

Identify the right type of chart using the following hints.
Hint 1: This chart is often used to visualize a trend in data over intervals of time.
Hint 2: The line in this type of chart is often drawn chronologically.

(a)

Line chart

(b)

Bar chart

(c)

Pie chart

(d)

Scatter plot

Name the four collections of data types in python programming language.

Differentiate data and information.

Write a note on data query language.

How will assign a default value for the table field in a data base?

What is the theoretical difference between Scripting language and other programming language?

List some scripting language

List the components of DBMS

Write the different categories of SQL commands.

Write a Python program to read a CSV file with default delimiter comma (,).

How will you save the CSV file in MS-Excel?

What is SQLite?What is it advantage?

List the classes used in the SQL SELECT statement.

Consider the following employee table. Write SQL commands for the qtns.(i) to (v).

EMP CODE	NAME	DESIG	PAY	ALLOWANCE
S1001	Hariharan	Supervisor	29000	12000
P1002	Shaji	Operator	10000	5500
P1003	Prasad	Operator	12000	6500
C1004	Manjima	Clerk	8000	4500
M1005	Ratheesh	Mechanic	20000	7000

(i) To display the details of all employees in descending order of pay.
(ii) To display all employees whose allowance is between 5000 and 7000.
(iii) To remove the employees who are mechanic.
(iv) To add a new row.
(v) To display the details of all employees who are operators.

Write the processing skills of SQL.

Write a Python program to write a CSV File with custom quotes.

Write a program to read the CSV file with user defined delimiter.

Write in brief about SQLite and the steps used to use it.