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::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 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
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 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
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 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 PHP extension provides an improved interface for interacting with MySQL databases?
A). MySQL
B). PDO
C). SQLI
D). MySQLi