Class 12 Interface Python with MySQL MCQ | Interface Python with MySQL Quiz Class 12

Preview

Class 12 Interface Python with MySQL MCQ | Interface Python with MySQL Quiz Class 12



10
Created on By Lucky

Class 12 Interface Python with MySQL MCQ Quiz

1 / 26

A DELETE or UPDATE or INSERT query require commit() of to make changes in the database.

2 / 26

The cursor.rowcount() returns how many rows has been fetched through fetch..() methods from the cursor.

3 / 26

The cursor.rowcount gives the count of records in the result.

4 / 26

The SQLquery upon execution via established database connection return chunks.

5 / 26

With creation of a database connection object from within a Python program database starts.

6 / 26

______ method executes a database query from within Python.

7 / 26

______ method create a cursor from within Python.

8 / 26

_______ SQL query can be used to insert a record in database table through Python code.

9 / 26

A connectivity package such as _____ must be imported before writing database connectivity Python code.

10 / 26

The running of SQL query through  database cursor results into all the records returned in the form of ______.

11 / 26

The ______ returns how many rows have been fetched using various fetch methods.

12 / 26

After establishing database connection, database _____ is created so that the SQL query may execute through it to obtain resultset.

13 / 26

After importing mysql.connector, first of all ___ ___ is established using connect().

14 / 26

The ____ refers to a logical set of records that are fetched from the database by executing an SQL query and made available to the application program.

15 / 26

A ___ ___ is a special control structure that facilitates the row by row processing of records in the Resultset, i.e. the set of records retrieved as per query.

16 / 26

A database ___ ___ controls the connection to the database. It represents a unique session with a database connected from within a script/program.

17 / 26

To reflect the changes made in the database permanently, you need to run <connection>. ______ method.

18 / 26

To run an SQL query from within Python, you may use <cursor>. ______ method.

19 / 26

To fetch multiple record from the resultset, you may use <cursor>. ______  method.

20 / 26

To fetch one record from the resultset, you may use <cursor>. ______  method.

21 / 26

To obtain all the records retrieved, you may use <cursor> _____ method .

22 / 26

Which of the following is not a legal method for fetching records from database from within Python ?

23 / 26

____ method is used to close database connection in Python code.

24 / 26

The set of records retrieved after executing an SQL query over an established database connection is called ___.

25 / 26

A database must exist before establishing a database connection with it using Python code.

26 / 26

In order to open a connection with MYSQL database from within Python using mysql.connector package, ___ function is used.

Your score is

The average score is 48%

0%



 

Lesson tags: Class 12 Interface Python with MySQL MCQ Quiz, Interface Python with MySQL MCQ, Interface Python with MySQL Quiz
Back to: CBSE class 12 Computer Science notes