Free NR0-013 Braindumps



Answer(s): A, C, F

QUESTION: 19
Which two are correct uses of table aliasing to avoid Cartesian product joins? (Choose two.)

A. SEL * FROM table_a A1, table_a WHERE A1.acct1 = table_a.acct2
B. SEL * FROM table_a A1, table_a A2 WHERE A1.acct1 = A2.acct2
C. SEL * FROM table_a A1, table_a A2 WHERE A1.acct1 = table_a.acct2
D. SEL A1.c1, table_a.c2 FROM table_a A1, table_a A2 WHERE A1.acct1 =A2.acct2

Answer(s): A, B

QUESTION: 20
Click the Exhibit button. Given the two tables and the query shown in the exhibit, what is the
result set?
A. 5, NULL
B. 2, NULL
C. 2, 2300
D. 3, NULL
E. 2, 20000

Answer(s): B
6

Get The Premium Version

Allbraindumps.com
 Test Questions PDF from Myitguides.com

 Test Questions PDF from Myitguides.com