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 an improved interface for interacting with MySQL databases?
A). MySQL
B). PDO
C). SQLI
D). MySQLi
Which PHP extension offers a consistent interface for accessing different database engines, including MySQL, PostgreSQL, and SQLite?
A). MySQL
B). PDO
C). SQLI
D). MySQLi
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 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
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 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 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
Which of the following statements is true regarding database connections in PHP applications?
A). Database connections should be properly closed after use
B). Database connections are automatically closed by PHP
C). Keeping database connections open improves performance
D). Multiple simultaneous database connections are recommended
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