Interface Python with SQL Database Test

Result

Interface Python with SQL Database Test - 1

Score
-
out of -
Rank
-
out of -

TIME Taken - -

SHARING IS CARING

If our Website helped you a little, then kindly spread our voice using Social Networks. Spread our word to your readers, friends, teachers, students & all those close ones who deserve to know what you know now.

Weekly Quiz Competition

Question 1
1 / -0.25

Mandatory arguments required to connect any database from Python

A
Username, Password, Hostname, Database Name, Port.

B
Username, Password, Hostname.

C
Username, Password, Hostname, Database Name.

D
Username, Password, Hostname, Port.
Solution
To create a connection between the MySQL database and python application, the connect( ) function is used. The functions requires 4 parameters:
Hostname
Username
Password
Database name
Checking the options
(A) Username, Password, Hostname, Database Name, Port. - Port is not a parameter of the function connect( ).
(B) Username, Password, Hostname. - The parameter database name is missing.
(C) Username, Password, Hostname, Database Name. - All 4 parameters of the function connect( ) are present.
(D) Username, Password, Hostname, Port. - Port is not a valid parameter and the parameter database name is missing.
From the options given above, only option C has all the 4 parameters of function connect( ).
So, the correct answer is (C)
Question 2
1 / -0.25

Which method of cursor class is used to fetch limited rows from the table?

A
cursor.fetchsize(SIZE)

B
cursor.fetchmany(SIZE)

C
cursor.fetchall(SIZE)

D
cursor.fetchonly(SIZE)

Solution

Checking the options
(A) cursor.fetchsize(SIZE) - It is not a method of cursor class.
(B) cursor.fetchmany(SIZE) - It returns the number of rows specified by the size argument.
(C) cursor.fetchall(SIZE) - It returns all the rows of a query result.
(D) cursor.fetchonly(SIZE) - It is not a method of cursor class.
From the options given above, the function cursor.fetchmany(SIZE) is used to fetch limited rows from the table.
So, the correct answer is (B)
Question 3
1 / -0.25

Which method of cursor class is used to insert or update multiple rows using a single query?

A
cursor.executeall(query, rows)

B
cursor.execute(query, rows)

C
cursor.executemultiple (query, rows)

D
cursor.executemany(query, rows)

Solution

Checking the options:
(A) cursor.executeall(query, rows) - It is not a method of cursor class.
(B) cursor.execute(query, rows) - It executes the given SQL statement.
(C) cursor.executemultiple (query, rows) - It is not a method of cursor class.
(D) cursor.executemany(query, rows) - It executes more than one SQL statement together.
From the options given above, the function cursor.executemany(query, rows) is used to insert or update multiple rows using a single query
So, the correct answer is (D)
Question 4
1 / -0.25

Which method of cursor class is used to get the number of rows affected after any of the insert/ update/delete database operation executed from Python?

A
cursor.rowcount

B
cursor.getaffectedcount

C
cursor.rowscount

D
cursor.rcount

Solution

Checking the options
(A) cursor.rowcount - It returns the number of rows affected by DML statements.
(B) cursor.getaffectedcount - It is not a method of cursor class.
(C) cursor.rowscount - It is not a method of cursor class.
(D) cursor.rcount - It is not a method of cursor class.
From the options given above, the function cursor.rowcount is used to get the number of rows affected after any of the insert/update/delete database operations executed from Python.
So, the correct answer is (A)
Question 5
1 / -0.25

_______ is the set of records that are retrieved after execution of SQL query over an established database connection.

A
sqlresult

B
resultset

C
table

D
tuple

Solution

Checking the options
(A) sqlresult - It is not a valid term related to SQL.
(B) resultset - It refers to the logical set of records that are fetched from the database when executing an SQL query.
(C) table - It refers to a database object that contains all the data in the table in the form of rows and columns.
(D) tuple - It refers to a single row of a table in an SQL database.
From the options given above, resultset refers to the set of records that are retrieved after execution of SQL query over an established database connection.
So, the correct answer is (B)
Question 6
1 / -0.25

Which of the following is invalid method for fetching the records from database within Python?

A
fetchone()

B
fetchmany()

C
fetchall()

D
fetchmulti()

Solution

There are 3 methods used for fetching the records from a database within python.

Checking the options
(A) fetchone( ) - It is a valid method for fetching records from a database within python.
(B) fetchmany( ) - It is a valid method for fetching records from a database within python.
(C) fetchall( ) - It is a valid method for fetching records from a database within python.
(D) fetchmulti( ) - It is not a valid method for fetching records from a database within python.
Question 7
1 / -0.25

Which of the following method reflects the changes made in database permanently?

A
.done()

B
.final

C
.reflect()

D
.commit()

Solution

The commit( ) method in python is used to confirm the changes made by the user to a database.
Checking the options
(A) .done( ) - It is not a valid method used to reflect changes made in the database permanently.
(B) .final( ) - It is not a valid method used to reflect changes made in the database permanently.
(C) .reflect( ) - It is not a valid method used to reflect changes made in the database permanently.
(D) .commit( ) - This method used to reflect changes made in the database permanently .
So, the correct answer is (D)
Question 8
1 / -0.25

