PHP PHP Database Integration & MySQL

Question 1

What does PDO stand for in PHP?

Accepted Answer

PHP Data Objects

Answer

PHP Data Output

Answer

Persistent Database Operations

Answer

PHP Driver Object

Question 2

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

Accepted Answer

They prevent SQL injection attacks

Answer

They execute faster than all other methods

Answer

They automatically index database tables

Answer

They require no database connection

Question 3

Which PDO method prepares an SQL statement for execution?

Accepted Answer

prepare()

Answer

execute()

Answer

query()

Answer

compile()

Question 4

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

Accepted Answer

fetchAll()

Answer

getAll()

Answer

selectAll()

Answer

resultAll()

Question 5

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

Accepted Answer

PDO::FETCH_ASSOC

Answer

PDO::FETCH_NUM

Answer

PDO::FETCH_OBJ

Answer

PDO::FETCH_BOTH

Question 6

What does the PDO lastInsertId() method return after an INSERT statement?

Accepted Answer

The ID of the last inserted row

Answer

The number of rows inserted

Answer

The SQL query that was run

Answer

The name of the table