PHP DATABASES HANDLING QUIZ

Which of the following is not an SQL aggregate function?

SUM

MAX

MIN

CURRENT_DATE()

AVG

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?

affected_rows()

num_rows()

new_rows()

changed_rows()

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following methods is used to execute the statement after the parameters have been bound?

bind_result()

bound_param()

bound_result()

bind_param()

TRUE ANSWER : ?
YOUR ANSWER : ?

To identify entries marked for deletion, you check whether $_GET[‘page’] == ‘delete’ inside __________

.htaccess

admin.php

index.ini

index.php

TRUE ANSWER : ?
YOUR ANSWER : ?

Which method rolls back the present transaction?

commit()

back()

undo()

rollback()

TRUE ANSWER : ?
YOUR ANSWER : ?

What will happen at the end of the following sequence of SQL commands?<br/>BEGIN TRANSACTION<br/>DELETE FROM MYTABLE WHERE ID=1<br/>DELETE FROM OTHERTABLE<br/>ROLLBACK TRANSACTION

The contents of OTHERTABLE will be deleted

The database will remain unchanged

The contents of OTHERTABLE will be deleted, as will be all the contents of MYTABLE whose ID is 1

The contents of both OTHERTABLE and MYTABLE will be deleted

TRUE ANSWER : ?
YOUR ANSWER : ?

Which method retrieves each row from the prepared statement result and assigns the fields to the bound results?

get_row()

fetch()

fetch_row()

row()

TRUE ANSWER : ?
YOUR ANSWER : ?

([w-]+) will match ___________

one word characters

one or more word characters and/or hypens

one or more word characters

one or more word characters and hypens

TRUE ANSWER : ?
YOUR ANSWER : ?

In which version of PHP was MySQL Native Driver(also known as mysqlnd) introduced?

PHP 5.1

PHP 5.3

PHP 5.0

PHP 5.2

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following methods is used to recuperating prepared statements resources?

final()

finish()

end()

close()

TRUE ANSWER : ?
YOUR ANSWER : ?

↑