MNSU CIS 440 Fall 2020 Quiz 2

Microsoft SQL Server uses:

The COUNT function is designed to tally the number of non-null "values" of an attribute and is often used in conjunction with the DISTINCT clause.

With the exception of the database creation process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

Which clause is specifically used with aggregate functions?

The underscore wildcard is used just like % but instead of matching multiple characters, the underscore matches just a single character.

Which SQL statement is used to return only different values?

Which SQL keyword is used to sort the result-set?

Which one of the following is NOT part of DDL?

CAST is unique to T-SQL.

Which one of the following JOIN includes all rows from the second table and matching rows from the first table?

What is the most common type of join?

Which SQL statement is used to create a table in a database?

Which SQL statements uses the keyword SET?

A table may be joined to itself.

The FULL OUTER JOIN syntax is not supported by Microsoft Access.

A set of SQL statements (one or more) typically grouped together to perform a specific routine is called ____________.

According to the rules of precedence, which of the following computations should be completed first?

The special operator used to check whether an attribute is within a range of values is ___________.

To list the contents of a table, you must use the DISPLAY command.

The SQL data manipulation command HAVING:

You can call a stored procedure from within itself.

A temporary stored procedure with global scope has the following prefix:

Which one of the following is used to prevent SQL injection attacks?

-- Using a variable with CONCAT DECLARE @a VARCHAR(30) = 'My birthday is on ' DECLARE @b DATE = '1980/08/25' SELECT CONCAT (@a, @b) AS RESULT; The above query will yield an error.

Which type of JOIN reflects is the following statement: All rows from the left side of the join, even if there is not a match, and all rows from the right side, even if there is not a match, show up in the results.