Answer / Amardeep Singh

"Executive Plan, in the context of database management systems, refers to a detailed plan that outlines how a query will be executed. It includes steps like accessing tables, applying joins and filters, sorting data, and executing aggregation functions."

Explain armstrong rules? How they are complete and/or sound?

1 Answers  

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

2 Answers  

---

What is the difference between a shared lock and exclusive lock?

1 Answers  

---

What are the benefits of database management system?

1 Answers  

---

What is delimiter in dbms?

1 Answers  

---

Explain ddl interpreter?

1 Answers  

---

Can you copy the PROGRAM UNIT into an Object group ?

1 Answers  

---

What is use of LOG (Ver 7) option in EXP command ?

1 Answers  

---

What are the different stages in 'data warehousing'?

1 Answers  

---

What are notification services?

1 Answers  

---

What are the characteristics of dbms?

1 Answers  

---

What is cursor and where do you use them?

2 Answers   eBay,

---