What is a Teradata Database macro?
Teradata Database macros are SQL statements that the server stores and executes. Macros provide an easy way to execute frequently used SQL operations. Macros are particularly useful for enforcing data integrity rules, providing data security, and improving performance. SQL Used to Create a Macro
What is Teradata SQL assistant?
Teradata SQL Assistant a means of information storage, manipulation, and discovery in Teradata Databa se (or other database that provides an ODBC interface). Teradata SQL Assistant also supports connectivity using .NET Data Provider for Teradata. Teradata SQL Assistant Java Edition runs on any platform that supports Java.
What access modules does Teradata Database support?
Teradata Database supports the following access modules, which read data, but do not write it. † Named Pipes Access Module, which enables you to load data into the Teradata Database from a UNIX OS named pipe. A pipe is a type of data buffer that certain operating systems allow applications to use for the storage of data.
What SQL DML commands can I use on Teradata Database?
Every time you log on to Teradata Database, perform an SQL query, or type a password, you are using the Data Dictionary. For security and data integrity reasons, the only SQL DML command you can use on the Data Dictionary is the SELECT statement.
Teradata Advanced DBA EXAM GUIDE - Table of Contents