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
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments