Teradata Question:

Download Job Interview Questions and Answers PDF

What is basic teradata query language?

Teradata Interview Question
Teradata Interview Question

Answer:

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.

Download Teradata Interview Questions And Answers PDF

Previous QuestionNext Question
What is cliques? What is Vdisk and how it will communicate with physical data storage at the time of data retrieval through AMP?How many codd s rules are satisfied by teradata database?