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 OTHERTABLE will be deleted

The contents of both OTHERTABLE and MYTABLE will be deleted

The contents of OTHERTABLE will be deleted, as will be all the contents of MYTABLE whose ID is 1

The database will remain unchanged

The contents of OTHERTABLE will be deleted

The contents of both OTHERTABLE and MYTABLE will be deleted

The contents of OTHERTABLE will be deleted, as will be all the contents of MYTABLE whose ID is 1

The database will remain unchanged

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
The ............. statement is used to delete a table.

DEL TABLE

REMOVE TABLE

DELETE TABLE

DROP TABLE

DEL TABLE

REMOVE TABLE

DELETE TABLE

DROP TABLE

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
Use the .............. to delete the data inside the table, and not the table itself?

DELETE TABLE

DROP TABLE

REMOVE TABLE

TRUNCATE TABLE

DELETE TABLE

DROP TABLE

REMOVE TABLE

TRUNCATE TABLE

ANSWER DOWNLOAD EXAMIANS APP

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

MySQL 4.0

MySQL 4.2

MySQL 4.3

MySQL 4.1

MySQL 4.0

MySQL 4.2

MySQL 4.3

MySQL 4.1

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
Which one of the following databases has PHP supported almost since the beginning?

SQL+

Oracle Database

SQL

MySQL

SQL+

Oracle Database

SQL

MySQL

ANSWER DOWNLOAD EXAMIANS APP

PHP Databases Handling
Can joins be nested?

False

True

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 The ............. statement is used to delete a table.

PHP Databases Handling Use the .............. to delete the data inside the table, and not the table itself?

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

PHP Databases Handling Which one of the following databases has PHP supported almost since the beginning?

PHP Databases Handling Can joins be nested?

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
The ............. statement is used to delete a table.

PHP Databases Handling
Use the .............. to delete the data inside the table, and not the table itself?

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

PHP Databases Handling
Which one of the following databases has PHP supported almost since the beginning?

PHP Databases Handling
Can joins be nested?