MYSQL - FIN

What is the purpose of the ORDER BY clause in MySQL?

• To insert new records

• To sort the result set in ascending or descending order

• To delete records

• To update existing records

Which keyword is used with ORDER BY to sort in descending order?

• ASC

• DESC

• SORT

• DOWN

What will happen if you use ORDER BY without specifying ASC or DESC?

• It will throw an error

• It will sort in ascending order by default

• It will sort in descending order by default

• It will sort randomly

Which of the following is a valid ORDER BY clause?

• ORDER BY column1, column2 DESC

• ORDER BY 1, 2

• Both a and b

• Neither a nor b

The INSERT INTO statement is used to:

• Sort data

• Add new records to a table

• Delete records

• Update records

Which syntax is correct for inserting a single row?

• INSERT INTO table_name (column1, column2) VALUES (value1, value2)

• INSERT table_name VALUES (value1, value2)

• Both a and b

• Neither a nor b

What happens if you omit column names in an INSERT INTO statement?
NOTE: omitting column names means you don’t specify the columns into which you’re inserting data.

• It inserts values into all columns in the order they are defined

• It throws an error

• It inserts null values

• It sorts the data

Which clause can be combined with INSERT INTO to sort the inserted data?

• ORDER BY

• WHERE

• GROUP BY

• None of the above

In ORDER BY, what does sorting by a column number (e.g., ORDER BY 2) refer to?

• The second row

• The second column in the SELECT list

• The second table

• The second database

Which of the following is a valid INSERT INTO statement?

• INSERT INTO users (id, name) VALUES (1, 'John')

• INSERT INTO users VALUES (1, 'John')

• Both a and b

• Neither a nor b