Tag: databases

Questions Related to databases

FASTLOAD WORKS IN FIVE PHASES
technology databases

  1. True

  2. False

Show answer
Correct Option: B

HASH JOINS ARE FASTER THAN MERGE JOINS

technology databases

  1. True

  2. False

Show answer
Correct Option: A

______ IS USED TO STORE SUCCESSFUL CHECK POINTS DURING LOAD PROCESSING
technology databases

  1. WORK TABLE

  2. LOG TABLE

  3. UV TABLE

  4. ERROR TABLE

Show answer
Correct Option: B

MULTILOAD ALLOW NON UNIQUE SECONDARY INDEX
technology databases

  1. True

  2. False

Show answer
Correct Option: A

WHICH UTILITY IS USEFUL FOR REAL TIME APPLICATIONS

technology databases

  1. TPUMP

  2. FASTEXPORT

  3. BTEQ

  4. FASTLOAD

Show answer
Correct Option: A

DATA IS DISTRIBUTED BASED ON PARTITIONS IN A PPI TABLE
technology databases

  1. True

  2. False

Show answer
Correct Option: B

THE FINEST LEVEL OF GRANULARITY POSSIBLE IN TERADATA COMPRESSION IS

technology databases

  1. ROW LEVEL

  2. BLOCK LEVEL

  3. FIELD COMPRESSION

  4. COLUMN LEVEL

Show answer
Correct Option: A

Can you delete a column in table with data in Oracle?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Maximum number of columns in a table or view in Oracle?
technology databases

  1. 500

  2. 100

  3. 800

  4. 1000

Show answer
Correct Option: D

While doing an ascending order sort on a column having NULL values, where does the NULLs show up in the result set?
technology databases

  1. Last

  2. Beginning

  3. NULLs wont be displayed

  4. Cant say

Show answer
Correct Option: A