Answer Posted / irshad ahmad

Anomalies are problems that arise in the data due to a flaw
in the database design. There are three types of anomalies….
*Insertion Anomalies:Insertion anomalies occur when we
try to insert data into a flawed table.
*Deletion Anomalies:- Deletion anomalies occur when we
delete data from a flawed schema.
*Update Anomalies:- Update anomalies occur when we
change data in a flawed schema.

What are the various ways to execute a query in teradata?

2543

---

What is odm database?

939

---

How to shrink a database?

927

---

What are the advantages of views in a database?

1101

---

Can a database table exist without a primary key?

888

---

What is a reference table in database?

975

---

What is the candidate key used for?

1034

---

What is the concept of Virtual field?

2005

---

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

2057

---

What is the role of driver manager?

968

---

How concurrency problems effect the database?

1091

---

What is a Transformation?

969

---

Give the syntax of exception handling used in DBMS?

1142

---

Differentiate between unique key and foreign key?

953

---

if i want to display the name of students such that to which city they belong must have count greaer than two

2167

---