PHP Databases Handling 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_error() mysqli_connect_errno() connect_error() connect_errno() mysqli_connect_error() mysqli_connect_errno() ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling What will happen at the end of the following sequence of SQL commands?BEGIN TRANSACTIONDELETE FROM MYTABLE WHERE ID=1DELETE FROM OTHERTABLEROLLBACK 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 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 The contents of both OTHERTABLE and MYTABLE will be deleted The contents of OTHERTABLE will be deleted ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling Which of the following methods is used to execute the statement after the parameters have been bound? bind_result() bound_param() bind_param() bound_result() bind_result() bound_param() bind_param() bound_result() ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling When you are building administrative links you’ll need to accept two arguments, which of the following are they? 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 URL of previous entry and previous page The current page 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 URL of previous entry and previous page The current page and previous page ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling ([w-]+) will match ___________ one or more word characters one word characters one or more word characters and hypens one or more word characters and/or hypens one or more word characters one word characters one or more word characters and hypens one or more word characters and/or hypens ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling You need to check whether ______ is set, to determine whether you’re editing an entry or creating a new one. $_SET[‘url’]. $_GET[‘admin’]. $_SET[‘admin’]. $_GET[‘url’]. $_SET[‘url’]. $_GET[‘admin’]. $_SET[‘admin’]. $_GET[‘url’]. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS