PHP DATABASES HANDLING QUIZ

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

mysql

mysqli

mysqly

MySQL

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 : ?

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

new_rows()

affected_rows()

changed_rows()

num_rows()

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following DBMSs do not have a native PHP extension?

IBM DB/2

Microsoft SQL Server

None of these

PostgreSQL

MySQL

TRUE ANSWER : ?
YOUR ANSWER : ?

When you are building administrative links you’ll need to accept two arguments, which of the following are they?

The current page and URL of the entry you are working with

URL of previous entry and URL of the entry you are working with

The current page and previous page

URL of previous entry and previous page

TRUE ANSWER : ?
YOUR ANSWER : ?

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

PHP 5.3

PHP 5.1

PHP 5.0

PHP 5.2

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not an SQL aggregate function?

SUM

MIN

AVG

CURRENT_DATE()

MAX

TRUE ANSWER : ?
YOUR ANSWER : ?

Can joins be nested?

False

True

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=mysqli.dl

extension=mysql.dll

extension=php_mysqli.dl

extension=php_mysqli.dll

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 : ?

↑