Archives of the TeradataForum
Message Posted: Sun, 24 Jul 2005 @ 13:54:27 GMT
| Subj: || || Re: Create set table: problem |
| From: || || Dieter Noeth |
Anomy Anom wrote:
| ||I was taking the practice test for TD SQL in one of the sites. The below question baffles me. Experts pls throw some light!|| |
> CREATE SET TABLE A (A Integer, B Integer) Unique Primary Index (A)
> INSERT INTO Table A (1, 2)
> INSERT INTO Table A (1, 1)
> UPDATE Table A SET b = b + 1 WHERE b = 1.
> Which statement is correct?
> Both the INSERTs and the UPDATE fails.
> The INSERTs work, but the UPDATE fails. (MISSED)
> Only the first INSERT works. (INCORRECT)
> Only the second INSERT works.
> The CREATE TABLE fails.
Did you cut&paste the questions?
Then answer 1 is correct: Both the INSERTs and the UPDATE fails, because the "table" keyword will produce a syntax error.
If the table keyword is removed, then 3 is correct.
| ||1. The first time i tried the create table and inserts, the 2 inserts did really work!! The show table showed a just a primary index
instead of a UNIQUE PI.|| |
| ||2. The subsequent times i dropped and recreated the table, it does show a UPI and stops the second insert!|| |
Did you rerun exactly the same statements or did you retype them?
| ||Could anyone pl explain. Is (1) a figment of my own imagination -- did i miss seeing the UPI?? or is it possible?|| |
It should be impossible. Did you run it in QueryMan? Then you might check the history.
| ||The answer practice test question from the site adds to the confusion!!|| |
Which site, hopefully not NCR's :-)