What is columnar storage what is the advantage?

0 Answers  

---

how to create a new database in oracle?

6 Answers   TCS,

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

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,

---

What is a sub query and what are the different types of subqueries?

0 Answers  

---

---

How to create a testing table in oracle?

0 Answers  

---

Is it possible to insert comments into sql statements return in the data model editor ?

0 Answers   Oracle,

---

how many triggers we can create on a table

11 Answers   G2 Technology, TCS,

---

State the various uses of dbcc command?

0 Answers  

---

Describe an oracle table?

0 Answers  

---

can u plz provide me oca sql dumps please i need them

0 Answers  

---

What do you understand by a database object?

0 Answers  

---