Q.1
Which method rolls back the present transaction?
Q.2
Which one of the following methods is responsible for sending the query to the database?
Q.3
The ............. statement is used to delete a table.
Q.4
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
Q.5
Use the .............. to delete the data inside the table, and not the table itself?
Q.6
Can joins be nested?
Q.7
In PHP in order to access MySQL database you will use:
Q.8
Transactions are used to treat sets of SQL statements atomically.
Q.9
SQL is not case sensitive. SELECT is the same as select.
Q.10
Which of the following is not an SQL aggregate function?
Q.11
What does the DESC keyword do in the following query? 
SELECT *
FROM MY_TABLE
WHERE ID > 0
ORDER BY ID, NAME DESC"
Q.12
Which version of MySQL introduced the prepared statements?
Q.13
Which of the following methods is used to execute the statement after the parameters have been bound?
Q.14
When you are building administrative links you’ll need to accept two arguments, which of the following are they?
Q.15
Which one of the following methods is used to recuperating prepared statements resources?
Q.16
Which method retrieves each row from the prepared statement result and assigns the fields to the bound results?
Q.17
Which one of the following statements should be used to include a file?
Q.18
Once your application can generate administrative links, you need to load those links into _________
Q.19
The URLs in the administrative links won’t mean anything to admin.php unless you modify _________
Q.20
Which one of the following methods recuperates any memory consumed by a result set?
0 h : 0 m : 1 s