Oracle
1Z0-052 · Question #7
1Z0-052 Question #7: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #7. The question stem and answer options stay visible for context.
Managing Database Storage Structures
Question
Which two statements are true regarding the MRKT tablespace? (Choose two.) SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING 3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT; Database altered.
Options
- ANo more data files can be added to the tablespace.
- BSegment space is managed by free lists in the tablespace.
- CA user created without being assigned a default tablespace uses this tablespace.
- DThe tablespace can be dropped with the current setting with segments present in it.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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
#bigfile tablespace#default tablespace#segment space management#tablespace properties