PHP DATABASES HANDLING QUIZ

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

mysqlconnect() function

sql_connect() function

mysql-connect() function

mysql_connect() function

TRUE ANSWER : ?
YOUR ANSWER : ?

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

query()

send_query()

sendquery()

query_send()

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not an SQL aggregate function?

MAX

SUM

AVG

CURRENT_DATE()

MIN

TRUE ANSWER : ?
YOUR ANSWER : ?

Which version of MySQL introduced the prepared statements?

MySQL 4.2

MySQL 4.0

MySQL 4.1

MySQL 4.3

TRUE ANSWER : ?
YOUR ANSWER : ?

The (|/) tells the server to match ___________

nothing

either nothing or a forward slash

forward slash

backward slash

TRUE ANSWER : ?
YOUR ANSWER : ?

What will happen at the end of the following sequence of SQL commands?<br/>BEGIN TRANSACTION<br/>DELETE FROM MYTABLE WHERE ID=1<br/>DELETE FROM OTHERTABLE<br/>ROLLBACK TRANSACTION

The contents of both OTHERTABLE and MYTABLE will be deleted

The contents of OTHERTABLE will be deleted

The contents of OTHERTABLE will be deleted, as will be all the contents of MYTABLE whose ID is 1

The database will remain unchanged

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_errno()

mysqli_connect_error()

connect_errno()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

None of these

PostgreSQL

IBM DB/2

Microsoft SQL Server

MySQL

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following statements should be used to include a file?

#include ‘filename’;

include ‘filename’;

#include ;

@include ‘filename’;

TRUE ANSWER : ?
YOUR ANSWER : ?

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

close()

end()

final()

finish()

TRUE ANSWER : ?
YOUR ANSWER : ?

↑