R4RIN – MCQs, Mock Tests | Python Python MCQS

For what purpose sqlite3 is used ?

1. Front end
2. Back end
3. CLI
4. GUI

✅ Correct Answer: 2

Sqlite3 in python is the module by which we can handle

1. Database
2. GUI
3. CLI
4. Connectivity

✅ Correct Answer: 1

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

✅ Correct Answer: 2

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 Answer: 4

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

✅ Correct Answer: 4

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

✅ Correct Answer: 3

By using sqlite3 , we can store our data on

1. local
2. Global
3. Server
4. None of the above

✅ Correct Answer: 1

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

✅ Correct Answer: 2

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 Answer: 4

Which of the following function are used to close the database?

1. exit()
2. def()
3. disconnect()
4. close()

✅ Correct Answer: 4

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

✅ Correct Answer: 3

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

✅ Correct Answer: 3

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

✅ Correct Answer: 4

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

1. execute()
2. query()
3. executequery()
4. run()

✅ Correct Answer: 1

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

✅ Correct Answer: 2

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

1. fetch()
2. rawquery()
3. executequery()
4. execute()

✅ Correct Answer: 4

Which of the following is not the function of the sqlite3 in python ?

1. connect()
2. close()
3. execute()
4. raw()

✅ Correct Answer: 4

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

✅ Correct Answer: 3

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

1. fetch
2. select
3. raw
4. All of the above

✅ Correct Answer: 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

✅ Correct Answer: 2

Python MCQ Quiz Hub

Python MCQS - sqlite3