Answer Posted / teju

PRIMARY KEY :
IN THE TABLE we can find only one record as
uniqely & also it is not null.

unique key:
uk is to search any record as uniquely& when it
is declared it should be only one null values.

Fk:
fk is to maintain the relations bet two tables
as an duplicate values.means to not null.
e.g
1> stud(stud_id,stud_name);
2> stud_det(stud_id,addr);
In this table stud_id is an pk & In the stud_det as
stud_id is used as an duplicate.

how can we view column head in first page but not in remaining pages?

1989

---

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

2172

---

What is the purpose of firebase?

932

---

What is a database string?

898

---

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

2501

---

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

1067

---

what is the role of auditor in auditing data oriented applications?

2335

---

What do you mean by cluster and non cluster index?

1032

---

What is database client?

959

---

What are the advantages of normalizing a database.

1002

---

what is the full procedure for using store procedure in informatica7.1?

2205

---

A lowest level of security by most RDBMS is

1096

---

What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?

1951

---

Give the syntax of exception handling used in DBMS?

1146

---

What is the difference between database and server?

943

---