Python MCQ Quiz Hub

1. For what purpose sqlite3 is used ?
Front end
Back end
CLI
GUI

2. Sqlite3 in python is the module by which we can handle
Database
GUI
CLI
Connectivity

3. Which of the correct way to install the sqlite3 in python ?
install sqlite3
pip install sqlite3
pip sqlite3 install python
None of the above

4. Correct way to import the sqlite3 in the program ?
import sqlite3
import sqlite3 as s
from sqlite3 import *
All of the above

5. Which of the following is not the correct way to import the sqlite3 ?
import sqlite3 as s
import sqlite3 as p
import sqlite3 as sq
None of the above

6. How we can call the function of sqlite3, if we import by import sqlite3 as sq ?
sqlite.function()
function()
sq.function()
None of the above

7. By using sqlite3 , we can store our data on
local
Global
Server
None of the above

8. To open or connect with the database, which function we used or call at runtime ?
open()
connect()
database()
All of the above

9. connect() function in sqlite3 is used for ?
To connect the database
To open the database
To create a database
All of the above

10. Which of the following function are used to close the database?
exit()
def()
disconnect()
close()

11. close() function in sqlite3 is used for the :
To close the query
To close the table
To close the database
None of the above

12. Which of the following is correct syntax of the connect() function in sqlite3?
sqlite.connect()
sqlite.connect.database
sqlite.connect(database)
None of the above

13. Which of the following tool are provided by the python to manage the database ?
sqlite3
MySql
infomix
All of the above

14. Which of the following function are used to execute the query in sqlite3 python ?
execute()
query()
executequery()
run()

15. Correct way to run the query in Python sqlite3 is :
sqlite3.execute.query
sqlite3.execute(query)
sqlite.run.execute(query)
None of the above

16. For fetch the data, which function we use to run the select query ?
fetch()
rawquery()
executequery()
execute()

17. Which of the following is not the function of the sqlite3 in python ?
connect()
close()
execute()
raw()

18. What is the correct statement about the RawQuery() function in sqlite3 in python ?
It is used to fetch the row from the table
It is used to execute the select query in the table
It is undefined function in python sqlite3
1 and 2

19. Which keyword we use to fetch the data from the table in database ?
fetch
select
raw
All of the above

20. What the following query does ?, select count(*) from table
It return all rows data
It return number of rows in table
It return number of columns in table
It will give an error