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 of the following methods is used to execute a prepared statement with parameters in MySQLi extension?
A). mysqli_prepare()
B). mysqli_query()
C). mysqli_bind_param()
D). mysqli_execute()
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()
Which PHP extension provides better support for transaction management and error handling: MySQLi or PDO?
A). MySQLi
B). PDO
C). Both provide similar support
D). Neither supports transaction management
Which PHP extension provides an improved interface for interacting with MySQL databases?
A). MySQL
B). PDO
C). SQLI
D). MySQLi
What is the purpose of the PDO::beginTransaction() method in PDO extension?
A). Initiating a database transaction
B). Executing an SQL query
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 primary purpose of database connection pooling in PHP applications?
A). Improving scalability and performance
B). Enhancing database security
C). Simplifying database configuration
D). Reducing server resource usage
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
What is the primary function of the mysqli_connect() function in PHP?
A). Establishing a connection to a MySQL database
B). Executing SQL queries
C). Fetching data from the database
D). Closing the database connection