Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 Answers  

---

types of indexes and the rationale behind choosing a particular index for a situation.

0 Answers  

---

Can a formula column be obtained through a select statement ?

0 Answers   Oracle,

---

Use of an integrity constraint is better to validate data. Explain

0 Answers  

---

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

2 Answers   MasterCard,

---

---

State all possible different index configurations a table can possibly have?

0 Answers  

---

What are the types of Database Links ?

2 Answers  

---

how to find count rows in table without count function?

3 Answers   Oracle,

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

4 Answers   Infosys,

---

What is transport network substrate (tns) in oracle?

0 Answers  

---

what is shell?

2 Answers   Microsoft,

---