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_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 delete specific records from a database table using SQL?
A). DELETE
B). REMOVE
C). ERASE
D). CLEAR
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 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 PHP function is used to execute an SQL query in MySQLi extension?
A). mysqli_query()
B). mysqli_fetch()
C). mysqli_insert()
D). mysqli_update()
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
What is the primary function of the mysqli_num_rows() function in PHP?
A). Fetching data from the database
B). Inserting records into the database
C). Updating records in the database
D). Getting the number of rows in a result set
Which SQL operation is used to add new records to a database table?
A). CREATE
B). INSERT
C). ADD
D). APPEND
What is the purpose of the PDO::exec() method in PHP PDO extension?
A). Executing SQL queries
B). Fetching data from the database
C). Inserting records into the database
D). Closing the database connection