By using sqlite3 , we can store our data on
1.local
2.Global
3.Server
4.None of the above
Posted Date:-2019-06-05 08:26:26
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
Posted Date:-2019-06-05 08:30:01
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
Posted Date:-2019-06-05 08:28:17
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
Posted Date:-2019-06-05 08:23:36
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
Posted Date:-2019-06-05 08:36:17
For fetch the data, which function we use to run the select query ?
1.fetch()
2.rawquery()
3.executequery()
4.execute()
Posted Date:-2019-06-05 08:37:45
For what purpose sqlite3 is used ?
1.Front end
2.Back end
3.CLI
4.GUI
Posted Date:-2019-06-05 08:20:51
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
Posted Date:-2019-06-05 08:25:46
Sqlite3 in python is the module by which we can handle
1.Database
2.GUI
3.CLI
4.Connectivity
Posted Date:-2019-06-05 08:21:37
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
Posted Date:-2019-06-05 08:27:23
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
Posted Date:-2019-06-05 08:42:47
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
Posted Date:-2019-06-05 08:45:20
Which keyword we use to fetch the data from the table in database ?
1.fetch
2.select
3.raw
4.All of the above
Posted Date:-2019-06-05 08:43:48
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
Posted Date:-2019-06-05 08:22:36
Which of the following function are used to close the database?
1.exit()
2.def()
3.disconnect()
4.close()
Posted Date:-2019-06-05 08:29:12
Which of the following function are used to execute the query in sqlite3 python ?
1.execute()
2.query()
3.executequery()
4.run()
Posted Date:-2019-06-05 08:35:03
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
Posted Date:-2019-06-05 08:32:14
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
Posted Date:-2019-06-05 08:24:26
Which of the following is not the function of the sqlite3 in python ?
1.connect()
2.close()
3.execute()
4.raw()
Posted Date:-2019-06-05 08:40:55
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
Posted Date:-2019-06-05 08:33:35