Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 24 Jul 2005 @ 09:33:17 GMT


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


Subj:   Create set table: problem
 
From:   Anomy Anom

<-- Anonymously Posted: Sunday, July 24, 2005 00:10 -->

Hello All,

I was taking the practice test for TD SQL in one of the sites. The below question baffles me. Experts pls throw some light!

Question

     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?

Answers

     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.

Problem:

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!


Could anyone pl explain. Is (1) a figment of my own imagination -- did i miss seeing the UPI?? or is it possible? The answer practice test question from the site adds to the confusion!!


Thanks



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016