Answer Posted / manumole

Candidate key:

Candidate keys for a table includes the set of columns
which satisfies the criteria of a primary key.

Primary key : a column/combination of columns which
uniquely identifies a row and whose values are not null.

Clustered Key:when a combination of columns becomes a
primary key it is called as clustered key.

Alternate keys:the set of columns which is avialble in the
candidate keys and are not selected as primary key.

Eg:Customer table
candidate keys:{ CustomerID, MobNo(defined as not null) }

primary key: if Db designer selected as CustomerID,then
Alternate key is MobNo
Clustered key:if both combination CustomerID- MobNo is
taken as primary key,it is nothing but a clustered key

How long can an error message be in raiseerror function?

1045

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

1020

---

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 detail about ftp in datastage?

2293

---

Explain the role of indexing in databases?

1187

---

What is the database development process?

1266

---

Which four data types cannot be used as a return type from a user-defined function?

1063

---

Who are end users in dbms?

1035

---

How to use online Backups?

2259

---

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?

1051

---

Explain about relational operator join?

1095

---

State the acid rules?

1181

---

How to generate OIDS

2330

---

How to combine two function together?

2202

---

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

1056

---