Can objects of the same schema reside in different tablespace?
- 1 Answers
- 1140 Views
- I also Faced
- E-Mail Answers
Answer / Mahendra Anand
Yes, objects of the same schema can reside in different tablespaces. This is useful for data segmentation, storage optimization, and backup/recovery management. For example, you can store large objects (LOBs) in a separate tablespace to save space in the system tablespace.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the implicit cursor in oracle?
How does Oracle guarantee data integrity of data changes?
Is it possible to split the print reviewer into more than one region ?
What is meant by raw datatype?
What is an Oracle view?
What is a proxy class?
What is oracle rownum?
Explain mutating triggers.
What are the attributes of cursor?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
what is the syntax of DELETE command?
What are the original export and import utilities?
Oracle General 
