数据库管理员英文数据库面试题集 英文的
问题：数据库面试题集 英文的 回答：
Question: Log Table, What is log table What is the use of log table
Answer:The Error Table contains information concerning:
- Data conversion errors Constraint violations and other error conditions:
Contains rows which failed to be manupulated due to constraint violations or Transalation error
Captures rows that contains duplicate Values for UPIs.
It logs errors exceptions that occurs during the apply phase.
It logs errors that are occurs during the acquisition phase.
what is basic teradata query language
BTEQ(Basic teradata query)
It allows us to write SQL Statements along with BTEQ commands. We can use BTEQ for importing,exporting and reporting purposes.
The commands start with a (.) dot and can be terminated by using (;), it is not mandatory to use (;). SQL statements doesnt start with a dot , but (;) is compulsary to terminate the SQL statement.
BTEQ will assume any thing written with out a dot as a sql statement and requires a (;) to terminate it.
How teradata makes sure that there are no duplicate rows being inserted when its a SET table
Teradata will redirect the new inserted row as per its PI to the target AMP (on the basis of its row hash value), and if it find same row hash value in that
AMP (hash synonyms) then it start comparing the whole row, and find out if duplicate.
If its a duplicate it silently skips it without throwing any error

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。