Answer Posted / sanjeev goud

Primary key - Primary key means main key
def:- A primary key is one which uniquely identifies a row
of a table. this key does not allow null values and also
does not allow duplicate values. for ex,
empno empname salary
1 sanjeev 35000
2 rakesh 34000
3 chintoo 40000

it will not the values as follows:
1 sanjeev 35000
1 rakesh 34000
chintoo 35000

Unique key - single and main key
A unique is one which uniquely identifies a row
of a table, but there is a difference like it will not
allow duplicate values and it will any number of allow
null values(In oracle).
it allows only a single null value(In sql server 2000)

Both will function in a similar way but a slight difference
will be there. So, decalaring it as a primary key is the
best one.

foreign key - a foreign key is one which will refer to a
primary key of another table

for ex,
emp_table dept_table
empno empname salary deptno deptno deptname

In the above relation, deptno is there in emp_table which
is a primary key of dept_table. that means, deptno is
refering the dept_table.

What is database bounce?

987

---

Explain the various types of normalization.

1013

---

What do you mean by database?

1024

---

5. Explain about relational algebra.

2115

---

What is the Lock Based Protocol used for?

1020

---

What is dialect in database?

930

---

how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

1989

---

What is the difference between a stored procedure and a query?

1035

---

Write a query to get maximum and second maximum in oracle?

995

---

What are the advantages of views in a database?

1106

---

Explain buffer manager?

895

---

What is Data Modelling?

1027

---

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

1068

---

HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

2381

---

What is table scan and index scan?

1069

---