Exam 1z0-034 topic 1 question 120 discussion

Actual exam question from Oracle's 1z0-034

Question #: 120
Topic #: 1

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)

A. It is a smallfile tablespace.
B. It is a bigfile tablespace (BFT).
C. It is a default bigfile tablespace.
D. It is a locally managed tablespace.
E. It is a dictionary-managed tablespace.

Show Suggested Answer

Suggested Answer: AD 🗳️
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.
Verify also:
SELECT tablespace_name, extent_management, bigfile

FROM dba_tablespaces -
WHERE tablespace_name = 'MYTHBS';
TABLESPACE_NAME EXTENT_MANAGEMENT BIGFILE
MYTHBS LOCAL NO

by thuthuysphn58 at April 4, 2025, 6:51 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!