A user issues a query on the sales table and receives the following error:
EROR at line 1:
Which two actions would you take to recover the temporary tablespace?
A. Drop the tenp01.dbf file, and then re-create the temp file.
B. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.
C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
E. Create a new temporary tablespace and assign it as the default to the user.
|
Download Printable PDF. VALID exam to help you PASS. |
 |