What is the purpose of the PDO::lastInsertId() method in PDO extension?
A). Retrieving the ID generated by the last INSERT statement
B). Executing an SQL query
C). Fetching data from the database
D). Closing the database connection
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
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 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
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
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 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 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 offers a consistent interface for accessing different database engines, including MySQL, PostgreSQL, and SQLite?
A). MySQL
B). PDO
C). SQLI
D). MySQLi