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 contents of OTHERTABLE will be deleted The database will remain unchanged The contents of both OTHERTABLE and MYTABLE will be deleted 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_errno() connect_error() mysqli_connect_error() connect_errno() TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following methods is used to execute the statement after the parameters have been bound? bound_result() bound_param() bind_result() bind_param() 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 previous page URL of previous entry and previous page URL of previous entry and URL of the entry you are working with The current page and URL of the entry you are working with TRUE ANSWER : ? YOUR ANSWER : ?
Which one of the following statements can be used to select the database? mysqli->select_db(‘databasename’); $mysqli=select_db(‘databasename’); mysqli=select_db(‘databasename’); $mysqli->select_db(‘databasename’); TRUE ANSWER : ? YOUR ANSWER : ?
The updated MySQL extension released with PHP 5 is typically referred to as. mysqly mysqli mysql MySQL TRUE ANSWER : ? YOUR ANSWER : ?
Which method returns the error code generated from the execution of the last MySQL function? errorno() errnumber() errornumber() errno() TRUE ANSWER : ? YOUR ANSWER : ?
Which one of the following methods recuperates any memory consumed by a result set? destroy() alloc() remover() free() TRUE ANSWER : ? YOUR ANSWER : ?
Which one of the following methods is used to recuperating prepared statements resources? close() finish() end() final() 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? affected_rows() changed_rows() num_rows() new_rows() TRUE ANSWER : ? YOUR ANSWER : ?