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
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 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 statements is true regarding database connections in PHP applications?
A). Database connections should be properly closed after use
B). Database connections are automatically closed by PHP
C). Keeping database connections open improves performance
D). Multiple simultaneous database connections are recommended
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()
Which of the following is NOT a valid database driver supported by PDO extension?
A). MySQL
B). PostgreSQL
C). MongoDB
D). SQLite
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 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