Un-Answered Questions { Oracle General }

What is system tablespace?

632


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

524


How does one get the view definition of fixed views/tables?

606


What is a snapshot log?

564


Can objects of the same schema reside in different tablespace?

590


How index is implemented in oracle database?

596


How are extents allocated to a segment?

580


What are the attributes of cursor?

589


What are set operators?

646


What is blob datatype?

569


What are a cluster and non-cluster index?

576


How do we create privileges in oracle?

588


State and explain about oracle instance?

551


What is the data type of dual table?

529


What is using clause and give example?

588