T-SQL And General SQL: Unit 1 - Introduction To SQL Queries

1. SQL: What operator would you use to find values that are not in a specified list?

NOT IN LIST

NOT IN

IS NOT IN

The NOT IN operator is used to find values that are not present in a specified list. It is commonly used in SQL queries to filter out records that do not match the values provided in the list. By using the NOT IN operator, you can easily exclude specific values from the result set based on your criteria.

Explanation

The NOT IN operator is used to find values that are not present in a specified list. It is commonly used in SQL queries to filter out records that do not match the values provided in the list. By using the NOT IN operator, you can easily exclude specific values from the result set based on your criteria.

2. SQL: what operator is used to perform a search that matches a range of values?

The operator used to perform a search that matches a range of values in SQL is "BETWEEN". It is case-insensitive, so it can be written as "between" or "Between" as well. This operator is commonly used in SQL queries to specify a range of values for a particular condition, such as selecting records with values between a certain minimum and maximum value.

Explanation

The operator used to perform a search that matches a range of values in SQL is "BETWEEN". It is case-insensitive, so it can be written as "between" or "Between" as well. This operator is commonly used in SQL queries to specify a range of values for a particular condition, such as selecting records with values between a certain minimum and maximum value.

Submit

3. T-SQL: What keyboard shortcut do you use in sql server management studio to execute an sql statement?

Pressing the F5 key in SQL Server Management Studio allows the user to execute an SQL statement. This shortcut is commonly used to quickly run queries and commands without the need to manually click on the execute button.

Explanation

Pressing the F5 key in SQL Server Management Studio allows the user to execute an SQL statement. This shortcut is commonly used to quickly run queries and commands without the need to manually click on the execute button.

Submit

4. SQL: What operator is used to compare against null values?

The operator "IS NULL" is used to compare against null values in SQL. It can be written in lowercase or uppercase letters, as "is null" or "Is Null". This operator is used to check if a value is null or not, as null values cannot be compared using the regular comparison operators such as "=", ">", "

Explanation

The operator "IS NULL" is used to compare against null values in SQL. It can be written in lowercase or uppercase letters, as "is null" or "Is Null". This operator is used to check if a value is null or not, as null values cannot be compared using the regular comparison operators such as "=", ">", "

Submit

5. SQL: What operator(s) is used to compare against values that are not null?

The operator "IS NOT NULL" is used in SQL to compare against values that are not null. This operator is case-insensitive, so it can be written as "is not null" or "Is Not Null" as well. It is used in conditional statements to filter out rows where a particular column does not have a null value.

Explanation

The operator "IS NOT NULL" is used in SQL to compare against values that are not null. This operator is case-insensitive, so it can be written as "is not null" or "Is Not Null" as well. It is used in conditional statements to filter out rows where a particular column does not have a null value.

Submit

6. SQL: What operator would you use to compare against values that are not like other values?

NOT LIKE

IS NOT LIKE

NOT IS LIKE

The NOT LIKE operator is used in SQL to compare values that are not similar to other values. It allows for the comparison of strings based on patterns, where the specified pattern does not match the values being compared. This operator is useful when you want to retrieve records that do not have a specific pattern or do not match a certain string.

Explanation

The NOT LIKE operator is used in SQL to compare values that are not similar to other values. It allows for the comparison of strings based on patterns, where the specified pattern does not match the values being compared. This operator is useful when you want to retrieve records that do not have a specific pattern or do not match a certain string.

7. T-SQL: A column name can be specified without using the 'AS' keyword as folows: SELECT sal*1.10 new_sal FROM dbo.emp

True

False

Either

SELECT sal*1.10 new_sal
FROM dbo.emp

or

SELECT sal * 1.10 AS new_sal
FROM dbo.emp

is valid.

Explanation

Either

SELECT sal*1.10 new_sal
FROM dbo.emp

or

SELECT sal * 1.10 AS new_sal
FROM dbo.emp

is valid.

8. SQL: What operator would you use to compare against values that are not null?

NOT NULL

NOT IS NULL

IS NOT NULL

!NULL

The IS NOT NULL operator is used in SQL to compare values that are not null. It returns true if the value is not null and false if the value is null. This operator is commonly used in WHERE clauses to filter out null values from the result set.

Explanation

