PHP Databases Handling Use the .............. to delete the data inside the table, and not the table itself? DELETE TABLE TRUNCATE TABLE DROP TABLE REMOVE TABLE DELETE TABLE TRUNCATE TABLE DROP TABLE REMOVE TABLE ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling Which method rolls back the present transaction? undo() rollback() commit() back() undo() rollback() commit() back() 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[‘admin’]. $_GET[‘admin’]. $_SET[‘url’]. $_GET[‘url’]. $_SET[‘admin’]. $_GET[‘admin’]. $_SET[‘url’]. $_GET[‘url’]. ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling Which method retrieves each row from the prepared statement result and assigns the fields to the bound results? fetch() row() get_row() fetch_row() fetch() row() get_row() fetch_row() ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling Which of the following is not an SQL aggregate function? SUM CURRENT_DATE() MAX MIN AVG SUM CURRENT_DATE() MAX MIN AVG ANSWER DOWNLOAD EXAMIANS APP
PHP Databases Handling SQL is not case sensitive. SELECT is the same as select. True False True False ANSWER DOWNLOAD EXAMIANS APP