databases Online Quiz - 158
Description: databases Online Quiz - 158 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
If BTEQ terminates abnormally, all rows (which are in SPOOL) are discarded
More than one data type conversion is allowed per column during a FastLoad
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
Explain QUIT command 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
Below DML Commands supported within the FastExport task
Which of the below command defines the client file that provides the USING data values for the SELECT statement
All Fastexport Commans should start with a period ( . ) character
The default value for SLEEP command in Fastexprot is
We can use MIN and MAX for any
You can update more than 1 row in a table with one update syntax