Free TE0-122 Exam Braindumps (page: 7)

Page 6 of 38

Which expression will return what hour it will be in 3 hours 30 minutes?

  1. EXTRACT(HOUR FROM CURRENT_TIME + '03:30')
  2. EXTRACT(HOUR FROM CURRENT_TIME + '3:30' HOUR TO SECOND INTERVAL)
  3. EXTRACT(HOUR FROM CURRENT_TIME + INTERVAL '3:30' HOUR TO MINUTE)
  4. EXTRACT(HOUR FROM CURRENT_TIME + INTERVAL ('3' HOUR + '30' MINUTE))
  5. EXTRACT(HOUR FROM CURRENT_TIME + ('3' HOUR + '30' MINUTE) INTERVAL)

Answer(s): D



A table contains the following column:
Inv_TSTIMESTAMP(6) WITH TIME ZONE

Which expression returns the normalized hour (for the current session time zone) of column Inv_TS?

  1. EXTRACT(HOUR FROMInv_TS)
  2. HOUR(Inv_TS AS TIMESTAMP(6))
  3. HOUR(CAST(Inv_TS AS TIMESTAMP(6)))
  4. EXTRACT(HOUR FROM CAST(Inv_TS AS TIMESTAMP(6)))

Answer(s): C



Which statement is written correctly?

  1. SELECT *, table2.logdate, table2.logtime
    FROM DBC.ResUsageSPMA db1
    WHERE db1.thedate = table2.logdate
    AND db1.thetime = table2.logtime;
  2. SELECT table2.logdate, table2.logtime, (*)
    FROM DBC.ResUsageSPMA db1
    WHERE db1.thedate = table2.logdate
    AND db1.thetime = table2.logtime;
  3. SELECT table2.logdate, table2.logtime, *
    FROM DBResUsageSPMA db1
    WHERE db1.thedate = table2.logdate
    AND db1.thetime = table2.logtime;
  4. SELECT table2.logdate, table2.logtime, db1.*
    FROM DBC.ResUsageSPMA db1
    WHERE db1.thedate = table2.logdate
    AND db1.thetime = table2.logtime;

Answer(s): C



Given the following PPI table:

CREATE TABLE SalesHistory_Store1(
Product_CodeCHAR(8)
, Store_Number INTEGER
, Transaction_Date DATE
, Quantity_Sold INTEGER
, Notes CHAR(50))
PRIMARY INDEX (Product_Code, Store_Number, Transaction_Date)
PARTITION BY RANGE_N (Transaction_Date BETWEEN
DATE '2009-01-01' AND DATE '2011-12-31' EACH INTERVAL '1' DAY);

Which table, when joined with the given table, may result in a rowkey-based merge join?

  1. CREATE TABLE SalesHistory_Store2(
    Product_CodeCHAR(8)
    , Store_Number INTEGER
    , Transaction_Date DATE
    , Quantity_Sold INTEGER)
    PRIMARY INDEX (Product_Code, Store_Number, Transaction_Date)
    PARTITION BY RANGE_N (Transaction_Date BETWEEN
    DATE '2009-01-01' AND DATE '2011-12-31' EACH INTERVAL '1' DAY);
  2. CREATE TABLE SalesHistory_Store2(
    Product_CodeCHAR(8)
    , Store_Number INTEGER
    , Transaction_Date DATE
    , Quantity_Sold INTEGER
    , Notes CHAR(50))
    PRIMARY INDEX (Product_Code, Store_Number)
    PARTITION BY RANGE_N (Transaction_Date BETWEEN
    DATE '2009-01-01' AND DATE '2011-12-31' EACH INTERVAL '1' DAY);
  3. CREATE TABLE SalesHistory_Store2(
    Product_CodeCHAR(8)
    , Store_Number INTEGER
    , Transaction_Date DATE
    , Quantity_Sold INTEGER
    , Notes CHAR(50))
    PRIMARY INDEX (Product_Code, Store_Number, Transaction_Date)
    PARTITION BY RANGE_N (Transaction_Date BETWEEN
    DATE '2009-01-01' AND DATE '2011-12-31' EACH INTERVAL '1' MONTH);
  4. CREATE TABLE SalesHistory_Store2(
    Product_CodeCHAR(8)
    , Store_Number INTEGER
    , Transaction_Date DATE
    , Quantity_Sold INTEGER
    , Notes CHAR(50))
    PRIMARY INDEX (Product_Code, Store_Number, Transaction_Date)

Answer(s): C






Post your Comments and Discuss TeraData TE0-122 exam with other Community members:

TE0-122 Discussions & Posts