QUESTION: 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?

RANK
QUANTILE
ROW_NUMBER
PERCENT_RANK

Answer(s): B

Reveal Solution Next Question

QUESTION: 2

Which two will happen during a transaction when no rows are available in a queue table? (Choose two.)

The transaction aborts automatically.
The SELECT AND CONSUME statement will generate new rows in the table.
The transaction enters a delay state until a row is inserted into the queue table.
The transaction aborts either by an ABORT statement, or a DROP TABLE statement on the queue table.

Answer(s): A,B

Reveal Solution Next Question

QUESTION: 3

Which DCL statement is written correctly?

GRANT SELECT, EXECUTE, DELETE TO User1 ON User1;
GRANT SELECT, EXECUTE, DELETE ON Database1 TO Database1;
GRANT SELECT, EXECUTE, DELETE TO User1 ON DATABASE Database1;
GRANT SELECT, EXECUTE, DELETE ON DATABASE Database1 TO User1;

Answer(s): D

Reveal Solution Next Question

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'?

1
2
3
4
5

Answer(s): B

Reveal Solution Next Question

Free TE0-122 Exam Braindumps (page: 2)

Pass your Teradata 12 SQL exam exam with these free Actual Questions and Answers

QUESTION: 1

QUESTION: 2

QUESTION: 3

QUESTION: 4

TE0-122 Discussions & Posts