The ............. statement is used to delete a table. DEL TABLE DROP TABLE DELETE TABLE REMOVE TABLE TRUE ANSWER : ? YOUR ANSWER : ?
You need to check whether ______ is set, to determine whether you’re editing an entry or creating a new one. $_SET[‘url’]. $_SET[‘admin’]. $_GET[‘admin’]. $_GET[‘url’]. TRUE ANSWER : ? YOUR ANSWER : ?
Transactions are used to treat sets of SQL statements atomically. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which one of the following methods can be used to diagnose and display information about a MySQL connection error? connect_errno() connect_error() mysqli_connect_error() mysqli_connect_errno() TRUE ANSWER : ? YOUR ANSWER : ?
Which method returns the error code generated from the execution of the last MySQL function? errnumber() errornumber() errno() errorno() 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 : ?
Which one of the following databases has PHP supported almost since the beginning? MySQL SQL Oracle Database SQL+ 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 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 The database will remain unchanged TRUE ANSWER : ? YOUR ANSWER : ?
Which one of the following statements should be used to include a file? #include ‘filename’; include ‘filename’; @include ‘filename’; #include ; TRUE ANSWER : ? YOUR ANSWER : ?
In which version of PHP was MySQL Native Driver(also known as mysqlnd) introduced? PHP 5.0 PHP 5.3 PHP 5.2 PHP 5.1 TRUE ANSWER : ? YOUR ANSWER : ?