Quiz
MNSU CIS 440 Fall 2020 Quiz 2
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (25)
1Microsoft SQL Server uses:
- AT-SQL
- BPL/SQL
- CDDL
- DDML
2The 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.
- ATrue
- BFalse
3With the exception of the database creation process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.
- ATrue
- BFalse
4Which clause is specifically used with aggregate functions?
- AWHERE
- BDISTINCT
- CHAVING
- DORDER BY
5The underscore wildcard is used just like % but instead of matching multiple characters, the underscore matches just a single character.
- ATrue
- BFalse
6Which SQL statement is used to return only different values?
- ASELECT UNIQUE
- BSELECT DIFFERENT
- CSELECT DISTINCT
- DAll of the above
7Which SQL keyword is used to sort the result-set?
- ASORT
- BSORT BY
- CORDER
- DORDER BY
8Which one of the following is NOT part of DDL?
- ASELECT INTO
- BCREATE
- CALTER
- DTRUNCATE
9CAST is unique to T-SQL.
- ATrue
- BFalse
10Which one of the following JOIN includes all rows from the second table and matching rows from the first table?
- AInner Join
- BLeft Outer Join
- CRight Outer Join
- DFull Outer Join
11What is the most common type of join?
- AInner Join
- BLeft Outer Join
- CRight Outer Join
- DFull Outer Join
- ESelf Join
12Which SQL statement is used to create a table in a database?
- ACREATE TABLE
- BCREATE DB
- CCREATE DATABASE TABLE
- DCREATE DATABASE TAB
13Which SQL statements uses the keyword SET?
- ASELECT
- BUPDATE
- CMODIFY
- DDELETE
14A table may be joined to itself.
- ATrue
- BFalse
15The FULL OUTER JOIN syntax is not supported by Microsoft Access.
- ATrue
- BFalse
16A set of SQL statements (one or more) typically grouped together to perform a specific routine is called ____________.
- AViews
- BCursors
- CStored Procedures
- DIndexes
17According to the rules of precedence, which of the following computations should be completed first?
- Aperforming additions and subtractions
- Bperforming multiplications and divisions
- Cperforming operations within parentheses
- Dperforming power operations
18The special operator used to check whether an attribute is within a range of values is ___________.
- ABETWEEN
- BLIKE
- CIN
- DNULL
19To list the contents of a table, you must use the DISPLAY command.
- ATrue
- BFalse
20The SQL data manipulation command HAVING:
- Arestricts the selection of rows based on a conditional expression.
- Brestricts the selection of grouped rows based on a condition.
- Cmodifies an attribute's value in one or more table's rows.
- Dgroups the selected rows based on one or more attributes.
21You can call a stored procedure from within itself.
- ATrue
- BFalse
22A temporary stored procedure with global scope has the following prefix:
- A#
- B##
- C!
- DEXECUTE_AS
23Which one of the following is used to prevent SQL injection attacks?
- AStored Procedures
- BTriggers
- CUser-Defined Functions
- DViews
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.- ATrue
- BFalse
25Which 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.- AINNER JOIN
- BLEFT OUTER JOIN
- CFULL OUTER JOIN
- DRIGHT OUTER JOIN
- EMERGE
Information
- Description
- CIS 440 Quiz 2 of Fall 2020 offered by Minnesota State University, Makato.
- Author
- Kyle Peterson
- Language
- English
- Views
- 168
- History
- Created on 6 Dec 2020 · updated on 6 Dec 2020
- Tags
- Rating
- No ratings yet Rate this quiz