Teradata Certified SQL Specialist V2R5

Which column(s) does DISTINCT apply to in the following query?
SELECT DISTINCT dept_num, job_code FROM employee;
A - dept_num
B - job_code
C - dept_num and job_code
D - It does not apply to either column as the query needs parentheses.

Correct: C


Which two symbols serve as wildcards in the string expression of the LIKE operator?
A - _ and %
B - _ and $
C - $ and %
D - & and %

Correct: A


Which option is available with Global Temporary tables:
A - Permanent Journaling
B - Referential Constraints
C - Identity Column
D - Collect Statistics

Correct: D