By using sqlite3 , we can store our data on
1.local
2.Global
3.Server
4.None of the above
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
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
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
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
For fetch the data, which function we use to run the select query ?
1.fetch()
2.rawquery()
3.executequery()
4.execute()
For what purpose sqlite3 is used ?
1.Front end
2.Back end
3.CLI
4.GUI
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
Sqlite3 in python is the module by which we can handle
1.Database
2.GUI
3.CLI
4.Connectivity
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
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
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
Which keyword we use to fetch the data from the table in database ?
1.fetch
2.select
3.raw
4.All of the above
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
Which of the following function are used to close the database?
1.exit()
2.def()
3.disconnect()
4.close()
Which of the following function are used to execute the query in sqlite3 python ?
1.execute()
2.query()
3.executequery()
4.run()
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
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
Which of the following is not the function of the sqlite3 in python ?
1.connect()
2.close()
3.execute()
4.raw()
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