PHP DATABASES HANDLING QUIZ

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

0

Empty String

TRUE

FALSE

TRUE ANSWER : ?
YOUR ANSWER : ?

The updated MySQL extension released with PHP 5 is typically referred to as.

mysqli

MySQL

mysql

mysqly

TRUE ANSWER : ?
YOUR ANSWER : ?

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

destroy()

alloc()

free()

remover()

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not an SQL aggregate function?

AVG

MAX

CURRENT_DATE()

SUM

MIN

TRUE ANSWER : ?
YOUR ANSWER : ?

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

errno()

errnumber()

errorno()

errornumber()

TRUE ANSWER : ?
YOUR ANSWER : ?

Can joins be nested?

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following statements can be used to select the database?

mysqli=select_db(‘databasename’);

$mysqli=select_db(‘databasename’);

$mysqli->select_db(‘databasename’);

mysqli->select_db(‘databasename’);

TRUE ANSWER : ?
YOUR ANSWER : ?

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

index.php

index.ini

.htaccess

admin.php

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following methods is responsible for sending the query to the database?

query_send()

sendquery()

send_query()

query()

TRUE ANSWER : ?
YOUR ANSWER : ?

Transactions are used to treat sets of SQL statements atomically.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