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 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 PDO::beginTransaction() method in PHP PDO extension?
A). Fetching data from the database
B). Inserting records into the database
C). Initiating a transaction
D). Closing the database connection
Which SQL operation is used to remove all records from a database table?
A). TRUNCATE
B). CLEAR
C). DELETE
D). REMOVE
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 statement is used to create a new database table in SQL?
A). CREATE
B). INSERT
C). UPDATE
D). DELETE
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