Archives of the TeradataForum

Message Posted: Sun, 24 Jul 2005 @ 13:42:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Anomy Anom wrote:

Which site?

          > EXEC MACRO UPDROW(:'abc', :123); (MISSED)
          > EXEC MACRO UPDROW VALUES('abc', 123);
          > EXEC UPDROW VALUES('abc', 123);
          > EXEC UPDROW ('abc', 123); (INCORRECT)
          > EXEC UPDROW (:'abc', :123)

1 & 2: wrong, because of the "EXEC MACRO", it's just EXEC

3: wrong, because of VALUES, this is no Insert

4: Correct

5: wrong, because of :'abc', a colon indicates a parameter, but there are no quoted parameters

I really don't know :-(

          > By Using a Nested Join.
          > By using a Macro. (INCORRECT)
          > By using a Volatile Temporary Table.
          > By using a View. (CORRECT)

?

Only a macro could be considered correct, because it's an EXEC and the UPDATE might be hidden within the macro.

Another possible solution: Insert/Select into a new table, drop old and rename.

          > SELECT region, state, store_number, total_sales
          > WITH sum(total_sales) BY region,
          > Avg(total_sales), Sum(total_sales)>From Sales_Table;

Nothing, because it will result in an syntax error.

          > Total sales by store with subtotals by state within region.
          > Total sales by state within region.
          > Total sales by store with subtotals by region and average and total
          > sales within state. (MISSED)
          > Total sales by region within state. (INCORRECT) --  I choose it based on
          > GUESS. but is there a way the above select can run??

Only if there's another WITH added, but don't ask me about the exact result set, i never used WITH.

          > Cast
          > Pos
          > Substring (INCORRECT) -- why not?? select substring('Ben Johnson' from 1
          > for 3)
          > Coalesce (MISSED)

Of course Substring is correct.

Hopefully the real exam questions are better than those ;-)

Dieter

	<Prev	Next>		<<First	<Prev	Next>	Last>>