PHP DATABASES HANDLING QUIZ

Which of the methods are used to manage result sets using both associative and indexed arrays?

fetch_array() and fetch_row()

fetch_array() and fetch_column()

get_array() and get_column()

get_array() and get_row()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

$_GET[‘url’].

$_GET[‘admin’].

$_SET[‘url’].

$_SET[‘admin’].

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

GET index.php

POST index.php

GET admin.php

POST admin.php

TRUE ANSWER : ?
YOUR ANSWER : ?

Use the .............. to delete the data inside the table, and not the table itself?

TRUNCATE TABLE

DELETE TABLE

DROP TABLE

REMOVE TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

Which method rolls back the present transaction?

undo()

commit()

rollback()

back()

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

extension=mysql.dll

extension=mysqli.dl

extension=php_mysqli.dll

TRUE ANSWER : ?
YOUR ANSWER : ?

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

PHP 5.1

PHP 5.3

PHP 5.2

PHP 5.0

TRUE ANSWER : ?
YOUR ANSWER : ?

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

send_query()

query()

sendquery()

query_send()

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following methods can be used to diagnose and display information about a MySQL connection error?

connect_error()

mysqli_connect_error()

mysqli_connect_errno()

connect_errno()

TRUE ANSWER : ?
YOUR ANSWER : ?

↑