Section 1
Preview this deck
39)sentence best describes the difference between an inline table-valued UDF and a multistatement table-valued UDF?
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
6 years ago
Date created
Mar 1, 2020
Cards (51)
Section 1
(50 cards)
39)sentence best describes the difference between an inline table-valued UDF and a multistatement table-valued UDF?
a multistatement (.....) table variable.
21) XML data type method do you use to shred XML data to tabular format?
nodes()
5) considered bad practices
-- Using * -- Not assigning
2) relationship between SQL and T-SQL
SQL standard and T-SQL dialect in Microsoft
38) turn off nested triggers on a SQL Server instance by using T-SQL?
.... 0 followed by the RECONFIGURE statement
26) result of the WITH CHECK OPTION in a view that has a WHERE clause in its SELECT statement?
only one with (WHERE clause) at the end
33)only possible when using the MERGE statement in regard to the OUTPUT clause?
Referring to columns
12) operator does the order of the input queries matter
EXCEPT
27) following are true about synonyms
--do not store T-SQL code or data --can reference objects in other data bases
18) returns a table with key phrases associated with the full-text indexed column?
SEMANTICKEYPHRASETABLE
15) What is the default frame window functions
-- RANGE -- RANGE
35) SET XACT_ABORT ON affect a transaction?
>10 occurs will be aborted
43) What levels can an index have?
Intermediate level Root level Leaf level
46) you fetch rows from a cursor, how do you know when there are no more rows to fetch?
.... -1
22) Which of the following are T-SQL regular identifiers?
-- categoryname -- category_name
9) OFFSET-FETCH
OFFSET 25 rows ×2
13) general set function
... is not NULL.
31) function do you use to return the last identity value generated in a specific table?
IDENT_CURRENT
50) following SET commands would prevent execution plan reusage?
SET CONCAT_NULL_YIELDS_NULL OFF
41)read a graphical execution plan?
from right to left, from top to bottom
29) modify a column value in a target row and collect the result of the modification in one visit to the row?
UPDATE with a variable
14) PIVOT operator determine what the grouping element is?
determined by elimination
48) Can you have indexes on table variables?
yes indirectly by defining primary key and unique constraints
16) ...Semantic Search feature?
semanticsdb
45) limit for the number of steps in statistic histograms?
200 steps per histogram
17) not a part of the CONTAINS predicate?
TEMPORARY
47)need to operate on one row at a time, what are the alternatives to using a cursor?
using a top (1)
32) clause of the MERGE statement isn't standard?
the WHEN NOT MATCHED BY SOURCE clause
19)directive of the FOR XML clause should you use to produce element-centric XML?
ELEMENTS
7) three-valued logic refer to
..... unknown
8) orderdate descending, and then by orderid, descending
orderdate DESC, orderid DESC
23) Which of the following columns would be appropriate as a surrogate key?
-- An automatically -- A uniqueidentifier (GUID)
28) the things that the SELECT INTO statement doesn't copy from the source?
Indexes Constraints Triggers
3) correctly represents the logical query
FROM> ( TO ) >ORDER BY
11) scalar subquery returns more than one value
fails at run time
6) CASE expression and searched CASE
..... WHEN clauses
30) the following is applicable to a TRUNCATE statement?
The statement resets The statement is disallowed The statement is disallowed
24) metadata tables give you a list of constraints in a database?
sys.key_constraints sys.default_constraints sys.foreign_keys
34) T-SQL statements automatically occur in the context of a transaction?
alter table command update command
4) ability to assign attribute aliases
-- using -- an expression
37)following T-SQL statements can be used to cause branching within a stored procedure?
WHILE IF/ELSE
44) does SQL Server sort the data, if a sort is needed?
SQL server sorts
25) the result of WITH SCHEMABINDING in a view
....unless the view is first dropped.
1) violation of relational model
query have names
36) following are true about the SET QUOTED_IDENTIFIER statement?
ON... column names OFF... delimit strings
20) node type test can be used to retrieve all nodes of an XML instance?
node()
10) standard join syntax without changing the meaning of the join
--- inner --- outer
49) aggregation algorithms does SQL Server use?
Stream aggregation Hash aggregation
42) find the text of the query executed by using DMOs?
by querying the sys.dm_exec_sql_text
40)not a part of an Extended Events package?
sources
Section 2
(1 card)