0

databases Online Quiz - 158

Description: databases Online Quiz - 158
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

If BTEQ terminates abnormally, all rows (which are in SPOOL) are discarded

  1. True

  2. False


Correct Option: A

More than one data type conversion is allowed per column during a FastLoad

  1. True

  2. False


Correct Option: B

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.

  1. Record Mode

  2. Field Mode

  3. DIF Mode

  4. Query Mode


Correct Option: C

The .LOGOFF is optional in BTEQ

  1. True

  2. False


Correct Option: A

Explain QUIT command in BTEQ.

  1. End the current session or sessions and exit BTEQ

  2. End the current session or sessions, but do not exit BTEQ

  3. Immediately end the current session or sessions and exit BTEQ

  4. Abort any and all active running requests and transactions and EXIT BTEQ


Correct Option: A

You can over-ride the standard error codes at the time you terminate BTEQ

  1. True

  2. False


Correct Option: A

BTEQ can be used to submit SQL in a batch environment only

  1. True

  2. False


Correct Option: B

FastExport can also export from multiple tables during a single operation

  1. True

  2. False


Correct Option: A

Below DML Commands supported within the FastExport task

  1. Delete

  2. Select

  3. Update

  4. Insert


Correct Option: B

Which of the below command defines the client file that provides the USING data values for the SELECT statement

  1. Import

  2. Accept

  3. Layout

  4. Export


Correct Option: A

All Fastexport Commans should start with a period ( . ) character

  1. True

  2. False


Correct Option: A

The default value for SLEEP command in Fastexprot is

  1. 6

  2. 9

  3. 5

  4. 10


Correct Option: A

We can use MIN and MAX for any

  1. Numeric data

  2. Data type

  3. Char data

  4. None of the Above


Correct Option: A

You can update more than 1 row in a table with one update syntax

  1. True

  2. False


Correct Option: B
  1. All rows of the Employee table

  2. Rows of the Employee table where the set grade is ‘Y’

  3. Delete 1 row

  4. Nothing will be deleted


Correct Option: B
  1. CHECK keyword

  2. WITH CHECK keyword

  3. WITH CHECK OPTION keyword

  4. None of the Above


Correct Option: C
- Hide questions