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 remove all records from a database table?
A). TRUNCATE
B). CLEAR
C). DELETE
D). REMOVE
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
Which operation is used to delete specific records from a database table using SQL?
A). DELETE
B). REMOVE
C). ERASE
D). CLEAR
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
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 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()
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
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()