MNSU CIS 440 Fall 2020 Quiz 2

Question 1

Question

Microsoft SQL Server uses:

Answer

T-SQL
PL/SQL
DDL
DML

Question 2

Question

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.

Answer

True
False

Question 3

Question

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

Answer

True
False

Question 4

Question

Which clause is specifically used with aggregate functions?

Answer

WHERE
DISTINCT
HAVING
ORDER BY

Question 5

Question

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

Answer

True
False

Question 6

Question

Which SQL statement is used to return only different values?

Answer

SELECT UNIQUE
SELECT DIFFERENT
SELECT DISTINCT
All of the above

Question 7

Question

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

Answer

SORT
SORT BY
ORDER
ORDER BY

Question 8

Question

Which one of the following is NOT part of DDL?

Answer

SELECT INTO
CREATE
ALTER
TRUNCATE

Question 9

Question

CAST is unique to T-SQL.

Answer

True
False

Question 10

Question

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

Answer

Inner Join
Left Outer Join
Right Outer Join
Full Outer Join

Question 11

Question

What is the most common type of join?

Answer

Inner Join
Left Outer Join
Right Outer Join
Full Outer Join
Self Join

Question 12

Question

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

Answer

CREATE TABLE
CREATE DB
CREATE DATABASE TABLE
CREATE DATABASE TAB

Question 13

Question

Which SQL statements uses the keyword SET?

Answer

SELECT
UPDATE
MODIFY
DELETE

Question 14

Question

A table may be joined to itself.

Answer

True
False

Question 15

Question

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

Answer

True
False

Question 16

Question

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

Answer

Views
Cursors
Stored Procedures
Indexes

Question 17

Question

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

Answer

performing additions and subtractions
performing multiplications and divisions
performing operations within parentheses
performing power operations

Question 18

Question

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

Answer

BETWEEN
LIKE
IN
NULL

Question 19

Question

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

Answer

True
False

Question 20

Question

The SQL data manipulation command HAVING:

Answer

restricts the selection of rows based on a conditional expression.
restricts the selection of grouped rows based on a condition.
modifies an attribute's value in one or more table's rows.
groups the selected rows based on one or more attributes.

Question 21

Question

You can call a stored procedure from within itself.

Answer

True
False

Question 22

Question

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

Answer

#
##
!
EXECUTE_AS

Question 23

Question

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

Answer

Stored Procedures
Triggers
User-Defined Functions
Views

Question 24

Question

-- 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.

Answer

True
False

Question 25

Question

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.

Answer

INNER JOIN
LEFT OUTER JOIN
FULL OUTER JOIN
RIGHT OUTER JOIN
MERGE

Next up

MNSU CIS 440 Fall 2020 Quiz 2

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Similar

	Created by Kyle Peterson about 4 years ago