Correct Answer: INSERT INTO Persons (LastName) VALUES ('Olsen')
Explanation:
Note: This Question is unanswered, help us to find answer for this one
MySQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More MySQL MCQ Questions
With SQL, how can you return all the records from a table named 'Persons' sorted descending by 'FirstName'?
How would you write a query to select all teams that won either 2, 4, 6 or 8 games?
A SELECT statement without a WHERE clause returns _____.
Can I create another MySQL instance in the same machine?
Maximum number of constituents for a SET datatype?
If you want to use MyISAM instead of InnoDB, which option do you need to specify in the CREATE TABLE statement?
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?
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?
Which type of backup includes all the changes made to the data since the last full backup was performed?
When working with MySQL cursor, what must you also declare?