Which statement about the TRUNCATE TABLE statement is true?

In data migration, there is often a need to delete duplicate rows as part of data cleanup. Which statement works best?

When working with MySQL cursor, what must you also declare?

Which type of backup includes all the changes made to the data since the last full backup was performed?

You need to restore a MySQL database from a backup file. Which command-line tool do you use for the actual data import, after re-creating the database?

You are importing data as JSON into a new table. You run CREATE TABLE json_data ( city JSON ); and insert rows into this table. What is the correct syntax to see the list of cities?

With SQL, how can you return the number of records in the 'Persons' table?

Maximum number of constituents for a SET datatype?

Can I create another MySQL instance in the same machine?

A SELECT statement without a WHERE clause returns _____.

How would you write a query to select all teams that won either 2, 4, 6 or 8 games?