QUESTION: 21

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

EXTRACT(HOUR FROM CURRENT_TIME + '03:30')
EXTRACT(HOUR FROM CURRENT_TIME + '3:30' HOUR TO SECOND INTERVAL)
EXTRACT(HOUR FROM CURRENT_TIME + INTERVAL '3:30' HOUR TO MINUTE)
EXTRACT(HOUR FROM CURRENT_TIME + INTERVAL ('3' HOUR + '30' MINUTE))
EXTRACT(HOUR FROM CURRENT_TIME + ('3' HOUR + '30' MINUTE) INTERVAL)

Answer(s): D

QUESTION: 22

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?

EXTRACT(HOUR FROMInv_TS)
HOUR(Inv_TS AS TIMESTAMP(6))
HOUR(CAST(Inv_TS AS TIMESTAMP(6)))
EXTRACT(HOUR FROM CAST(Inv_TS AS TIMESTAMP(6)))

Answer(s): C

Reveal Solution Next Question

QUESTION: 23

Which statement is written correctly?

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

Answer(s): C

Reveal Solution Next Question

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?

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);
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);
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);
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

Reveal Solution Next Question

Free TE0-122 Exam Braindumps (page: 7)

QUESTION: 21

QUESTION: 22

QUESTION: 23

QUESTION: 24

TE0-122 Discussions & Posts