Answer Posted / sonal singhal

Candidate keys-> A candidate key is a combination of
attributes that can be uniquely used to identify a database
record without any extraneous data. Each table may have one
or more candidate keys. One of these candidate keys is
selected as the table primary key.

Alternate keys-> Alternate Key or Unique Key is similar to
PK ,except it accepts null Values .So that the records can
still be entered submitting null values to this attribute.

Composite keys-> compound key (also called a composite key
or concatenated key) is a key that consists of 2 or more
attributes.
A composite Key can be either Primay or Unique
Key.More then One Key columns are said to be composite keys

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2421

---

What is data modeling with example?

1000

---

Explain about the relational database?

1074

---

Explain about xml databases?

1075

---

explain detail about ftp in datastage?

2244

---

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2218

---

What is normalization? Explain different levels of normalization?

63116

---

Write the fastest query to find out how many rows exist in a table?

1119

---

What are the key features of dbms?

996

---

How you can make a parameterized view?

1012

---

fact table and dimension table containg one to many relationship or many to one relastionship

2497

---

Can an extended stored procedure be called from inside a user-defined function?

1055

---

State the acid rules?

1134

---

Write short notes on manual refreshes.

2734

---

What is an application role and explain a scenario when you would use one?

1012

---