If a tablespace is made read-only, what can still be done to objects within it?
ID: 3706335 • Letter: I
Question
If a tablespace is made read-only, what can still be done to objects within it? Please Explain
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
Answer)
If a tablespace is made read-only then
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. - False, Insertions would not be allowed into the tablespace or table. No DML statements are also allowed to execute to make changes after a tablespace is read-only.
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. - False, Firstly you cannot execute any DML statements, you cannot create indexes also but can only drop items such as tables or indexes.
C. Objects in the tablespace can be dropped but not created. - This is True as Objects in the tablespace can be dropped but not created. You can drop the items such as tables or indexes but cannot create new ones in the tablespace.
D. No SQL commands can be executed against any objects in a read-only tablespace except SELECT statements. - False, as other than SELECT statements you can execute, alter table statements to update the file description in data dictionary, drop commands to drop tables from the tablespace.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.