PHP Databases Handling Use the .............. to delete the data inside the table, and not the table itself? TRUNCATE TABLE REMOVE TABLE DROP TABLE DELETE TABLE TRUNCATE TABLE REMOVE TABLE DROP TABLE DELETE TABLE ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling Which one of the following methods can be used to diagnose and display information about a MySQL connection error? mysqli_connect_errno() connect_errno() mysqli_connect_error() connect_error() mysqli_connect_errno() connect_errno() mysqli_connect_error() connect_error() ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling To identify entries marked for deletion, you check whether $_GET[‘page’] == ‘delete’ inside __________ admin.php index.php index.ini .htaccess admin.php index.php index.ini .htaccess ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling When a user confirms that he wishes to delete an entry, that entry’s URL is passed to a function which removes the entry from the __________ admin.php function.inc.php database index.php admin.php function.inc.php database index.php ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling Transactions are used to treat sets of SQL statements atomically. False True False True ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling 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() affected_rows() changed_rows() num_rows() new_rows() ANSWER DOWNLOAD EXAMIANS APP