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
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 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
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
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 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::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 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