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
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 PHP function is used to establish a connection to a MySQL database server using MySQLi extension?
A). mysqli_connect()
B). mysqli_query()
C). mysqli_fetch_assoc()
D). mysqli_close()
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 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 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()
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 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
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