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 the difference between primary and candidate key?

1134

---

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

1093

---

What is ole db source in ssis?

1003

---

What happens when shared and exclusive locks are applied on data item?

1039

---

Define stored procedure?

1029

---

Explain database partitioning.

1081

---

What is the DIF format and when we will use in teradata

2496

---

What is the importance of database partitioning?

1062

---

What is dialect in database?

980

---

What are the most common databases?

973

---

Give the syntax of exception handling used in DBMS?

1199

---

Display the employees whose salary is less than average salary.

1066

---

Explain the field term used in database.

979

---

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

1231

---

List some advantages of dbms.

1133

---