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

FastExport does NOT support error files or error limits

  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

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

  1. True

  2. False


Correct Option: A

TPump does not allow Non-Unique Secondary Indexes

  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

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

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 Group functions in the WHERE clause

  1. True

  2. False


Correct Option: B

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

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

Which keyword used in DML statements prohibits you from changing rows that are not in the sub-query?

  1. CHECK keyword

  2. WITH CHECK keyword

  3. WITH CHECK OPTION keyword

  4. None of the Above


Correct Option: C
- Hide questions