Exam4Training

Which statement is true?

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?
A . The temp table will be created in datadbs1.
B . The temp table will be created in root dbspace.
C . The temp table will be careated in one of the dbspaces listed in DBSPACTEM
E . The temp table will be created round-robin across the dbspaces in DBSPACETEM

Answer: B

Exit mobile version