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 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 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()
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 of the following is NOT a valid database driver supported by PDO extension?
A). MySQL
B). PostgreSQL
C). MongoDB
D). SQLite
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 primary function of the mysqli_connect() function in PHP?
A). Establishing a connection to a MySQL database
B). Executing SQL queries
C). Fetching data from the database
D). Closing the database connection
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
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