What is database normalization? Explain types of it.

0 Answers  

---

what the REPLACE('JACK AND JUE','J','BL') will return ?

1 Answers   HCL, IBM, Wipro,

---

describe and contrast a trigger and a procedure.

0 Answers  

---

What is a relation in dbms?

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  

---

---

How to detect applications and users that hold transactions open too long?

0 Answers  

---

Dept wise avrage salary

2 Answers   HCL, IBM, TCS,

---

I have a table which has lot of inserts, is it a good database design to create indexes on that table?

0 Answers  

---

Difference between data and information, and how are they related in a database?

0 Answers   Huawei,

---

What's the difference between star and snow flake schema?

0 Answers  

---

Explain vdl (view definition language)?

0 Answers  

---

Define sub-query.

0 Answers  

---