Question :- By using sqlite3 , we can store our data on

1.local

2.Global

3.Server

4.None of the above

Question :- close() function in sqlite3 is used for the :

1.To close the query

2.To close the table

3.To close the database

4.None of the above

Question :- connect() function in sqlite3 is used for ?

1.To connect the database

2.To open the database

3.To create a database

4.All of the above

Question :- Correct way to import the sqlite3 in the program ?

1.import sqlite3

2.import sqlite3 as s

3.from sqlite3 import *

4.All of the above

Question :- Correct way to run the query in Python sqlite3 is :

1.sqlite3.execute.query

2.sqlite3.execute(query)

3.sqlite.run.execute(query)

4.None of the above

Question :- For fetch the data, which function we use to run the select query ?

1.fetch()

2.rawquery()

3.executequery()

4.execute()

Question :- For what purpose sqlite3 is used ?

1.Front end

2.Back end

3.CLI

4.GUI

Question :- How we can call the function of sqlite3, if we import by import sqlite3 as sq ?

1.sqlite.function()

2.function()

3.sq.function()

4.None of the above

Question :- Sqlite3 in python is the module by which we can handle

1.Database

2.GUI

3.CLI

4.Connectivity

Question :- To open or connect with the database, which function we used or call at runtime ?

1.open()

2.connect()

3.database()

4.All of the above

Question :- What is the correct statement about the RawQuery() function in sqlite3 in python ?

1.It is used to fetch the row from the table

2.It is used to execute the select query in the table

3.It is undefined function in python sqlite3

4.1 and 2

Question :- What the following query does ?, select count(*) from table

1.It return all rows data

2.It return number of rows in table

3.It return number of columns in table

4.It will give an error

Question :- Which keyword we use to fetch the data from the table in database ?

1.fetch

2.select

3.raw

4.All of the above

Question :- Which of the correct way to install the sqlite3 in python ?

1.install sqlite3

2.pip install sqlite3

3.pip sqlite3 install python

4.None of the above

Question :- Which of the following function are used to close the database?

1.exit()

2.def()

3.disconnect()

4.close()

Question :- Which of the following function are used to execute the query in sqlite3 python ?

1.execute()

2.query()

3.executequery()

4.run()

Question :- Which of the following is correct syntax of the connect() function in sqlite3?

1.sqlite.connect()

2.sqlite.connect.database

3.sqlite.connect(database)

4.None of the above

Question :- Which of the following is not the correct way to import the sqlite3 ?

1.import sqlite3 as s

2.import sqlite3 as p

3.import sqlite3 as sq

4.None of the above

Question :- Which of the following is not the function of the sqlite3 in python ?

1.connect()

2.close()

3.execute()

4.raw()

Question :- Which of the following tool are provided by the python to manage the database ?

1.sqlite3

2.MySql

3.infomix

4.All of the above