Answer Posted / nusret sevinc

A primary index is an index on a set of fields that includes
the unique primary
key for the field and is guaranteed not to contain
duplicates. A secondary index
is an index that is not a primary index and may have
duplicates. Two entries are
said to be duplicates if they have the same value for the
search key field associated
with the index.

What is the physical representation for a many-to-many relationship?

1134

---

Explain the cube operator?

1059

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

1048

---

In which database can extended stored procedures be added?

950

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2902

---

Explain about relational operator join?

1095

---

Why does this query return 0?

1054

---

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).

2277

---

How you can make a parameterized view?

1069

---

What are the 18 schemas?

1186

---

How to use online Backups?

2257

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1051

---

State the acid rules?

1179

---

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?

2468

---

How can I detect whether a given connection is blocked?

1117

---