1Z0-034 · Question #65
You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs…
The correct answer is A. It is a smallfile tablespace. D. It is a locally managed tablespace. Specify either SET DEFAULT BIGFILE TABLESPACE or SET DEFAULT SMALLFILE TABLESPACE. If you omit this clause, the default is a smallfile tablespace, which is the traditional type of Oracle Database tablespace. SELECT tablespace_name, extent_management, bigfile FROM…
Question
You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M; Which two statements are correct regarding the mytbs tablespace? (Choose two)
Options
- AIt is a smallfile tablespace.
- BIt is a bigfile tablespace (BFT).
- CIt is a default bigfile tablespace.
- DIt is a locally managed tablespace.
- EIt is a dictionary-managed tablespace.
How the community answered
(43 responses)- A74% (32)
- B7% (3)
- C5% (2)
- E14% (6)
Explanation
Specify either SET DEFAULT BIGFILE TABLESPACE or SET DEFAULT SMALLFILE TABLESPACE. If you omit this clause, the default is a smallfile tablespace, which is the traditional type of Oracle Database tablespace. SELECT tablespace_name, extent_management, bigfile FROM dba_tablespaces WHERE tablespace_name = 'MYTHBS'; TABLESPACE_NAME EXTENT_MANAGEMENT BIGFILE
Topics
Community Discussion
No community discussion yet for this question.