Interface Python with MYSQL

Which connector is used for linking the database with Python code?

• PyMySQL-Connector

• PostSQL: connector

• YesSUL: Connector

• None of the above

To open a connector to Mysql database, which statement is used to connect with pymysql?

• connector

• connect

• password

• username

Which software is used for coding the Python language?

• Idea

• IDLE

• python Script

• Connector

Which command is used for counting the number of rows in a database?

• row

• rowcount

• count

• row_count

Name the method which is used for displaying only one resultset.

• fetchmany

• fetchno

• fetchall

• fetchone

To execute all the rows from the result set, which method is used?

• fetchmany

• fetchno

• fetchall

• fetchone

Pick the correct username used for logging in database.

• root

• local

• localhost

• none of these

Name the host name used for signing in the database.

• localhost

• localpost

• local

• connect

Which command is used for cleaning up the environment?

• .close

• .end

• .commit

• none of these

______ methods will return only one row from the result set in the form of a tuple containing a record. (write answer in lower case)