You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?()
- AIt will create the tablespace TEMP1 in group G1
- BIt will create the tablespace TEMP1 in group G3
- CIt will not add the tablespace TEMP1 to any group
- DIt will create the tablespace TEMP1 in the default group
- EIt will throw an error with message 'specified group is not available
- FIt will create a new group with a system-generated name and add the tablespace TEMP1 to it.