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

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
  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

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

  1. True

  2. False


Correct Option: B
  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