Answer Posted / jasmine

Normalization is a process of designing the table(relation)
with the reduced redundancy and making clear whether the
attributes in a table is depend on the primary key or
dependencies make sense(ie:storing only the related datas
ito the table). This is achieved by normal forms.
Basic types of normal forms are,
1NF-first normal form(Eliminates duplicate or
repeating values)

2NF-second normal form(Eliminates redundant datas in
one or more tables)

3NF-Third normal form(Removing the columns that are
not truely depending on the primary key)

Differentiate between syntax and runtime errors.

1119

---

How does sql developer connect to oracle database?

950

---

When is the update_statistics command used?

1049

---

What's the difference between a primary key and a clustered index?

947

---

What is a table in a database?

993

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1003

---

What is parallel hint?

1223

---

What are the properties of a transaction?

1072

---

can sql servers linked to other servers like oracle? : Sql dba

956

---

What are the advantages of pl sql over sql?

963

---

What is embedded sql in db2?

962

---

What are the types of operators available in sql?

1011

---

How many parts of a pl sql block are optional?

1035

---

What is the process of copying data from table a to table b?

1036

---

What is auto increment feature in sql?

1068

---