PHP DATABASES HANDLING QUIZ

Which one of the following methods recuperates any memory consumed by a result set?

alloc()

destroy()

remover()

free()

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following lines need to be uncommented or added in the php.ini file so as to enable mysqli extension?

extension=php_mysqli.dll

extension=mysqli.dl

extension=php_mysqli.dl

extension=mysql.dll

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not an SQL aggregate function?

AVG

SUM

CURRENT_DATE()

MAX

MIN

TRUE ANSWER : ?
YOUR ANSWER : ?

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

errno()

errorno()

errornumber()

errnumber()

TRUE ANSWER : ?
YOUR ANSWER : ?

Which version of MySQL introduced the prepared statements?

MySQL 4.3

MySQL 4.1

MySQL 4.2

MySQL 4.0

TRUE ANSWER : ?
YOUR ANSWER : ?

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

bound_result()

bind_param()

bind_result()

bound_param()

TRUE ANSWER : ?
YOUR ANSWER : ?

The ............. statement is used to delete a table.

REMOVE TABLE

DEL TABLE

DELETE TABLE

DROP TABLE

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 retrieves each row from the prepared statement result and assigns the fields to the bound results?

fetch()

fetch_row()

get_row()

row()

TRUE ANSWER : ?
YOUR ANSWER : ?

In PHP in order to access MySQL database you will use:

mysqlconnect() function

mysql-connect() function

mysql_connect() function

sql_connect() function

TRUE ANSWER : ?
YOUR ANSWER : ?

↑