TDBL4-16.20 Questions and Answers

Company ABC is giving a 2% pay raise for employees earning less than $7%,000 and assigned to a valid department.

Which UPDATE statement will apply this request?

A)

B)

C)

D)

A list of employees with one of the following characteristics must be produced

• Works in Department 40, and the last name is not Johnson or Smith

• Works in Department 60 and earns more than $40,000

Which WHERE clause will produce the needed list?

A)

B)

C)

D)

A research group need to run some queries that will only be needed once. These queries will include intermediate computations. The group has access to the data in the Teradata Database with spool space but no write access.

Which type of table should the research group use to run their ad hoc queries?

In which SQL clauses can a subquery be

What is a characteristic of a permanent table that differentiates it from a volatile or global temporary table?

A developer is fixing an 'out of spoor query and needs to trace the point of failure.

Which DBQL table can be used?

For which scenario can the NOSPOOL mode option in the TPT Export operator be used?

An individual will be using ALTER TABLE to add a new column with a data type of INTEGER and the NOT NULL attribute to a populated table.

Which statement is true about the ALTER TABLE?