what is the scenario where you take the database to NoArchivelog mode?

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,

---

hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..

1 Answers  

---

State some uses of redo log files?

0 Answers  

---

Why do we need integrity constraints in a database?

0 Answers  

---

What is a trigger oracle?

0 Answers  

---

What is the maximum number of CHECK constraints that can be defined on a column ?

3 Answers  

---

How to create a new oracle data file?

0 Answers  

---

what is difference between DBMS and RDBMS?

2 Answers   Metric Stream,

---

Differentiate between pre-select and pre-query?

0 Answers  

---

i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?

5 Answers   Oracle,

---

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---