Tag: databases

Questions Related to databases

All Fastload commands should start with period(.) character
technology databases

  1. True

  2. False

Show answer
Correct Option: B

The support tables are created in which phase of Multiload
technology databases

  1. Acquisition

  2. Transaction

  3. Application

  4. Preliminary

Show answer
Correct Option: D

IGNORE DUPLICATE ROWS does not apply if there are any unique indexes in the table.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

The DELETE with a WHERE clause starts a period(.) in MLOAD
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the below table is essentail when restarting a Mload Script
technology databases

  1. Error Table

  2. UV Table

  3. Work Table

  4. Log Tbale

Show answer
Correct Option: D

Select the DDL statements suppoerted by Mload
technology databases

  1. Drop

  2. Create

  3. Alter

  4. Rename

Show answer
Correct Option: A

In a join condition it is mandatory to specify the table name along with the Column name.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

An outer join is used to:
technology databases

  1. Return records which have no direct match

  2. Return records which have direct match

  3. Return all the records

  4. None of the above

Show answer
Correct Option: A

____________ is the outer join operator.

technology databases

  1. (+)

  2. (-)

  3. (*)

  4. +

Show answer
Correct Option: A

____________ is used to join a table to itself.
technology databases

  1. Selfjoin

  2. Outerjoin

  3. innerjoin

  4. equijoin

Show answer
Correct Option: A