Which of the following is not an SQL aggregate function? SUM MAX MIN CURRENT_DATE() AVG 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() num_rows() new_rows() changed_rows() TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following methods is used to execute the statement after the parameters have been bound? bind_result() bound_param() bound_result() bind_param() TRUE ANSWER : ? YOUR ANSWER : ?
To identify entries marked for deletion, you check whether $_GET[‘page’] == ‘delete’ inside __________ .htaccess admin.php index.ini index.php TRUE ANSWER : ? YOUR ANSWER : ?
Which method rolls back the present transaction? commit() back() undo() rollback() 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 OTHERTABLE will be deleted The database will remain unchanged The contents of OTHERTABLE will be deleted, as will be all the contents of MYTABLE whose ID is 1 The contents of both OTHERTABLE and MYTABLE will be deleted TRUE ANSWER : ? YOUR ANSWER : ?
Which method retrieves each row from the prepared statement result and assigns the fields to the bound results? get_row() fetch() fetch_row() row() TRUE ANSWER : ? YOUR ANSWER : ?
([w-]+) will match ___________ one word characters one or more word characters and/or hypens one or more word characters one or more word characters and hypens TRUE ANSWER : ? YOUR ANSWER : ?
In which version of PHP was MySQL Native Driver(also known as mysqlnd) introduced? PHP 5.1 PHP 5.3 PHP 5.0 PHP 5.2 TRUE ANSWER : ? YOUR ANSWER : ?
Which one of the following methods is used to recuperating prepared statements resources? final() finish() end() close() TRUE ANSWER : ? YOUR ANSWER : ?