Does normalization improve performance?

0 Answers  

---

What is row_number () in sql?

0 Answers  

---

What are character functions?

0 Answers  

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,

---

What is a trigger in sql?

0 Answers  

---

What is on delete restrict?

0 Answers  

---

How do you declare a user-defined exception?

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

What is a primary key, and how is it different from a unique key?

3 Answers  

---

what is meant by DML?

5 Answers   HCL,

---

Is json a nosql?

0 Answers  

---