1) Which function in Teradata provides the current date and time?

2) Which of the following best describes Teradata’s Skew metric?

3) What is the main purpose of Teradata’s Query Banding feature?

4) Which Teradata command can be used to prevent locking conflicts on a table during queries?

5) In Teradata, which of the following types of compression is most commonly used to reduce storage space for frequently repeating values?

6) Which feature in Teradata helps manage and allocate system resources by prioritizing query workloads?

7) What does the NO PRIMARY INDEX (NOPI) option achieve when creating a table in Teradata?

8) Which of the following table types in Teradata supports automatic deletion of data when a session ends?

9) What is the purpose of the CHECKPOINT option in Teradata’s MultiLoad utility?

10) Which Teradata function calculates the difference in days between two DATE columns?

11) In Teradata, which table property ensures that each row is unique by enforcing a unique primary index?

12) What role does the AMP (Access Module Processor) play in Teradata?

13) Which Teradata join type is typically the most expensive in terms of processing and is avoided when possible?

14) What Teradata feature enables workload management by categorizing queries based on specific criteria?

15) Which Teradata utility is specifically designed for loading large amounts of data into empty tables at high speed?

16) In Teradata, which tool is used to monitor and manage system performance in real-time?

17) What does the INDEX ANALYSIS command in Teradata do?

18) What function does Teradata’s Fallback feature provide?

19) In Teradata, what is the effect of using SKEWNESS to measure data distribution?

20) Which statement best describes Active Data Warehousing in the context of Teradata?