Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4813 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
The OPTIMIZER_MODE initialization parameter Statistics in the
Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER
SESSION command hints in the statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nishi
This value causes the optimizer to the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with a goal of best throughput.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between a vector and an Array? (Java)
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
What are the different oracle database objects?
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
20. Using a set operator, display the client number of all clients who have never placed an order.
Can we call procedure inside function in oracle?
How can we force the database to use the user specified rollback segment?
What do you understand by database schema and what does it hold?
6. Display the client name and order date for all orders using the traditional method.
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
Explain drop constraint oracle?
what is trigger?
Oracle General 
