Interested to Buy Any Domain ? << Click Here >> for more details...
Can objects of the same Schema reside in different tablespaces.?
- 3 Answers
- 9243 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aditya
Yes. I think answer is correct.
It is something like this
we can group tables in a schema. Imagine there is employee
schema which contains tables empDetails empSalary deatils
and we have another schema named clientDetails which
conatins table cleintNmaes.
Now this tables are logically seperated by schema.User
belonging to empoyee schema cannot acess cleintDetails
schema and vice versa ( untill we grant them).
TableSpace can be consideres as partiotns (similar in
windows) where we can store data of different tables
belonging to different schemas.In our example all the
tables belonging to employye and cleintdetails can stay in
same tablespace (say AllData tablespace).
HOpe this answer helps :)
| Is This Answer Correct ? | 6 Yes | 0 No |
Explain oracle’s server parameter file.
How to bring a tablespace offline?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
How to display employee records who gets more salary than the average salary in the department?
What is TNS File
What are the various constraints used in oracle?
What are the ansi data types supported in oracle?
Explain an integrity constrains?
What are the types of trigger in oracle?
how to find out second largest value in the table
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
Oracle General 
