31. In PHP in order to access MySQL database you will use:
32. Transactions are used to treat sets of SQL statements atomically.
33. SQL is not case sensitive. SELECT is the same as select.
34. Which of the following is not an SQL aggregate function?
35. What does the DESC keyword do in the following query?
SELECT *
FROM MY_TABLE
WHERE ID > 0
ORDER BY ID, NAME DESC"
SELECT *
FROM MY_TABLE
WHERE ID > 0
ORDER BY ID, NAME DESC"
36. The ............. statement is used to delete a table.
37. 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
BEGIN TRANSACTION
DELETE FROM MYTABLE WHERE ID=1
DELETE FROM OTHERTABLE
ROLLBACK TRANSACTION