SQLite falls under which database system?

(a)

Flat file database system

(b)

Relational Database system

(c)

Hierarchical database system

(d)

Object oriented Database system

The most commonly used statement in SQL is

(a)

cursor

(b)

select

(c)

execute

(d)

commit

Which method is SQlite is used create a connection with a database file created?

(a)

cursor ( )

(b)

lite ( )

(c)

connect ( )

(d)

connection ( )

The SQlite command opens the already created database is

(a)

Cursor

(b)

Sql-comm

(c)

Connect

(d)

Connection

Which SQlite method is used to fetch the required number of rows in the database table?

(a)

fetch ( )

(b)

fetchamany ( )

(c)

fetchrows ( )

(d)

tablerows ( )

Which SQlite keyword is used to fetch only the unique value from database table?

(a)

UNIQUE

(b)

DISTINCT

(c)

GROUPBY

(d)

HAVING

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

(a)

WHERE

(b)

HAVING

(c)

ORDER

(d)

FILTER

The WHERE clause cannot be combined with

(a)

AND

(b)

OR

(c)

XOR

(d)

NOT

_________ is a simple relational database system.

(a)

Cython

(b)

Boost

(c)

MySQL

(d)

SQlite

________ has a native library of SQlite.

(a)

Python

(b)

C++

(c)

Java

(d)

C

__________ method run the SQL command to perform some action.

(a)

run

(b)

select

(c)

execution

(d)

execute

______ function returns the number of rows in a table satisfying the criteria specified in the where class?

(a)

Distinct

(b)

Count

(c)

Having

(d)

Counter

Count ( ) returns ________ if there were no matching rows.

(a)

0

(b)

1

(c)

NOT NULL

(d)

NULL

_______ SQlite command contain the details of each table column headings

(a)

cursor. description

(b)

cursor.connect

(c)

cursor.column

(d)

cursor.fieldname

In Python, the path of a file can be represented as__________.

(a)

/ or \\

(b)

\\ or /

(c)

\ or ?

(d)

// or ?

Mention the users who uses the Database.

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 a cursor in SQL and databases?

What is the reason behind defining a SQL command with triple quotes?

What is master table?

How will you sort the data in a table in an ordered way?

What is the use of AND, OR operators combined with WHERE clause?

Write a note or cursor. description.

Write the placeholders which supported by SQlite3 module Execute.

How the SQL DISTINCT class is helpful to you?

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.

Read the following details. Based on that write a python script to display department wise records
database name:- organization.db
Table name:- Employee
Columns in the table:- Eno, EmpName, Esal, Dept

Read the following details.Based on that write a python script to display records in desending order of
Eno
database name :- organization.db
Table name :- Employee
Columns in the table :- Eno, EmpName, Esal, Dept

Explain how the SELECT statement can be used along with GROUP BY class.

Write the sqlite steps to connect the database.

Explain how a connect to be made to a database (Academy through python SQlite3.

What is the use of aggregate functions used along with SELECT statement? What are they?

What is the purpose of using
(i) COUNT ( )
(ii) AVG ( )
(iii) SUM ( )
(iv) MAX ( )
(v) MIN ( )

Write a note on SELECT statement in SQL.

List the classes used in the SQL SELECT statement.

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

Write the Python script to display all the records of the following table using fetchmany()

Icode	ItemName	Rate
1003	Scanner	10500
1004	Speaker	3000
1005	Printer	8000
1008	Monitor	15000
1010	Mouse	700

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

Write a Python script to create a table called ITEM with following specification.
Add one record to the table.
Name of the database :- ABC
Name of the table :- Item
Column name and specification :-

I code	:-	Integer and act as primary key
Item Name	:-	Character with length 25
Rate	:-	Integer
Record to be added	:-	1008, Monitor, 15000

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