23. If a tablespace is made read-only, what can still be done to objects within

Question

23. If a tablespace is made read-only, what can still be done to objects within it?

A. Insertions into a table will work, as long as there is free space within the segment and so no new extents need to be allocated.

B. Operations that are transparent to applications and users (such as creating indexes) can be done in the tablespace, but no DML commands can be executed against tables within it.

C. Objects in the tablespace can be dropped but not created.

D. No SQL commands can be executed against any objects in a read-only tablespace except SELECT statements.

Explanation / Answer

Question:---- If a tablespace is made read-only, what can still be done to objects within it?

A. Insertions into a table will work, as long as there is free space within the segment and so no new extents need to be allocated.

B. Operations that are transparent to applications and users (such as creating indexes) can be done in the tablespace, but no DML commands can be executed against tables within it.

C. Objects in the tablespace can be dropped but not created.

D. No SQL commands can be executed against any objects in a read-only tablespace except SELECT statements.

Answer:---  C. Objects in the tablespace can be dropped but not created.

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.