Answer Posted / arul

Schema is structure of DataBase

How many types of synonyms in Oracle?

1134

---

What is the usage of analyze command in oracle?

1100

---

What does sharding mean?

1010

---

Is a rollback possible to any savepoint?

1104

---

What is where clause in oracle?

1039

---

What is the usage of merge statement?

1156

---

how do u setup a replication site?

1994

---

what is the difference between functional dependecy and multilevel dependency?

2469

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2215

---

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.

2100

---

How to use attributes of the implicit cursor in oracle?

1014

---

What is a partition in oracle?

1129

---

Can we write dml statement in function in oracle?

1091

---

How to rename an index?

1078

---

What is not equal to in oracle?

1006

---