represent 0 value.
represent negative infinity.
represent positive infinity.
represent a missing or unknown value. NULL in SQL represents nothing.
TRUNCATE TABLE has to be used along with a WHERE clause
TRUNCATE TABLE is identical to DELETE statement without WHERE clause and both remove all rows in a table.
TRUNCATE TABLE deletes table from a database
Column names need to be mentioned for INSERT statetements
Column names need not be mentioned for INSERT statements
a special way of selecting data
the process of arranging information stored in a database in a way, which removes redundancy and ambiguity.
the process of adding primary key to a table
5) Which of the following statements gets the total value of the column ‘Price’ in the ‘Sales’ table?
SELECT SUM(Price) FROM Sales
SELECT SUM(Price) WHERE Sales
SELECT TOTAL(Price) FROM Sales
SELECT ADD(Price) FROM Sales
6) What are the data types you know in teradata?
Good Article. You can find some more SQL Interview Questions
plzz give ans key o above mcq