Querying SQL Server with Transact-SQL

What is your Name?

What keyword is used to retrieve data from a SQL Server database?

• RETRIEVE

• SELECT

• FETCH

• SEARCH

How can you filter the retrieved data using a WHERE clause?

• SELECT ALL FROM table_name WHERE column_name != 'value';

• SELECT * FORM table_name WHERE column_name LIKE 'value';

• SELECT * FROM table_name WERE column_name IN ('value1', 'value2');

• SELECT * FROM table_name WHERE column_name = 'value';

Explain the difference between the SELECT and SELECT DISTINCT statements.

• The SELECT statement retrieves all rows from a table, including duplicates, while the SELECT DISTINCT statement retrieves only unique rows by adding duplicates.

• The SELECT statement retrieves all rows from a table, including duplicates, while the SELECT DISTINCT statement retrieves only unique rows by keeping duplicates.

• The SELECT statement retrieves all rows from a table, including duplicates, while the SELECT DISTINCT statement retrieves only unique rows by eliminating duplicates.

• The SELECT statement retrieves only unique rows by eliminating duplicates, while the SELECT DISTINCT statement retrieves all rows from a table, including duplicates.

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

• To sort the result set based on specified columns in ascending or descending order.

• To group the result set based on specified columns

• To filter the result set based on specified conditions

• To join multiple tables in the query

How can you limit the number of rows returned by a query in SQL Server?

• SELECT FIRST * FROM table_name;

• SELECT TOP * FROM table_name;

• LIMIT SELECT * FROM table_name;

• SELECT * FROM table_name LIMIT ;

What is the role of the INSERT statement in SQL Server?

• The role of the INSERT statement in SQL Server is to add new records (rows) to a table.

• The INSERT statement in SQL Server is used to update existing records in a table.

• The INSERT statement in SQL Server is used to delete records from a table.

• The INSERT statement in SQL Server is used to create a new table.

What is correct Logical Order of Query Processing

• SELECT
  FROM

  WHERE

  ORDER BY

  GROUP BY

• SELECT
  FROM

  WHERE

  GROUP BY

  ORDER BY

• FROM

  WHERE

  GROUP BY

  SELECT

  ORDER BY

• FROM

  WHERE

  SELECT

  GROUP BY

  ORDER BY