PHP DATABASES HANDLING QUIZ

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

bound_result()

bind_result()

bound_param()

bind_param()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

PHP 5.2

PHP 5.1

PHP 5.3

PHP 5.0

TRUE ANSWER : ?
YOUR ANSWER : ?

Which method rolls back the present transaction?

back()

rollback()

commit()

undo()

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not an SQL aggregate function?

SUM

CURRENT_DATE()

MIN

AVG

MAX

TRUE ANSWER : ?
YOUR ANSWER : ?

Can joins be nested?

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

([w-]+) will match ___________

one word characters

one or more word characters

one or more word characters and/or hypens

one or more word characters and hypens

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 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 OTHERTABLE will be deleted

The contents of both OTHERTABLE and MYTABLE will be deleted

TRUE ANSWER : ?
YOUR ANSWER : ?

The URLs in the administrative links won’t mean anything to admin.php unless you modify _________

.urlaccess

.htmlaccess

.adminaccess

.htaccess

TRUE ANSWER : ?
YOUR ANSWER : ?

Your confirmation form submits your choice, via the _ method, to __

GET admin.php

POST index.php

GET index.php

POST admin.php

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL is not case sensitive. SELECT is the same as select.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?