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

PHP Databases Handling
What will happen at the end of the following sequence of SQL commands?
BEGIN TRANSACTION
DELETE FROM MYTABLE WHERE ID=1
DELETE FROM OTHERTABLE
ROLLBACK TRANSACTION

The contents of both OTHERTABLE and MYTABLE will be deleted

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

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

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
If there is no error, then what will the error() method return?

FALSE

0

TRUE

Empty String

FALSE

0

TRUE

Empty String

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
Which one of the following lines need to be uncommented or added in the php.ini file so as to enable mysqli extension?

extension=mysql.dll

extension=php_mysqli.dl

extension=mysqli.dl

extension=php_mysqli.dll

extension=mysql.dll

extension=php_mysqli.dl

extension=mysqli.dl

extension=php_mysqli.dll

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.

$_GET[‘admin’].

$_SET[‘url’].

$_SET[‘admin’].

$_GET[‘url’].

$_GET[‘admin’].

$_SET[‘url’].

$_SET[‘admin’].

$_GET[‘url’].

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
The URLs in the administrative links won’t mean anything to admin.php unless you modify _________

.urlaccess

.adminaccess

.htaccess

.htmlaccess

.urlaccess

.adminaccess

.htaccess

.htmlaccess

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
Which version of MySQL introduced the prepared statements?

MySQL 4.1

MySQL 4.2

MySQL 4.3

MySQL 4.0

MySQL 4.1

MySQL 4.2

MySQL 4.3

MySQL 4.0

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling

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

PHP Databases Handling If there is no error, then what will the error() method return?

PHP Databases Handling Which one of the following lines need to be uncommented or added in the php.ini file so as to enable mysqli extension?

PHP Databases Handling You need to check whether ______ is set, to determine whether you’re editing an entry or creating a new one.

PHP Databases Handling The URLs in the administrative links won’t mean anything to admin.php unless you modify _________

PHP Databases Handling Which version of MySQL introduced the prepared statements?

PHP Databases Handling
What will happen at the end of the following sequence of SQL commands?
BEGIN TRANSACTION
DELETE FROM MYTABLE WHERE ID=1
DELETE FROM OTHERTABLE
ROLLBACK TRANSACTION

PHP Databases Handling
If there is no error, then what will the error() method return?

PHP Databases Handling
Which one of the following lines need to be uncommented or added in the php.ini file so as to enable mysqli extension?

PHP Databases Handling
You need to check whether ______ is set, to determine whether you’re editing an entry or creating a new one.

PHP Databases Handling
The URLs in the administrative links won’t mean anything to admin.php unless you modify _________

PHP Databases Handling
Which version of MySQL introduced the prepared statements?