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?
1109Post New Oracle General Questions
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What do you mean by group by clause?
Why do you use stored procedures and state some of its disadvantages?
How to drop an index in oracle?
What are the uses of Database Trigger ?
What is Redo Log Buffer in Oracle?
What is a read only transaction in oracle?
What is the quickest way to fetch the data from a table?
What is truncate oracle?
What is an external table?
How to create a new table by selecting rows from another table?
Why we use bulk collect in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to use "in out" parameter properly?