1) WIll all the user get the DEFAULT profile, if their
current profile got deleted at any point of time?
2) What are the Situation we need to MOVE the TABLE between
T.spaces?
3) What is the use of MOVING the TABLE between SCHEMA'S?
4) What are the Table Clause, Segment Clause and the
Datafile Clause which will override each other?
5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
No Answer is Posted For this Question
Be the First to Post Answer
Explain a private synonyms?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
What is the maximum number of CHECK constraints that can be defined on a column ?
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
How to assign values to data fields in record variables?
What do you mean by a deadlock?
What are dml statements in oracle?
How many types of auditing in Oracle?
How to create a new tablespace in oracle?
Can we protect our pl/sql source code?