TE0-122 Exam Questions and Answers | Exam-Dumps (Page: 4)

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

QUESTION: 17

A company wants to award a 3% increase in salary to all employees who meet these two criteria:

* They have a valid department assignment.
* Their current salary is less than $50, 000.

Which two statements will accomplish this objective? (Choose two.)

UPDATEemp FROM department AS dept, employee AS emp
SET salary_amount = salary_amount * 1.03
WHERE emp.department_number = dept.department_number
AND salary_amount < 50000;
UPDATE employee ASemp FROM department AS dept
SET salary_amount = salary_amount * 1.03
WHERE emp.department_number = dept.department_number
AND salary_amount < 50000;
UPDATE employee
SET salary_amount = salary_amount * 1.03
WHERE employee.department_number IN
(SELECT department_number FROM department
AND salary_amount < 50000);
UPDATE employee
SET salary_amount = salary_amount * 1.03
WHERE employee.department_number IN
(SELECT department_number FROM department)
AND salary_amount < 50000;

Answer(s): B,D

Reveal Solution Next Question

QUESTION: 18

Given the following CREATE TABLE statement:

CREATE SET TABLE SPA_APPT_AVAILABILITY
( SPA_ID INTEGER NOT NULL
, APPT_DATE DATE NOT NULL
, APPT_TIME CHAR(5) NOT NULL
, TREATMENT_ID INTEGER NOT NULL
, TREATMENT_NAME CHAR(50) NOT NULL
, AESTHETICIAN_ID INTEGER NOT NULL
, COMMENTS VARCHAR(100)
, PRIMARY KEY (SPA_ID, APPT_DATE))
;

Which column(s) will be defined as the primary index?

SPA_ID
TREATMENT_ID
SPA_ID, APPT_DATE
SPA_ID, TREATMENT_ID

Answer(s): D

Reveal Solution Next Question

QUESTION: 19

The date '2009-04-10' is represented by StartDate and the date '2008-03-07' is represented by
EndDate.
Which calculation produces the number of days between the two dates?

EndDate - StartDate
DIFF(EndDate, StartDate)
DAYS(StartDate, EndDate)
EXTRACT(DAY FROMEndDate) - EXTRACT(DAY FROM StartDate)

Answer(s): B

Reveal Solution Next Question

QUESTION: 20

A mobile provider wants to increase the price on a specific feature included in several of their service offers. The feature name contains the string "walkabout".
Which query modifies the correct rows from the Phone_Packages table?

UPDATEPhone_Packages
SET price = price * 1.25
WHERE Features.feature_name LIKE '%walkabout%';
UPDATEPhone_Packages
SET price = price * 1.25
WHERE feature_code IN (SELECT feature_code
FROM Features
WHERE feature_name LIKE '%walkabout%');
UPDATEPhone_Packages FROM Features
SET price = price * 1.25
WHERE Features.feature_name LIKE '%walkabout%';
UPDATEPhone_Packages FROM Features
SET price = price * 1.25
WHERE feature_code IN (SELECT feature_code
FROM Features
WHERE feature_name LIKE '%walkabout%');

Answer(s): D

Reveal Solution Next Question

TeraData TE0-122 Exam (page: 4) TeraData 12 SQL exam Updated on: 25-Dec-2025

QUESTION: 16

QUESTION: 17

QUESTION: 18

QUESTION: 19

QUESTION: 20

TeraData TE0-122 Exam (page: 4)
TeraData 12 SQL exam
Updated on: 25-Dec-2025