SQL & Python Connectivity

Full form of API

• Application Process Interchange

• Application Programs Interchange

• Application Process Interface

• Application Programming Interface

Connector Library to connect MySQL with Python IDLE is

• pymysql

• mysql.connector

• both a and b

• none of these

To display all the databases of MySQL with the help of cursor mycursor , command will be

• mycursor.execute("SHOW DATABASES")

• mycursor.execute("DESC DATABASES")

• mycursor.executes("SHOW DATABASES")

• mycursor.execute("SHOW ALL DATABASES")

Correct the error if any

mycursor = mydb.cursor()

mycursor.execute("CREATE TABLE customers (name VARCHAR(25), 'address' VARCHAR(55))")

• mycursor.execute('CREATE TABLE customers (name VARCHAR(25), 'address' VARCHAR(55))')

• mycursor.execute("CREATE TABLE customers (name VARCHAR(25), address VARCHAR(55))')

• mycursor.execute("CREATE TABLE customers (name VARCHAR(25), address VARCHAR(55));")

• mycursor.execute("CREATE TABLE customers (name VARCHAR(25), address VARCHAR55))")

After inserting the data we need to issue

• rollback

• set autocommit

• mycur.commit(1)

• mycur.commit()

To close a connection (CON) we Use

(a)  

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