PHP PHP Database Integration & MySQL

Question 1

What does PDO stand for in PHP?

Accepted Answer

PHP Data Objects

Answer

PDO stands for PHP Data Objects, a database abstraction layer providing a consistent interface for multiple database types.

Question 2

Why are prepared statements preferred over plain SQL queries in PHP?

Accepted Answer

They prevent SQL injection attacks

Answer

Prepared statements separate SQL logic from user data, ensuring malicious input cannot alter the query structure.

Question 3

Which PDO method prepares an SQL statement for execution?

Accepted Answer

prepare()

Answer

PDO::prepare() sends the SQL template to the database and returns a PDOStatement object ready for binding and execution.

Question 4

Which PDO method retrieves all rows of a result set as an array?

Accepted Answer

fetchAll()

Answer

fetchAll() fetches all remaining rows from the result set and returns them as a multidimensional array.

Question 5

Which PDO constant returns each row as an associative array keyed by column name?

Accepted Answer

PDO::FETCH_ASSOC

Answer

PDO::FETCH_ASSOC returns each row as an associative array where keys are the column names from the result.

PHP - PHP Programming Language Practice Test