MNSU CIS 440 Fall 2020 Quiz 2

Question 1

Microsoft SQL Server uses:

Accepted Answer

T-SQL

Answer

PL/SQL

Answer

DDL

Answer

DML

Question 2

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

Question 3

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

Answer

true

Question 4

Which clause is specifically used with aggregate functions?

Accepted Answer

HAVING

Answer

WHERE

Answer

DISTINCT

Answer

ORDER BY

Question 5

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

Answer

true

Question 6

Which SQL statement is used to return only different values?

Accepted Answer

SELECT DISTINCT

Answer

SELECT UNIQUE

Answer

SELECT DIFFERENT

Answer

All of the above

Question 7

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

Accepted Answer

ORDER BY

Answer

SORT

Answer

SORT BY

Answer

ORDER

Question 8

Which one of the following is NOT part of DDL?

Accepted Answer

SELECT INTO

Answer

CREATE

Answer

ALTER

Answer

TRUNCATE

Question 9

CAST is unique to T-SQL.

Answer

true

Question 10

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

Accepted Answer

Right Outer Join

Answer

Inner Join

Answer

Left Outer Join

Answer

Full Outer Join

Question 11

What is the most common type of join?

Accepted Answer

Inner Join

Answer

Left Outer Join

Answer

Right Outer Join

Answer

Full Outer Join

Answer

Self Join

Question 12

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

Accepted Answer

CREATE TABLE

Answer

CREATE DB

Answer

CREATE DATABASE TABLE

Answer

CREATE DATABASE TAB

Question 13

Which SQL statements uses the keyword SET?

Accepted Answer

UPDATE

Answer

SELECT

Answer

MODIFY

Answer

DELETE

Question 14

A table may be joined to itself.

Answer

true

Question 15

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

Answer

true

Question 16

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

Accepted Answer

Stored Procedures

Answer

Views

Answer

Cursors

Answer

Indexes

Question 17

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

Accepted Answer

performing operations within parentheses

Answer

performing additions and subtractions

Answer

performing multiplications and divisions

Answer

performing power operations

Question 18

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

Accepted Answer

BETWEEN

Answer

LIKE

Answer

IN

Answer

NULL

Question 19

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

Answer

true

Question 20

The SQL data manipulation command HAVING:

Accepted Answer

restricts the selection of grouped rows based on a condition.

Answer

restricts the selection of rows based on a conditional expression.

Answer

modifies an attribute's value in one or more table's rows.

Answer

groups the selected rows based on one or more attributes.

Question 21

You can call a stored procedure from within itself.

Answer

true

Question 22

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

Accepted Answer

##

Answer

#

Answer

!

Answer

EXECUTE_AS

Question 23

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

Accepted Answer

Stored Procedures

Answer

Triggers

Answer

User-Defined Functions

Answer

Views

Question 24

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

Question 25

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.

Accepted Answer

FULL OUTER JOIN

Answer

INNER JOIN

Answer

LEFT OUTER JOIN

Answer

RIGHT OUTER JOIN

Answer

MERGE

MNSU CIS 440 Fall 2020 Quiz 2

Erstelle ein kostenloses Konto, um dieses Quiz zu beenden

Fragen in diesem Quiz (25)

Informationen

Feedback

Wie gefällt dir das neue Design?