What is database transaction?

0 Answers  

---

Explain the terms specialization and generalization.

0 Answers  

---

If I delete a table and then rollback it, do the index on the table remains? What if I drop the table and roll back?Do index on the table remains? What if I truncate the table and roll back? Do the index on the table remains

2 Answers   Wipro,

---

What is the difference between indexes,views,synonyms?

0 Answers   HCL,

---

Can you export a table along with partition?

1 Answers  

---

---

Differentiate between nested loop, hash loop and merge join.

0 Answers  

---

What is 1nf in the dbms?

0 Answers  

---

when All datafiles related to a Tablespace are removed ?

0 Answers  

---

Define database lock and its types.

0 Answers  

---

Why is group-clause used?

0 Answers  

---

What is 2nf in dbms?

0 Answers  

---

What is data management process?

0 Answers  

---