1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

1 Answers   Polaris,

---

Can a Tablespace hold objects from different Schemes ?

3 Answers  

---

What are the Characteristics of Data Files ?

3 Answers  

---

How many types of tables supported by oracle?

0 Answers  

---

 How to use an oracle sequence generator in a mapping?

0 Answers   Informatica,

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

0 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

What are the different types of synonyms?

0 Answers  

---

What is enter substitution variable in oracle?

0 Answers  

---

How can we find the size of a database?

2 Answers  

---

How to write date and time literals in oracle?

0 Answers  

---