Answer Posted / vipul.solanki

Index is use for the performance to retrieve data from table.
1 . index automatically created when create PK or UK
2 . Explicitly create index

there is three type of index

1.unique index
2.cluster index
3.non-cluster index

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1896

---

How to write date and time interval literals in oracle?

1028

---

What is an external table?

1012

---

How to handle a single quote in oracle sql?

1041

---

Can you assign multiple query result rows to a variable?

984

---

What is a data lock in oracle?

1101

---

Why do you create or replace procedures rather that drop and recreate.

1002

---

How to apply filtering criteria at group level in oracle?

1036

---

What is the usage of analyze command in oracle?

1089

---

Explain integrity constraint?

1157

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1995

---

How data locks are respected in oracle?

1062

---

Explain database link?

1105

---

Explain the use of inctype option in exp command.

1027

---

Respected sir, Please send me technical questions related to oracle apps..

1808

---