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

The MultiLoad DELETE mode is used to perform a global (all AMP) delete on just one table.

  1. True

  2. False


Correct Option: A

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
  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
  1. Numeric data

  2. Data type

  3. Char data

  4. None of the Above


Correct Option: A

Delete from Employee where grade = ‘Y’” deletes

  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