MC_AzureSqlDatabaseFundamentals_Session3_1

Which SQL statement is used to retrieve data from a database?

• INSERT

• SELECT

• DELETE

• UPDATE

What is the purpose of the SELECT statement in SQL?

• Updating existing records in a table

• Inserting new records into a table

• Retrieving data from one or more tables

• Deleting records from a table

What does the semicolon ";" indicate in a SELECT statement?

• It's the end of each SELECT clause

• It's the end of the SELECT statement

• You use a semicolon in a SELECT statement?? Why??

Which of these statements is true?

• The SELECT statement is made up of 6 principal clauses

• The SELECT clause is made up to 6 principal statments

• A SELECT statement must have at least 2 SELECT clauses to be a valid statement

How can you get all columns from a table?

• SELECT ALL columns FROM table

• SELECT TOP all FROM table

• SELECT top 10 * FROM table

• SELECT * FROM table

What expression must we use when a column has been created with empty spaces in the name?

• ; my column;

• " my column"

• [my column]

What is the purpose of the GROUP BY clause in a SQL query?

• It is used to sort the result set in ascending order

• It is used to group the result set based on the values of a specified column

• It is used to filter the result set based on a specified condition

When should the HAVING clause be used in a SQL query?

• When you want to filter the result set based on a specified condition

• When you want to group the result set based on the values of a specified column

• When you want to sort the result set in descending order

What is the purpose of the ORDER BY clause in a SQL query?

• It is used to filter the result set based on a specified condition

• It is used to sort the result set based on the values of a specified column

• It is used to group the result set based on the values of a specified column

What does the SQL INSERT statement do?

• Adds new records to a table

• Modifies existing records in a tabl

• Retrieves data from a table

• Deletes records from a table