Answer Posted / firoz basha

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 firoz 35000
2 basha 34000
3 chintoo 40000

it will not the values as follows:
1 firoz 35000
1 basha 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 are different types of blocks used in stored procedure?

1177

---

What is a database string?

996

---

Explain alternate key?

1128

---

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

2305

---

Give the syntax of exception handling used in DBMS?

1239

---

What does currency type mean in database?

1249

---

When should you not use firebase?

1108

---

On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

1041

---

Explain artificial key?

1215

---

How do you pass parameter in stored procedure?

1249

---

wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

3172

---

Explain entity ?

1080

---

Why do we need distributed database?

1043

---

Is it good to store images in database?

1051

---

what is transaction state, buffer management, shadow paging

3514

---