A. DROP TABLE
B. DELETE TABLE
C. DEL TABLE
D. REMOVE 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?
With SQL, how do you select all the columns from a table named "Persons"?
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?