PHP DATABASES HANDLING QUIZ

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

MySQL

mysql

mysqli

mysqly

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following databases has PHP supported almost since the beginning?

Oracle Database

SQL

MySQL

SQL+

TRUE ANSWER : ?
YOUR ANSWER : ?

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

0

TRUE

FALSE

Empty String

TRUE ANSWER : ?
YOUR ANSWER : ?

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 method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?

changed_rows()

num_rows()

new_rows()

affected_rows()

TRUE ANSWER : ?
YOUR ANSWER : ?

Once your application can generate administrative links, you need to load those links into _________

index.php

index.ini

start.php

php.ini

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[‘admin’].

$_SET[‘url’].

$_SET[‘admin’].

$_GET[‘url’].

TRUE ANSWER : ?
YOUR ANSWER : ?

Which method rolls back the present transaction?

back()

undo()

commit()

rollback()

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

The contents of both OTHERTABLE and MYTABLE will be deleted

TRUE ANSWER : ?
YOUR ANSWER : ?

Which method retrieves each row from the prepared statement result and assigns the fields to the bound results?

fetch_row()

row()

get_row()

fetch()

TRUE ANSWER : ?
YOUR ANSWER : ?

↑