Oracle
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: CREAT
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #65. The question stem and answer options stay visible for context.
Managing Storage
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.
Unlock 1Z0-034 to see the answer
You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#smallfile tablespace#locally managed tablespace#tablespace types#Oracle 10g defaults