Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Teradata TE0-122 Exam - Cheat-Test.com

Free TE0-122 Sample Questions:

Q: 1
A company wants a sequential ranking of all employee salaries. They do not want employees with the same salary to be given the same rank number. Which ordered analytical function should be used?
A. RANK
B. QUANTILE
C. ROW_NUMBER
D. PERCENT_RANK
Answer: B

Q: 2
Which two will happen during a transaction when no rows are available in a queue table? (Choose two.)
A. The transaction aborts automatically.
B. The SELECT AND CONSUME statement will generate new rows in the table.
C. The transaction enters a delay state until a row is inserted into the queue table.
D. The transaction aborts either by an ABORT statement, or a DROP TABLE statement on the
queue table.
Answer: A,B

Q: 3
Which DCL statement is written correctly?
A. GRANT SELECT, EXECUTE, DELETE TO User1 ON User1;
B. GRANT SELECT, EXECUTE, DELETE ON Database1 TO Database1;
C. GRANT SELECT, EXECUTE, DELETE TO User1 ON DATABASE Database1;
D. GRANT SELECT, EXECUTE, DELETE ON DATABASE Database1 TO User1;
Answer: D

Q: 4
Given the following: (? = NULL)
Column1 Column2
JA LZ
JA ?
MX TX
MX LZ
? ?
SELECT CASE WHEN column_1 = 'JA' AND column_2 = 'LZ' THEN 'OK'
WHEN column_1 = 'JA' AND column_2 IS NULL THEN '??'
WHEN column_1 IS NOT NULL AND column_2 = 'LZ' THEN '??'
WHEN column_1 = 'DD' THEN '??'
ELSE 'OK'
END
FROM table_1;
How many rows will the SELECT statement return with the value 'OK'?
A. 1
B. 2
C. 3
D. 4
E. 5
Answer: B

Q: 5
The columns in a Customer table are defined as:
acctid INTEGER NOT NULL
acctnm VARCHAR(50)
and the columns in a Trans table are defined as:
acctid INTEGER NOT NULL
amount DECIMAL(8,2) NOT NULL
The values (where ? indicates NULL) for these columns are the following:
Customer table Trans table
acctid acctnm__ acctid amount
227638 Martin 220532 55.38
220794 Miko 227638 21.73
228326 Nelly 220794 34.14
224753 ? 228326 42.88
216893 Jackie 223961 20.74
220794 15.47
227638 25.64
228326 47.21
The values in the amount column need to be presented in a report so that the column values look like the following:
amount
47.21
42.88
34.14
25.64
21.73
15.47
?
?
Which query provides the desired result?
A. SELECT amount
FROM Customer a LEFT JOIN Trans b
ON a.acctid = b.acctid
ORDER BY 1 DESC;
B. SELECT amount
FROM Customer a LEFT JOIN Trans b
WHERE a.acctid = b.acctid
ORDER BY 1 DESC;
C. SELECT amount
FROM Customer a RIGHT OUTER JOIN Trans b
WHERE a.acctid = b.acctid
ORDER BY 1 DESC;
D. SELECT amount
FROM Customer a
Trans b
ON a.acctid = b.acctid
ORDER BY 1 DESC;
Answer: B

Q: 6
Given the following query:
SELECT * FROM Tbl_1
WHERE Col_1 NOT IN
(SELECT Col_2 FROM Tbl_2);
If one of the Col2 values is NULL, what is the impact on the Tbl_1 rows returned?
A. Tbl_1 will return all rows not in Tbl_2.
B. Tbl_1 will return all of the non-NULL rows.
C. No Tbl_1 rows are returned for the entire query.
D. The Tbl_1 rows that contain a NULL in Col_1 are returned.
Answer: B

Q: 7
Given the following:
CREATE TABLE table1_ppi (
column1 INTEGER NOT NULL
,column2 INTEGER
,column3 DATE FORMAT 'yyyy-mm-dd'
)
PRIMARY INDEX (column1)
PARTITION BY RANGE_N(column3
BETWEEN DATE '2002-01-01' AND DATE '2012-12-31' EACH INTERVAL '1' YEAR,
NO RANGE);
ALTER TABLE table1_ppi
MODIFY PRIMARY INDEX
DROP RANGE BETWEEN DATE '2002-01-01' AND DATE '2002-12-31'
EACH INTERVAL '1' YEAR;
What is an effect of the ALTER TABLE statement?
A. Rows of the dropped partition are deleted.
B. Rows of the NO RANGE partition are deleted.
C. Rows are moved from the dropped partition to the save table.
D. Rows are moved from the dropped partition to the NO RANGE partition.
Answer: C

Q: 8
An aggregation query produces the following result:
storeid prodid sales SumSales
----------- --------- ------------- ------------------
1001 A 100000.00 345000.00
1001 C 60000.00 345000.00
1001 D 35000.00 345000.00
1001 F 150000.00 345000.00
1002 A 40000.00 100000.00
1002 C 35000.00 100000.00
1002 D 25000.00 100000.00
1003 A 30000.00 165000.00
1003 B 65000.00 165000.00
1003 C 20000.00 165000.00
1003 D 50000.00 165000.00
Which three queries will produce this result? (Choose three.)
A. SELECTstoreid
, prodid
, sales
, SUM(sales) OVER (PARTITION BY storeid
ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS SumSales
FROM salestbl
ORDER BY 1,2;
B. SELECTstoreid
, prodid
, sales
, SUM(sales) OVER (PARTITION BY storeid) AS SumSales
FROM salestbl
ORDER BY 1,2;
C. SELECTstoreid
, prodid
, sales
, SUM(sales) OVER (PARTITION BY storeid) AS SumSales
FROM salestbl
GROUP BY 1,2,3
ORDER BY 1,2;
D. SELECTstoreid
, prodid
, sales
, SUM(sales) OVER (PARTITION BY storeid) AS SumSales
FROM salestbl
GROUP BY 1,2,3
ORDER BY 1,2;
Answer: A,B,D

Q: 9
Which three types of user-defined functions does Teradata support? (Choose three.)
A. Table
B. Local
C. Scalar
D. Global
E. Aggregate
Answer: B,D,E

Q: 10
A SELECT query uses the RANK() OVER (ORDER BY batting_avg DESC) syntax to produce a ranking of baseball players. The top ten baseball players are being ranked based on their batting averages. In the resulting output of the query there will be ten rows. There is a two-way tie for the second position and a three-way tie for the last three positions. What will be the ranking number of the player in the final row?
A. 7
B. 8
C. 9
D. 10
Answer: D


© 2014 Cheat-Test.com, All Rights Reserved