PHP DATABASES HANDLING QUIZ

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

mysql-connect() function

mysql_connect() function

mysqlconnect() function

sql_connect() function

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

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

mysqly

mysql

MySQL

mysqli

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 previous page

The current page and previous page

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

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following methods is used to recuperating prepared statements resources?

final()

close()

end()

finish()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Microsoft SQL Server

IBM DB/2

MySQL

PostgreSQL

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

errornumber()

errno()

errnumber()

errorno()

TRUE ANSWER : ?
YOUR ANSWER : ?

The (|/) tells the server to match ___________

nothing

forward slash

backward slash

either nothing or a forward slash

TRUE ANSWER : ?
YOUR ANSWER : ?

When a user confirms that he wishes to delete an entry, that entry’s URL is passed to a function which removes the entry from the __________

index.php

admin.php

function.inc.php

database

TRUE ANSWER : ?
YOUR ANSWER : ?

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

mysqli_connect_error()

connect_errno()

mysqli_connect_errno()

connect_error()

TRUE ANSWER : ?
YOUR ANSWER : ?

↑