Free NR0-013 Braindumps

Consider the following SQL statement: SELECT colA, colB, SUM(colX) FROM table1
WHERE colA > 45 GROUP BY colA HAVING SUM(colX) = 20; Which statement is true
?

A. The query succeeds.
B. The query fails because of the WHERE clause
C. The query fails because of the HAVING clause.
D. The query fails because of the GROUP BY clause.

Answer(s): D

QUESTION: 32
The MINUS operator is equivalent to ------------------

A. LESS
B. NOT IN
C. EXCEPT
D. SUBTRACT
E. INTERSECT

Answer(s): C

QUESTION: 33
Table_1 has only one column and contains these values (100, 200, 300, 400, 500).
Table_2 has only one column and contains these values (100, 200, 250, 275, 500). If you
use the EXCEPT operator between these tables, where Table_1 is the first table, what
would the result set contain?

A. 250, 275
B. 300, 400
C. 100, 200, 500
D. 250, 275, 300, 400
E. 100, 200, 250, 275, 300, 400, 500
F. 100, 100, 200, 200, 250, 275, 300, 400, 500, 500

Answer(s): B

QUESTION: 34
Which Teradata SQL function determines the position where a substring begins within a
string?

A. POS
B. INDEX
C. CHARPOS
10

Get The Premium Version

Allbraindumps.com
 Test Questions PDF from Myitguides.com

 Test Questions PDF from Myitguides.com