The special control structure that facilitates row by row processing of records in resultset.

A
Tuple

B
database cursor

C
connection

D
None of these

Solution

Checking the options
(A) Tuple - It refers to a single row of a table in an SQL database.
(B) database cursor - It is a database object that retrieves data from the result set one row at a time.
(C) connection - It refers to creating a link between the MySQL database and the python application.
(D) None of these
From the options given above, database cursor refers to the special control structure that facilitates row by row processing of records in resultset.
So, the correct answer is (B)
Question 9
1 / -0.25

Consider the following code:
importMySQLdb
d b = M y S Q L d b. c o n n e c t (‘l o c a l h o s t ’,
‘LIBMAN ’,‘Admin@pwd ’,‘library ’)
cursor=db.cursor(prepared=TRUE)
sql = “””Insert into table(‘MemId ’,
‘MemName ’,‘MemAdd ’,)values(‘%s ’,‘%s ’,‘%s ’, )”””
insert_value=[(‘1021 ’, ‘Ronit ’, ’12, Block A, Kaveri
Vihar ’),
(‘1022 ’, ‘Smriti ’, ‘12/9 Indira Puram ’)]
try:
cursor.executemany(sql,insert_value)
print(cursor.rowcount,“Recordsinserted ”)
db.commit()
except:
db.rollback()
cursor.close()
db.close()
Q. What of the following statement is connecting database server?

A
importMySQLdb

B
MySQLdb.connect

C
db.cursor

D
None of these

Solution

(A) importMySQLdb - Imports the required python module
(B) MySQLdb.connect - Connects the MySQL server to the python application
(C) db.cursor - Creates the cursor object which is used for executing the queries
(D) None of these
From the options given above, MySQLdb.connect creates a connection to the MySQL server.
So, the correct answer is (B)
Question 10
1 / -0.25

Consider the following code:
importMySQLdb
d b = M y S Q L d b. c o n n e c t (‘l o c a l h o s t ’,
‘LIBMAN ’,‘Admin@pwd ’,‘library ’)
cursor=db.cursor(prepared=TRUE)
sql = “””Insert into table(‘MemId ’,
‘MemName ’,‘MemAdd ’,)values(‘%s ’,‘%s ’,‘%s ’, )”””
insert_value=[(‘1021 ’, ‘Ronit ’, ’12, Block A, Kaveri
Vihar ’),
(‘1022 ’, ‘Smriti ’, ‘12/9 Indira Puram ’)]
try:
cursor.executemany(sql,insert_value)
print(cursor.rowcount,“Recordsinserted ”)
db.commit()
except:
db.rollback()
cursor.close()
db.close()
Q. The role of the statement ‘cursor=db.cursor ’is:

A
Create an instance of a cursor

B
Moves cursor row wise

C
Connects cursor to database

D
Prepares cursor to move

Solution

The statement ‘cursor=db.cursor ’is used to create an object ‘db ’of the cursor class.
Checking the options
(A) Create an instance of a cursor - It is a role of the given statement
(B) Moves cursor row wise - It is not a role of the given statement
(C) Connects cursor to database - It is not a role of the given statement
(D) Prepares cursor to move - It is not a role of the given statement
So, the correct answer is (A)

User

Question Analysis

Correct -
Wrong -
Skipped -

My Perfomance

Score
-
out of -
Rank
-
out of -

Re-Attempt Weekly Quiz Competition

Interface Python with SQL Database Test - 1

Result

Interface Python with SQL Database Test - 1

Score

-

Rank

-

SHARING IS CARING

Question 1

Username, Password, Hostname, Database Name, Port.

Username, Password, Hostname.

Username, Password, Hostname, Database Name.

Username, Password, Hostname, Port.

Solution

Question 2

cursor.fetchsize(SIZE)

cursor.fetchmany(SIZE)

cursor.fetchall(SIZE)

cursor.fetchonly(SIZE)

Solution

Question 3

cursor.executeall(query, rows)

cursor.execute(query, rows)

cursor.executemultiple (query, rows)

cursor.executemany(query, rows)

Solution

Question 4

cursor.rowcount

cursor.getaffectedcount

cursor.rowscount

cursor.rcount

Solution

Question 5

sqlresult

resultset

table

tuple

Solution

Question 6

fetchone()

fetchmany()

fetchall()

fetchmulti()

Solution

Question 7

.done()

.final

.reflect()

.commit()

Solution

Question 8

Tuple

database cursor

connection

None of these

Solution

Question 9

importMySQLdb

MySQLdb.connect

db.cursor

None of these

Solution

Question 10

Create an instance of a cursor

Moves cursor row wise

Connects cursor to database

Prepares cursor to move

Solution

User

Question Analysis

My Perfomance

Score

-

Rank

-

Results Announcement on: coming Monday

Stay Tuned: We’ll update you on your result via email or SMS.