databases Online Quiz - 158
|Description: databases Online Quiz - 158|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
The MultiLoad DELETE mode is used to perform a global (all AMP) delete on just one table.
There are four export formats that a user can choose depending on the desired output in BTEQ EXPORT function. Three of them are Data mode, Report Mode and Indicator Mode. Choose the fourth one.
The .LOGOFF is optional in BTEQ
You can over-ride the standard error codes at the time you terminate BTEQ
BTEQ can be used to submit SQL in a batch environment only
FastExport can also export from multiple tables during a single operation
Delete from Employee where grade = ‘Y’” deletes