Oracle
1Z0-082 · Question #37
You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE `/u01/app/oracle/sales01.dbf SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace?…
The correct answer is D. It uses the database default blocksize E. It is a locally managed tablespace. See the full explanation below for the reasoning.
Manage Tablespaces and Datafiles
Question
You execute this command:
CREATE SMALLFILE TABLESPACE sales DATAFILE `/u01/app/oracle/sales01.dbf SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace? (Choose two.)
Options
- AIt must be smaller than the smallest BIGFILE tablespace
- BFree space is managed using freelists
- CAny data files added to the tablespace must have a size of 5 gigabytes
- DIt uses the database default blocksize
- EIt is a locally managed tablespace
How the community answered
(17 responses)- A12% (2)
- B6% (1)
- D82% (14)
Topics
#SMALLFILE tablespace#locally managed tablespace#SEGMENT SPACE MANAGEMENT AUTO#default blocksize
Community Discussion
No community discussion yet for this question.