A. AVG
B. SUM
C. MIN
D. MAX
E. CURRENT_DATE
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?
Can joins be nested?
Where is metadata stored in MySQL?
________ is an open source DBMS product that runs on UNIX, Linux and Windows.
What MySQL property is used to create a surrogate key in MySQL?
What does SQL stand for?