QUESTION: 13

Which statement is written correctly?

DELETEUserlist FROM ALL;
DELETE WHEREUserDate < DATE '2000-01-01';
DELETEUserList WHERE UserDate < DATE '2000-01-01' ALL;
DELETE FROMUserlist WHERE UserDate < DATE '2000-01-01';

Answer(s): B

Given the following query:

SELECT Item, CAST(Cost AS INTEGER)
FROM StoreInv
ORDER BY Item;

The statement returns the following rows:
Item Cost
1001 10
1002 11
1004 9
1010 10

Given the following additional query:
SELECT Item, Cost
FROM WarehouseInv
ORDER BY Item;

The statement returns the following rows:
Item Cost
1001 9.7
1002 11.0
1005 12.0
1006 13.5

Given the union of the following two queries:
SELECT Item, CAST(Cost AS INTEGER)
FROM StoreInv
UNION
SELECT Item, Cost
FROM WarehouseInv;

How many rows will the query return?

1
5
7
8
An error is returned

Answer(s): E

Reveal Solution Next Question

QUESTION: 15

A company wants to extract statistical salary information from a sample employee population. It would like to create 10 salary partitions, with $0 as the lower bound and $1, 000, 000 as the upper bound.
Which ordered analytical function should be used?

RANK
QUANTILE
SAMPLE_ID
WIDTH_BUCKET

Answer(s): C

Reveal Solution Next Question

QUESTION: 16

Given the following:

Job Description Name Salary Amount
Programmer Smithson, John 55, 000
Salesman Germain, Frank 75, 000
Carpenter Johnson, Mark 40, 000

After switching over to ANSI mode, an error was generated with the following statement:
SELECT CAST(Name AS CHAR(5))
What caused the error?

In Release 12 ofTeradata, ANSI mode has been eliminated.
In ANSI mode, the CAST function can only be completed in the WHERE clause.
In ANSI mode, the CAST function does not permit truncation ofnonpad characters.
In ANSI mode, the TRIM function should have been used to truncate character strings.

Answer(s): A

Reveal Solution Next Question

Free TE0-122 Exam Braindumps (page: 5)

QUESTION: 13

QUESTION: 14

QUESTION: 15

QUESTION: 16

TE0-122 Discussions & Posts