Teradata Question:

Download Job Interview Questions and Answers PDF

What is stored procedure in Teradata?

Teradata Interview Question
Teradata Interview Question

Answer:

A stored procedure is a group of SQL statements that form a logical unit and perform a particular task. Stored procedures are used to encapsulate a set of operations or queries to execute on a database server. For example, operations on an employee database (hire, fire, promote, lookup) could be coded as stored procedures executed by application code. Stored procedures can be compiled and executed with different parameters and results, and they may have any combination of input, output, and input/output parameters.

Download Teradata Interview Questions And Answers PDF

Previous QuestionNext Question
Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.What is Group by in Select statement?