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
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 is NOT a valid database driver supported by PDO extension?
A). MySQL
B). PostgreSQL
C). MongoDB
D). SQLite
What does PDO stand for in the context of PHP database access?
A). PHP Database Objects
B). PHP Data Operations
C). PHP Data Objects
D). PHP Database Extensions
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 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 primary advantage of using prepared statements in MySQLi and PDO?
A). Improved security and protection against SQL injection
B). Faster execution of SQL queries
C). Simpler syntax for SQL statements
D). Compatibility with older PHP versions
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::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 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