The IS NOT NULL operator is used in SQL to compare values that are not null. It returns true if the value is not null and false if the value is null. This operator is commonly used in WHERE clauses to filter out null values from the result set.

9. SQL: What is the 'not equals' operator?

The 'not equals' operator in SQL is represented by the symbol ''. It is used to compare two values and returns true if the values are not equal, and false if they are equal. It is commonly used in SQL queries to filter out specific values that do not match a certain condition.

Explanation

The 'not equals' operator in SQL is represented by the symbol ''. It is used to compare two values and returns true if the values are not equal, and false if they are equal. It is commonly used in SQL queries to filter out specific values that do not match a certain condition.

Submit

10. SQL: What operator is used for negation?

The operator used for negation in SQL is "NOT". It can be written in lowercase as "not" or in title case as "Not". Another symbol that can be used for negation is the exclamation mark "!".

Explanation

The operator used for negation in SQL is "NOT". It can be written in lowercase as "not" or in title case as "Not". Another symbol that can be used for negation is the exclamation mark "!".

Submit

11. SQL: What operator do you use to perform wildcard matches?

An example is as follows:

SELECT ename, job, deptno
FROM dbo.emp
WHERE ename LIKE 'M%'

Explanation

An example is as follows:

SELECT ename, job, deptno
FROM dbo.emp
WHERE ename LIKE 'M%'

Submit

12. T-SQL: You have a table with a colum entitled 'job', whose values are all lower case. If you execute the following query: SELECT ename, job, deptno FROM dbo.emp WHERE job = 'CLERK' you will not get any results back buecase the match is case sensitve and so because all values of the 'job' colum are lowercase, uppercase 'CLERK' will not be found.

True

False

With SQL Server, the match is not case sensitve

Explanation

With SQL Server, the match is not case sensitve

13. T-SQL: What is the format for the 'date' datatype?

SEE: http://msdn.microsoft.com/en-us/library/bb630352.aspx

Not that date values must be passed in as string (e.g., '1981-06-09')

Explanation

SEE: http://msdn.microsoft.com/en-us/library/bb630352.aspx

Not that date values must be passed in as string (e.g., '1981-06-09')

Submit

14. SQL: What operator(s) can be used to perform a search that is not in a specified range of values?

The correct answer is "NOT BETWEEN". This operator is used in SQL to perform a search that is not within a specified range of values. It allows you to exclude values that fall between two given values. The case sensitivity of the operator does not matter, so it can be written as "Not Between", "not between", "Not between", or "not Between" as well.

Explanation

The correct answer is "NOT BETWEEN". This operator is used in SQL to perform a search that is not within a specified range of values. It allows you to exclude values that fall between two given values. The case sensitivity of the operator does not matter, so it can be written as "Not Between", "not between", "Not between", or "not Between" as well.

Submit

15. SQL: Write an sql statement to insert 1227 and 'Manager' into the 'empno' and 'job' column of the dbo.emp table respectively.

SEE: http://msdn.microsoft.com/en-us/library/ms174335.aspx

Explanation

SEE: http://msdn.microsoft.com/en-us/library/ms174335.aspx

Submit

16. SQL: What does the wildcard expression % stand for?

The wildcard expression % in SQL stands for zero or more characters. This means that when using the % wildcard in a SQL query, it can match any sequence of characters of any length. It is commonly used in conjunction with the LIKE operator to perform pattern matching in SQL queries.

Explanation

The wildcard expression % in SQL stands for zero or more characters. This means that when using the % wildcard in a SQL query, it can match any sequence of characters of any length. It is commonly used in conjunction with the LIKE operator to perform pattern matching in SQL queries.

Submit

17. SQL: What does the wildcard underscore operator (_) stand for?

The wildcard underscore operator (_) in SQL is used to represent any single character. It can be used in a query to match a single character in a specific position within a string. For example, if we have a column with values like "cat", "bat", and "hat", we can use the underscore operator to search for all three-letter words that end with "at" by using the pattern '_at'. This will return all the matching rows with values "cat", "bat", and "hat".

Explanation

The wildcard underscore operator (_) in SQL is used to represent any single character. It can be used in a query to match a single character in a specific position within a string. For example, if we have a column with values like "cat", "bat", and "hat", we can use the underscore operator to search for all three-letter words that end with "at" by using the pattern '_at'. This will return all the matching rows with values "cat", "bat", and "hat".

Submit