Python/sqlite3 Sample Test,Sample questions

Question:
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 01:26:26


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

Posted Date:-2019-06-05 01:30:01


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

Posted Date:-2019-06-05 01:28:17


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

Posted Date:-2019-06-05 01:23:36


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

Posted Date:-2019-06-05 01:36:17


Question:
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 01:37:45


Question:
For what purpose sqlite3 is used ?

1.Front end

2.Back end

3.CLI

4.GUI

Posted Date:-2019-06-05 01:20:51


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

Posted Date:-2019-06-05 01:25:46


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

1.Database

2.GUI

3.CLI

4.Connectivity

Posted Date:-2019-06-05 01:21:37


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

Posted Date:-2019-06-05 01:27:23


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

Posted Date:-2019-06-05 01:42:47


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

Posted Date:-2019-06-05 01:45:20


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

Posted Date:-2019-06-05 01:43:48


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

Posted Date:-2019-06-05 01:22:36


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

1.exit()

2.def()

3.disconnect()

4.close()

Posted Date:-2019-06-05 01:29:12


Question:
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 01:35:03


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

Posted Date:-2019-06-05 01:32:14


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

Posted Date:-2019-06-05 01:24:26


Question:
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 01:40:55


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

Posted Date:-2019-06-05 01:33:35


More MCQS

  1. Function
  2. GUI in python
  3. Operators
  4. Data type in python
  5. loops in python
  6. Numpy
  7. sqlite3
  8. Library
  9. Pandas
  10. Python MCQ
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!