PHP DATABASES HANDLING QUIZ

Which method rolls back the present transaction?

back()

rollback()

undo()

commit()

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following methods is used to execute the statement after the parameters have been bound?

bound_param()

bound_result()

bind_param()

bind_result()

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’].

$_SET[‘admin’].

$_SET[‘url’].

$_GET[‘admin’].

TRUE ANSWER : ?
YOUR ANSWER : ?

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

query_send()

sendquery()

send_query()

query()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

PostgreSQL

Microsoft SQL Server

None of these

MySQL

IBM DB/2

TRUE ANSWER : ?
YOUR ANSWER : ?

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

TRUE

0

FALSE

Empty String

TRUE ANSWER : ?
YOUR ANSWER : ?

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

fetch_row()

get_row()

fetch()

row()

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, as will be all the contents of MYTABLE whose ID is 1

The database will remain unchanged

The contents of OTHERTABLE will be deleted

The contents of both OTHERTABLE and MYTABLE will be deleted

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

extension=mysql.dll

extension=php_mysqli.dl

extension=mysqli.dl

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