Answer / orawhiz

A Private Synonyms can be accessed only by the owner.

Explain the difference between sap and oracle?

0 Answers  

---

Is oracle a language?

0 Answers  

---

How many types of tables supported by oracle?

0 Answers  

---

Explain joins in oracle?

0 Answers  

---

What is the difference between SQL, DDL, and DML?

7 Answers   BeBo Technologies, Wipro,

---

---

What are various constraints used in SQL?

1 Answers   Polaris,

---

Difference between NO DATA FOUND and %NOTFOUND?

1 Answers  

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

if you update view? where we store the data?

5 Answers   Cap Gemini,

---

What are Clusters ?

5 Answers   Amdocs, Infosys,

---

What is the difference between $oracle_base and $oracle_home?

0 Answers  

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

0 Answers   TCS,

---