Explain can a Tablespace hold objects from different Schemes?
Submitted by: AdministratorYes one tablespace can hold objects from different schemas.Eg. when we create any schema (user) than we can assign default tablespace like this for any user user we can use same tablespace.
Eg. SYSTEM tablespace in oracle database, which is used by all default users whos default tablespace are not mentioned. or
all user will user system tablepsace as default tablespace if their default tablespace is not mentioned at the time of user creation.
Submitted by: Administrator
Eg. SYSTEM tablespace in oracle database, which is used by all default users whos default tablespace are not mentioned. or
all user will user system tablepsace as default tablespace if their default tablespace is not mentioned at the time of user creation.
Submitted by: Administrator
Read Online Concepts and Architecture Job Interview Questions And Answers
Top Concepts and Architecture Questions
☺ | What is a Segment in Oracle? |
☺ | Explain can a Tablespace hold objects from different Schemes? |
☺ | Explain what is the function of Redo Log? |
☺ | What is Oracle Identity Analytics? |
☺ | Explain what is Public Database Link? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |