Answer Posted / shail

Use function based index.
Ex: you have a date column and a simple index on it.
maximum queries referring to this column of this table
are like trunc(date_column). Then the index on this column
will be ignored. For this you can have function based index
like trunc(date_column) on this column.
This will speed up your sqls.

Which is the correct statement about truncate and delete?

1112

---

Enlist the advantages of sql.

1001

---

Is oracel sql developer written in java?

1108

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2500

---

What are keys in sql?

1000

---

What is pl sql script?

1035

---

Are stored procedures compiled?

926

---

Explain the types of joins in sql?

1035

---

What version is sql?

1035

---

What is dcl in sql?

961

---

Mention what plvcmt and plvrb does in pl/sql?

1143

---

How to avoid duplicate records in a query?

1008

---

What is the most restrictive isolation level? : Transact sql

1085

---

Does truncate free space?

1012

---

Does sql full backup truncate logs?

1017

---