What will happen at the end of the following sequence of SQL commands?BEGIN TRANSACTIONDELETE FROM MYTABLE WHERE ID=1DELETE FROM OTHERTABLEROLLBACK TRANSACTION Options: A . &nbspThe database will remain unchanged B . &nbspThe contents of OTHERTABLE will be deleted, as will be all the contents of MYTABLE whose ID is 1 C . &nbspThe contents of both OTHERTABLE and MYTABLE will be deleted D . &nbspThe contents of OTHERTABLE will be deleted

What will happen at the end of the following sequence of SQL commands?BEGIN TRAN

Discussion Forum : Php Databases Handling

Question - What will happen at the end of the following sequence of SQL commands?BEGIN TRANSACTIONDELETE FROM MYTABLE WHERE ID=1DELETE FROM OTHERTABLEROLLBACK TRANSACTION

Options:

A . The database will remain unchanged

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

C . The contents of both OTHERTABLE and MYTABLE will be deleted

D . The contents of OTHERTABLE will be deleted

Answer: Option A

Submit Your Solution Below and Earn Points !

Discussion Forum : Php Databases Handling

Submit Your Solution hear: