Which of following is fast, flexible and easy to work?

(a)

CSV

(b)

SQlite

(c)

Perl

(d)

Ruby

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

(a)

cursor ( )

(b)

lite ( )

(c)

connect ( )

(d)

connection ( )

Which method has a major role in working with python?

(a)

cursor ( )

(b)

connect ( )

(c)

execute ( )

(d)

close

The SQlite command opens the already created database is

(a)

Cursor

(b)

Sql-comm

(c)

Connect

(d)

Connection

Which of the following is a command to open the already created database from the statement connection = sqlite3.connect ("ABC.db")

(a)

ABC.db

(b)

connect

(c)

SQlite3

(d)

connection

Which of the following is used define a SQL command in SQlite3?

(a)

" "

(b)

" " " "

(c)

' '

(d)

" " " " "

A table column will be automatically auto incremented in SQlite3 by giving

(a)

KEY

(b)

PRIMARY KEY

(c)

PRIMARY COLUMN

(d)

KEY PRIMARY

The command to populate the table is

(a)

ADD

(b)

APPEND

(c)

INSERT

(d)

ADDROW

Which of the following statement in SQL is used to retrieve or fetch data from a table in a database?

(a)

select

(b)

inset

(c)

create

(d)

fetch

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

(a)

fetch ( )

(b)

fetchrowsAll ( )

(c)

fectchmany ( )

(d)

fetchall ( )

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 of the following clause will not work in SQlite?

(a)

DISTINCT

(b)

HAVING

(c)

FETCHALL

(d)

WHERE

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

(a)

UNIQUE

(b)

DISTINCT

(c)

GROUPBY

(d)

HAVING

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

(a)

WHERE

(b)

EXTRACT

(c)

CONNECT

(d)

CURSOR

Which of the following clause is often used with aggregate functions to group the result?

(a)

ORDERBY

(b)

WHERE

(c)

GROUP BY

(d)

DISTINCT