Python Database Connection String Examples MCQ. We covered all the Python Database Connection String Examples MCQ in this post for free so that you can practice well for the exam.
Install our MCQTUBE Android app from the Google Play Store and prepare for any competitive government exams for free.
We created all the competitive exam MCQs into several small posts on our website for your convenience.
You will get their respective links in the related posts section provided below.
Related Posts:
- Python Try Except Finally MCQ with Answers
- Python Exception Handling Interview Questions MCQ
- Free Python Exception Handling MCQ for Practice
Python Database Connection String Examples MCQ for Students
Which command is used to make a new database in SQLite?
a. CREATE DATABASE
b. CREATE TABLE
c. CREATE INDEX
d. None of these
Option d – None of these
In Python, which method is used to run an SQL statement using a database connection?
a. query()
b. execute()
c. run()
d. send()
Option b – execute()
What is the main role of a PRIMARY KEY in a database table?
a. It assigns a unique ID to each row in the table
b. It helps ensure the accuracy and consistency of data
c. It boosts the speed of database queries
d. None of these
Option a – It assigns a unique ID to each row in the table
Which one of the following is a type of relational database system?
a. MongoDB
b. SQLite
c. Redis
d. Cassandra
Option b – SQLite
What method do we use in Python to connect to a SQLite database?
a. connect() function from sqlite3 module
b. open() function from sqlite3 module
c. connect() function from os module
d. open() function from os module
Option a – connect() function from sqlite3 module
Why is the WHERE clause used in SQL?
a. To choose specific columns from a table
b. To arrange results in a particular sequence
c. To filter records based on a condition
d. None of these
Option c – To filter records based on a condition
What is the function of the GROUP BY clause in SQL?
a. To group results by a column or expression
b. To filter results using a condition
c. To sort output in ascending order
d. None of these
Option a – To group results by a column or expression
Which of the following correctly describes a database transaction?
a. It is a complete operation that either succeeds or is fully reversed
b. Transactions are not a part of database systems
c. Transactions can be partially applied in databases
d. None of these
Option a – It is a complete operation that either succeeds or is fully reversed
Which Python module is usually used to work with a MySQL database?
a. mysql
b. sqlite3
c. pymysql
d. MongoDB
Option c – pymysql
If a table has a foreign key and the referenced value is deleted, what happens?
a. The related record is also removed
b. The referenced record is changed
c. The deletion is stopped to protect data consistency
d. None of these
Option c – The deletion is stopped to protect data consistency
What SQL command is used to change data in an existing row?
a. UPDATE
b. DELETE
c. INSERT
d. SELECT
Option a – UPDATE
In Python, how can you find out how many rows an SQL operation affected?
a. By calling fetchall()
b. By checking the rowcount property of the cursor
c. By using execute()
d. None of these
Option b – By checking the rowcount property of the cursor
Which command is used to initialize a brand-new database in MySQL?
a. CREATE DATABASE
b. CREATE TABLE
c. CREATE INDEX
d. None of the above
Option a – CREATE DATABASE
What does the DESC keyword accomplish in an SQL query?
a. Filters records based on a condition
b. Arranges the output in descending order
c. Groups records by a particular column or expression
d. None of the above
Option b – Arranges the output in descending order
What does a primary key constraint guarantee in a relational database?
a. Each entry in the column is unique and not null
b. Each entry in the column is unique but may be null
c. Entries in the column are not null but can repeat
d. Entries in the column can be null and need not be unique
Option a – Each entry in the column is unique and not null
Which of the following accurately describes the SQLite database system?
a. It is a lightweight, serverless, and self-contained database engine
b. It is built for handling enterprise-level applications
c. It enables multiple users to access a single database simultaneously
d. None of the above
Option a – It is a lightweight, serverless, and self-contained database engine
In an UPDATE SQL statement, why is the WHERE clause used?
a. To choose which columns to modify
b. To set new values for columns
c. To determine which records should be updated
d. None of the above
Option c – To determine which records should be updated
Which of the following is a valid aggregate function in SQL?
a. COUNT()
b. SELECT()
c. INSERT()
d. UPDATE()
Option a – COUNT()
Which Python library is commonly used to connect with PostgreSQL databases?
a. psycopg2
b. sqlite3
c. MySQLdb
d. No library is necessary
Option a – psycopg2
What does the DISTINCT keyword do in an SQL query?
a. Filters rows based on certain criteria
b. Groups rows by column values or expressions
c. Removes repeated entries from the result set
d. None of the above
Option c – Removes repeated entries from the result set
Which command is used to create a fresh table in an SQLite database?
a. CREATE TABLE
b. CREATE DATABASE
c. CREATE INDEX
d. None of the above
Option a – CREATE TABLE
Why is the LIKE keyword used in SQL?
a. To filter results according to specific conditions
b. To group records based on expressions
c. To match specific patterns in column values
d. None of the above
Option c – To match specific patterns in column values
What role does a foreign key play in a database table?
a. It ensures each record has a unique identifier
b. It maintains referential integrity between linked tables
c. It speeds up database search operations
d. None of the above
Option b – It maintains referential integrity between linked tables
Which SQL statement is used to introduce a new column into an existing table?
a. ALTER
b. UPDATE
c. INSERT
d. None of the above
Option a – ALTER
In Python, which function is used to retrieve the next available row from the result of a database query?
a. fetchrow()
b. fetchnext()
c. fetchone()
d. None of the above
Option c – fetchone()
Why is the CASCADE option used in foreign key constraints?
a. To stop changes to the referenced key
b. To automatically remove related rows if the referenced row is deleted
c. To automatically update related rows if the referenced row changes
d. None of the above
Option b – To automatically remove related rows if the referenced row is deleted
Which SQL command is used to delete an entire table from a database?
a. DROP TABLE
b. DROP DATABASE
c. DELETE TABLE
d. None of the above
Option a – DROP TABLE
What does the AVG function compute in SQL?
a. The total number of rows returned
b. The average of a column’s numeric values
c. The largest value within a column
d. None of the above
Option b – The average of a column’s numeric values
What is the function of the WHERE clause in an SQL query?
a. To organize rows by column value
b. To sort data using a specified column
c. To apply a condition to filter the rows
d. None of the above
Option c – To apply a condition to filter the rows
Which command is used in SQL to enforce uniqueness on a column?
a. ALTER
b. CREATE UNIQUE
c. ADD CONSTRAINT
d. None of the above
Option c – ADD CONSTRAINT
What does the EXISTS keyword do in SQL?
a. Verifies the presence of a column in a table
b. Filters records based on a condition
c. Checks whether a subquery produces any results
d. None of the above
Option c – Checks whether a subquery produces any results
What is the role of the GROUP BY clause in SQL?
a. Filters the result set based on a rule
b. Orders data according to a column
c. Aggregates data by a column or expression
d. None of the above
Option c – Aggregates data by a column or expression
Which SQL command modifies current data in a table?
a. UPDATE
b. DELETE
c. INSERT
d. SELECT
Option a – UPDATE
What does the TRUNCATE TABLE command do in SQL?
a. Removes a single record from a table
b. Adds a new table to the database
c. Erases all rows from a table efficiently
d. None of the above
Option c – Erases all rows from a table efficiently
How would you categorize MySQL?
a. A programming language
b. A system for managing databases
c. A framework for building websites
d. A scripting language for server-side applications
Option b – A system for managing databases
Which Python library allows you to interact with a MySQL database?
a. sqlapi
b. mysqlapi
c. pymysql
d. mysqldb
Option c – pymysql
Which function is used to terminate a connection to a MySQL database when using pymysql?
a. close_connection()
b. disconnect()
c. close()
d. finish()
Option c – close()
What is the correct way to create a new database in MySQL with pymysql?
a. CREATE DATABASE database_name
b. USE database_name
c. ADD DATABASE database_name
d. NEW DATABASE database_name
Option a – CREATE DATABASE database_name
Why would you use the “ON DUPLICATE KEY UPDATE” clause in a MySQL statement?
a. To insert a new record if a duplicate key exists
b. To update the existing record if a duplicate key exists
c. To delete duplicate records
d. To skip any records with duplicate keys
Option b – To update the existing record if a duplicate key exists
Which SQL function returns the total number of entries in a MySQL table?
a. COUNT()
b. SUM()
c. AVG()
d. MAX()
Option a – COUNT()
How can you obtain column headers from a MySQL table using pymysql?
a. cursor.get_columns()
b. cursor.columns()
c. cursor.description
d. cursor.get_columns_info()
Option c – cursor.description
What does the “LIKE” keyword do in a MySQL query?
a. Combines two tables together
b. Applies filters based on conditions
c. Searches for specific patterns within column values
d. Clusters rows that share a common value
Option c – Searches for specific patterns within column values
How do you revert changes during a transaction using pymysql?
a. commit()
b. savepoint()
c. rollback()
d. undo()
Option c – rollback()
Which command returns just one row from a MySQL result set using pymysql?
a. fetch_one()
b. fetch_single()
c. fetch_row()
d. fetch_next()
Option a – fetch_one()
What role does the “HAVING” clause play in MySQL queries?
a. Groups data by shared values
b. Applies conditions to grouped records
c. Organizes results by specific order
d. Restricts how many rows are returned
Option a – Groups data by shared values
How do you establish a foreign key relationship in a MySQL table using pymysql?
a. FOREIGN KEY(column) REFERENCES table(column)
b. ADD FOREIGN KEY(column) REFERENCES table(column)
c. CREATE FOREIGN KEY(column) REFERENCES table(column)
d. LINK FOREIGN KEY(column) REFERENCES table(column)
Option b – ADD FOREIGN KEY(column) REFERENCES table(column)
Which SQL function identifies the highest value in a specific column?
a. COUNT()
b. SUM()
c. AVG()
d. MAX()
Option d – MAX()
What functions can be used in pymysql to handle NULL values in MySQL queries?
a. ISNULL()
b. NULLIF()
c. COALESCE()
d. IFNULL()
Option d – IFNULL()
What does the “GROUP BY” clause accomplish in a MySQL statement?
a. Applies filtering to individual rows
b. Sorts output by one or more fields
c. Restricts the number of output records
d. Aggregates records with the same value
Option d – Aggregates records with the same value
What is the correct method to insert several records at once in a MySQL table using pymysql?
a. insert_many()
b. add_rows()
c. executemany()
d. batch_insert()
Option c – executemany()
What does the LIKE %value% pattern help you do in MySQL?
a. Find values that exactly match a given text
b. Match all entries in a column
c. Find entries that begin with a specific text
d. Search for entries that include a specific substring
Option d – Search for entries that include a specific substring
What is the correct way to remove an entire MySQL database using pymysql?
a. DELETE DATABASE database_name
b. DROP DATABASE database_name
c. REMOVE DATABASE database_name
d. ERASE DATABASE database_name
Option b – DROP DATABASE database_name
Which SQL function helps find the smallest number in a column?
a. COUNT()
b. SUM()
c. AVG()
d. MIN()
Option d – MIN()
Using pymysql, how can you determine if a specific table exists in your MySQL database?
a. SELECT table_name FROM information_schema.tables WHERE table_name = ‘table’
b. CHECK TABLE ‘table’
c. DESCRIBE ‘table’
d. SHOW TABLES LIKE ‘table’
Option d – SHOW TABLES LIKE ‘table’
What does the NULL keyword indicate in MySQL?
a. An empty text string
b. A numeric value of zero
c. A value that is not known or has not been assigned
d. A universal match for any value
Option c – A value that is not known or has not been assigned
Which pymysql command can you use to add an index to a column in a MySQL table?
a. CREATE INDEX idx_name ON table(column)
b. INDEX table(column) AS idx_name
c. ADD INDEX column ON table
d. ADD idx_name TO INDEX ON table(column)
Option a – CREATE INDEX idx_name ON table(column)
In SQL, what is the use of the DISTINCT keyword?
a. Combines rows with the same value
b. Arranges results in a specific order
c. Removes repeated rows from the output
d. Restricts how many rows are shown
Option c – Removes repeated rows from the output
Which library is most commonly used in Python to connect with SQL-based databases?
a. SQLAlchemy
b. psycopg2
c. pyodbc
d. pandas
Option b – psycopg2
Which method is typically used in Python to initiate a connection with an SQL database?
a. create_connection()
b. connect()
c. open_connection()
d. establish_connection()
Option b – connect()
Which command lets you run an SQL statement through Python?
a. db.query()
b. cursor.execute()
c. run_query()
d. fetch_query()
Option b – cursor.execute()
Why is a cursor important in Python when working with SQL databases?
a. For pulling records from the database
b. For sending SQL statements to the database
c. For setting up a database connection
d. For building a new database
Option b – For sending SQL statements to the database
What method do you use in Python to get all the results from an SQL query?
a. cursor.retrieve()
b. fetchall()
c. fetch_query()
d. execute_query()
Option b – fetchall()
We covered all the Python Database Connection String Examples MCQ above in this post for free so that you can practice well for the exam.
Check out the latest MCQ content by visiting our mcqtube website homepage.
Also, check out:
- Python Dictionary Operations MCQ for Beginners
- Python Dictionary Methods MCQ with Answers
- Python Tuple Multiple Choice Questions for Beginners
