Mention the different types of cursor?

0 Answers  

---

Define the following terms 19. (i) Database 20. (ii) Database Management System 21. (iii) Data Model 22. (iv) Scheme 23. (v) Data independence

1 Answers  

---

Explain the concepts of a primary key and foreign key.

0 Answers  

---

How to prevent concurrent access to my data?

0 Answers   HCL,

---

Explain the concept of acid properties in dbms?

0 Answers  

---

---

From which command ENQUEUE_RESOURCES parameter information is derived from ?

1 Answers  

---

Differentiate between nested loop, hash loop and merge join.

0 Answers  

---

What is database connection pool size?

0 Answers  

---

Define identity and uniqueidentifier property of column?

0 Answers  

---

What is the use of RECORD option in EXP command ?

1 Answers  

---

How does notification services work?

0 Answers  

---

Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.

0 Answers  

---