Answer Posted / srabani das

The basic facts of normalization is to reduced redundancy
which means that information stored only once.storing the
information in several times leads to lost of storage space
and increase in total size of data base.Relation are
normalized so that when relation of database are to be alter
during the life time of the data base. we do not lost
information.

What does select * from mean in sql?

3337

---

what are the limitations of identity column? : Transact sql

1163

---

What is scalar data type in pl sql?

1119

---

How do you delete a table?

1124

---

What is difference between rank () row_number () and dense_rank () in sql?

1164

---

Does truncate free space?

1065

---

Explain the methods used to protect source code of pl/sql.

1074

---

What is trigger in sql? Explain

1044

---

How do you declare a user-defined exception?

1078

---

How to add new employee details in an employee_details table with the following details

1137

---

what are date and time intervals? : Sql dba

1105

---

What is varchar used for?

1139

---

What is rename in sql?

1019

---

What is blind sql injection?

1169

---

how to shutdown mysql server? : Sql dba

1148

---