Tag: databases

Questions Related to databases

The right syntax insert a row into a table is
technology databases

  1. Insert to table tablename (….);

  2. Insert into table tablename (….);

  3. Insert into table tablename values (…..);

  4. Any one of the above

Show answer
Correct Option: C

Which is the function that records the current date?
technology databases

  1. Date

  2. Sysdate

  3. Current Date

  4. System Date

Show answer
Correct Option: B

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

FastExport does NOT support error files or error limits

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

  1. True

  2. False

Show answer
Correct Option: A

TPump does not allow Non-Unique Secondary Indexes

technology databases

  1. True

  2. False

Show answer
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.

technology databases

  1. Record Mode

  2. Field Mode

  3. DIF Mode

  4. Query Mode

Show answer
Correct Option: C

The .LOGOFF is optional in BTEQ

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Explain QUIT command in BTEQ.

technology databases

  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

Show answer
Correct Option: A