SQLite falls under which database system?

(a)

Flat file database system

(b)

Relational Database system

(c)

Hierarchical database system

(d)

Object oriented Database system

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

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 all rows from the database table?

(a)

fetch ( )

(b)

fetchrowsAll ( )

(c)

fectchmany ( )

(d)

fetchall ( )

Which SQlite keyword is used to extract only those records that fulfill a specified condition?

(a)

WHERE

(b)

EXTRACT

(c)

CONNECT

(d)

CURSOR

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

What is the advantage of declaring a column as “INTEGER PRIMARY KEY”

What is master table?

Write a note or cursor. description.

How the cursor object is created?

Mention the difference between fetchone() and fetchmany()

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

Write the sqlite steps to connect the database.

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

Write a note on SELECT statement in SQL.

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