Un-Answered Questions { Oracle General }

What is system tablespace?

624


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?

518


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

594


What is a snapshot log?

557


Can objects of the same schema reside in different tablespace?

580


How index is implemented in oracle database?

586


How are extents allocated to a segment?

571


What are the attributes of cursor?

583


What are set operators?

643


What is blob datatype?

566


What are a cluster and non-cluster index?

572


How do we create privileges in oracle?

580


State and explain about oracle instance?

538


What is the data type of dual table?

518


What is using clause and give example?

579