What is the primary purpose of the mysqli_query() function in PHP?
A). Establishing a database connection
B). Inserting records into the database
C). Updating records in the database
D). Executing SQL queries
Which operation is used to insert new records into a database table using SQL?
A). CREATE
B). INSERT
C). UPDATE
D). DELETE
Which PHP function is used to execute an SQL query in PDO extension?
A). pdo_query()
B). pdo_execute()
C). pdo_fetch()
D). pdo_insert()
Which statement is used to update existing records in a database table using SQL?
A). INSERT
B). SELECT
C). UPDATE
D). MODIFY
Which PHP function is used to execute an SQL query in MySQLi extension?
A). mysqli_execute()
B). mysqli_query()
C). mysqli_fetch()
D). mysqli_prepare()
Which SQL operation is used to update the structure of an existing database table?
A). ALTER
B). UPDATE
C). MODIFY
D). CHANGE
What is the primary purpose of the mysqli_affected_rows() function in PHP?
A). Getting the number of rows affected by an SQL query
B). Fetching data from the database
C). Closing the database connection
D). Establishing a database connection
What is the primary purpose of the mysqli_close() function in PHP?
A). Establishing a database connection
B). Inserting records into the database
C). Updating records in the database
D). Closing the database connection
What is the purpose of the PDO::commit() method in PHP PDO extension?
A). Fetching data from the database
B). Inserting records into the database
C). Closing the database connection
D). Committing a transaction
Which PHP function is used to execute an SQL query in MySQLi extension?
A). mysqli_query()
B). mysqli_fetch()
C). mysqli_insert()
D). mysqli_update()