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.

Explain transaction manager?

1087

---

What is the purpose of TNS?

1034

---

How much does it cost to build a database?

1032

---

Explain database partitioning. What is its importance?

1203

---

Does facebook use graph database?

1037

---

How many types of locks are present in a database?

1134

---

Define stored procedure?

1029

---

Under which circumstance should you create an index on a table?

1167

---

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

1617

---

Explain entity ?

1036

---

List some advantages of dbms.

1133

---

Which database is best to store images?

1047

---

Is database a hardware or software?

1003

---

Is it good to store images in database?

1003

---

What are different types of blocks used in stored procedure?

1135

---