Answer Posted / abhinaw kaushik

Normalization is the process of braking down one table into
more than one tables so that data redudancy can be removed.
There are some rules to perform Normalization are called
Normal Forms.

What happens if you lost a data file?

1034

---

How to create a table in a specific tablespace?

976

---

Explain the importance of .pll extension in oracle?

1011

---

How to write date and time interval literals in oracle?

1034

---

How to use subqueries with the exists operator in oracle?

1027

---

How to concatenate two text values in oracle?

1113

---

What to do if the binary spfile is wrong for the default instance?

1069

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1110

---

How to install oracle odbc drivers?

1093

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

---

What types of joins are used in writing subqueries?

982

---

how to join query for one source type is oracle another source type is sql server ?

2425

---

Why do we need integrity constraints in a database?

1020

---

How to count duplicated values in a column in oracle?

1039

---

What are the ways tablespaces can be managed and how do they differ?

2367

---