Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1 int); Which statement is true?

Question

Options

• AThe temp table will be created in datadbs1.
• BThe temp table will be created in root dbspace.
• CThe temp table will be careated in one of the dbspaces listed in DBSPACTEMP.
• DThe temp table will be created round-robin across the dbspaces in DBSPACETEMP.

• A
  15% (5)
• B
  76% (25)
• C
  6% (2)
• D
  3% (1)

No community discussion yet for this question.