In a SELECT with a GROUP BY clause, a WHERE clause, and a HAVING clause, the WHERE conditions are applied before the HAVING conditions.

Which of the following DBMSs do not have a native PHP extension?

In PHP in order to access MySQL database you will use:

Transactions are used to treat sets of SQL statements atomically.

SQL is not case sensitive. SELECT is the same as select.

Which of the following is not an SQL aggregate function?

What does the DESC keyword do in the following query?

SELECT *

FROM MY_TABLE

WHERE ID > 0

ORDER BY ID, NAME DESC

The ............. statement is used to delete a table.

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

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