PHP DATABASES HANDLING QUIZ

Which version of MySQL introduced the prepared statements?

MySQL 4.3

MySQL 4.2

MySQL 4.0

MySQL 4.1

TRUE ANSWER : ?
YOUR ANSWER : ?

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

bind_param()

bound_param()

bound_result()

bind_result()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

.adminaccess

.urlaccess

.htmlaccess

.htaccess

TRUE ANSWER : ?
YOUR ANSWER : ?

([w-]+) will match ___________

one or more word characters

one or more word characters and hypens

one or more word characters and/or hypens

one word characters

TRUE ANSWER : ?
YOUR ANSWER : ?

You need to check whether ______ is set, to determine whether you’re editing an entry or creating a new one.

$_SET[‘admin’].

$_GET[‘admin’].

$_SET[‘url’].

$_GET[‘url’].

TRUE ANSWER : ?
YOUR ANSWER : ?

Which method returns the error code generated from the execution of the last MySQL function?

errorno()

errno()

errornumber()

errnumber()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

If there is no error, then what will the error() method return?

0

Empty String

FALSE

TRUE

TRUE ANSWER : ?
YOUR ANSWER : ?

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

index.php

admin.php

index.ini

.htaccess

TRUE ANSWER : ?
YOUR ANSWER : ?

Which method rolls back the present transaction?

undo()

rollback()

commit()

back()

TRUE ANSWER : ?
YOUR ANSWER : ?

↑