Q
Which PHP extension provides better support for transaction management and error handling: MySQLi or PDO?

Answer & Solution

Answer: Option B
Solution:
PDO (PHP Data Objects) extension provides better support for transaction management and error handling compared to MySQLi. It offers a consistent interface for handling transactions and provides features such as automatic error handling and exception throwing.
Related Questions on Average

What is the purpose of the PDO::setAttribute() method in PDO extension?

A). Setting attributes for the PDO connection

B). Executing SQL queries

C). Fetching data from the database

D). Closing the database connection

Which of the following is NOT a valid database driver supported by PDO extension?

A). MySQL

B). PostgreSQL

C). MongoDB

D). SQLite

What is the purpose of the PDO::query() method in PDO extension?

A). Establishing a connection to a database

B). Executing an SQL statement

C). Fetching data from the database

D). Closing the database connection

Which PHP function is used to establish a connection to a MySQL database server using MySQLi extension?

A). mysqli_connect()

B). mysqli_query()

C). mysqli_fetch_assoc()

D). mysqli_close()

Which of the following is NOT a step in connecting to a MySQL database using PDO extension?

A). Create a PDO object

B). Set database credentials

C). Execute an SQL query

D). Handle connection errors

What is the primary advantage of using PDO over MySQLi for database access in PHP?

A). Portability across different databases

B). Better performance

C). Easier syntax

D). More features

Which PHP extension provides an improved interface for interacting with MySQL databases?

A). MySQL

B). PDO

C). SQLI

D). MySQLi

Which of the following statements is true regarding parameterized queries in MySQLi and PDO?

A). They prevent SQL injection attacks

B). They improve database performance

C). They can only be used with SELECT queries

D). They require additional server resources

Which PHP extension is specific to MySQL databases and offers both procedural and object-oriented approaches for database operations?

A). PDO

B). MySQL

C). SQLI

D). MySQLi

Which of the following functions is used to prepare an SQL statement for execution with parameters in MySQLi extension?

A). mysqli_query()

B). mysqli_prepare()

C). mysqli_fetch_array()

D). mysqli_close()