PHP DATABASES HANDLING QUIZ

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

bound_param()

bind_result()

bound_result()

bind_param()

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?

new_rows()

affected_rows()

changed_rows()

num_rows()

TRUE ANSWER : ?
YOUR ANSWER : ?

The ............. statement is used to delete a table.

DEL TABLE

DELETE TABLE

REMOVE TABLE

DROP TABLE

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 database will remain unchanged

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

TRUE ANSWER : ?
YOUR ANSWER : ?

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

row()

fetch_row()

get_row()

fetch()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

query_send()

query()

send_query()

sendquery()

TRUE ANSWER : ?
YOUR ANSWER : ?

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

SQL

MySQL

SQL+

Oracle Database

TRUE ANSWER : ?
YOUR ANSWER : ?

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

errnumber()

errno()

errornumber()

errorno()

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

connect_errno()

mysqli_connect_errno()

mysqli_connect_error()

TRUE ANSWER : ?
YOUR ANSWER : ?

Which version of MySQL introduced the prepared statements?

MySQL 4.3

MySQL 4.1

MySQL 4.0

MySQL 4.2

TRUE ANSWER : ?
YOUR ANSWER : ?

↑