PYTHON DATABASE CONNECTIVITY

Mandatory arguments required to connect any database from pyton

• username, password, hostname, port , database name

• user name, password

• user name, password, host name

• user name, password, host name, database name

Which method of cursor class is used to fetch records from the table

• cur.fetchall()

• cur.fetchone()

• cur.fetchmnay()

• cur.fetch()

What is the full form of SQL

• Structured Quick Language

• Structured Query Language

• Structured Query Linking

• Structured Query List

In sql, which command is used to check host name?

• select current_user;

• select currentuser();

• select curret_user();

• select current_user()

SQL command for list databases.

• show all;

• show all databases;

• show databases;

• show database;

select the correct statement in python to check SQL connectivity status.

• if con_is.connected():

• if con.is_connected():

• if con_isconnected()

• if con.is_connected

select the correct statement to install sql connector library

• pip install mysql

• pip install mysql.connect

• pip install mysql-connector

• pip install mysql-connect-python

Which library is used to connect python with MySQL? Write an import statement

• import mysql _connector.connect

• import mysql.connector() as msq

• import mysql.connector

• import mysql.connector()

Which function is used to create a cursor object?

• cur=concursor()

• cur=con.cursor()

• cur=con.cursor

• cur=con.mycurosr

select the correct sql statement for print records from a database table emp

• select all from emp

• select * from emp

• select * from emp;

• select * from emp( );