Answer Posted / brajendra arzare

Deletes perform normal DML. That is, they take locks on
rows, they generate redo and they require segments in the
UNDO tablespace. Deletes clear records out of blocks
carefully. If a mistake is made a rollback can be issued to
restore the records prior to a commit.
Truncates are DDL and truncate moves the High Water Mark
of the table back to zero. No row-level locks are taken, no
redo or rollback is generated.so they have the same effect
as a delete, but without all the overhead. Just one slight
problem: a truncate is a DDL command, so you can't roll it
back if you decide you made a mistake. (It's also true that
you can't selectively truncate -no "WHERE" clause is
permitted, unlike with deletes, of course).

Which is faster joins or subqueries?

986

---

What is oracle pl sql developer?

978

---

What is the primary use of normalization?

1000

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1222

---

What are aggregate and scalar functions?

1014

---

Mention what is the use of function "module procedure" in pl/sql?

1047

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1144

---

What are the types of keys?

989

---

What is difference between db2 and sql?

997

---

Explain what is sql*plus?

1138

---

what is data integrity? : Sql dba

1034

---

What is difference between rank () row_number () and dense_rank () in sql?

1097

---

Is drop table faster than truncate?

985

---

How many columns should be in an index?

959

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1579

---