Menu

HOME
LANGUAGE
- PYTHON
  - BASIC PYTHON
  - ADVANCE PYTHON

Python Mysql Database

Question 1

Which data type in mysql is used to store large text values?

Text

Varcher

Char

String

Question 2

In mysql databases, which statement is used to update existing records in a table?

MODIFY

CHANGE

UPDATE

ALTER

Question 3

What method in Pymysql is used to establish a connection to a mysql database?

Connect()

Create_connection()

Open_connection()

Inti_connection()

Question 4

Which sql statement is used to retrieve data from a mysql database?

GET

SELECT

RETRIEVE

FETCH

Question 5

Which python data type is commonly used to represent my sql's date data type?

Datetime.date

Str

Int

Float

Question 6

Which python library is commonly used to interact with mySQL databases?

Sqlite3

Pymysql

Psycopg2

Sqlalchemy

Question 7

What dose ACID stand for in the context of database transaction?

Atomicity,Consistency,Isolation, durability

All columns included data

Automated commitment in databases

All commands in database

Question 8

Which method in pymysql is used to execute an sql query?

Execute_query()

Run_query()

Execute()

Query()

Question 9

What dose sql stand for in the context of databases?

System query language

Structured query language

Sequential query language

Substantial query language

Question 10

What method is used in pymysql to commit a transaction to the mysql database?

Commit()

Save()

Apply()

Commit_transaction()

Name

Email

Phone

Post navigation

Previous Post Previous post:
Python Logging Introduction

Next Post Next post:
Python oracle database

brijesh

View all posts by brijesh →

brijesh

Leave a Reply Cancel reply