PHP Test 1 Review Exam actual questions and CORRECT answers

PHP Test 1 Review Exam actual questions
and CORRECT answers
PDO is short for:



a) PHP Database Oriented Programming

b) PHP Database Object

c) PHP Data Operations

d) PHP Data Object - CORRECT ANSWER d) PHP Data Object



The acronym PDO stands for:



a) PHP Decadal Oscillation

b) PHP Data Objects

c) PHP Designation of Origin

d) PHP Development and Operation - CORRECT ANSWER b) PHP Data Objects



To get the number of row returned from a query operation use the numRows() method -
CORRECT ANSWER False



PDO Supports every major database system - CORRECT ANSWER True



$sql = "SELECT * FROM movies";

$result = $dbc->query($sql)
if ($result==false) {



}

, In the above statement, if $result is FALSE, then there are no records in the 'movies' table. -
CORRECT ANSWER False



PDO Offers:



a) Fast access to databases
b) Multi-database support

c) Built in security

d) All of the above - CORRECT ANSWER d) All of the above



PDO offers multi-database support. - CORRECT ANSWER True



PDO has been available since PHP 5.0 - CORRECT ANSWER True



To retrieve the number inserted into the auto incremented field, use the lastId() method -
CORRECT ANSWER False



PDO is designed to replace MySQLi - CORRECT ANSWER True



Having a query with placeholders, you have to prepare it, using the PDO _________ method.
This function will return the same PDOStatement object, but without any data attached to it.



a) pdoprepare()

b) prep()

c) prepare_statement()

d) prepare() - CORRECT ANSWER d) prepare()



After every PDO operation, one of two results are returned. - CORRECT
ANSWER True