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()

The function that returns the largest value of the selected column is

(a)

MAX()

(b)

LARGE()

(c)

HIGH()

(d)

MAXIMUM()

Which of the following is called the master table?

(a)

sqlite_master

(b)

sql_master

(c)

main_master

(d)

master_main

The most commonly used statement in SQL is

(a)

cursor

(b)

select

(c)

execute

(d)

commit

Which of the following clause avoide the duplicate?

(a)

Distinct

(b)

Remove

(c)

Where

(d)

GroupBy

Which method is used to connect a database? Give an example.

Write the command to populate record in a table. Give an example.

Which method is used to fetch all rows from the database table?

What is SQLite?What is it advantage?

Mention the difference between fetchone() and fetchmany()

What is the use of Where Clause.Give a python statement Using the where clause.

hat is the use of HAVING clause. Give an example python script

Consider the following table Supplier and item .Write a python script for (i) to (ii)

SUPPLIER
Suppno	Name	City	Icode	SuppQty
S001	Prasad	Delhi	1008	100
S002	Anu	Bangalore	1010	200
S003	Shahid	Bangalore	1008	175
S004	Akila	Hydrabad	1005	195
S005	Girish	Hydrabad	1003	25
S006	Shylaja	Chennai	1008	180
S007	Lavanya	Mumbai	1005	325

i) Display Name, City and Itemname of suppliers who do not reside in Delhi.
ii) Increment the SuppQty of Akila by 40