Answer / 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.

Answer / priya reddy

primary key- if a column is declared as priamry then there
wont be any repeated values in that column throughout that
table, as well as it wont take any null values and we can
use primary key only once in a table. but we can declare
combination of two columns as primary key.
unique- if a column is declared as unique then again there
wont be any repeated values in that column, but this will
take null values and even we can declare more thatn one
unique column in a table.
foreign key-if a column is declared with this key then we
have to use a reference ie we need to give the column which
will have the same values as this column and the table that
column belongs to.. this referced column of other table
will be the primary key of that table.

Answer / kranthi

primary key: primary creates a clustered index on the
column and it doesn't allow null values.

unique key: unique key creates non clustered index by
default.it allows "one null value".

foreign key: A foreign key (FK) is a column or combination
of columns used to establish and enforce a link between the
data in two tables

Answer / pinna

primary key is that key that can uniquenly identify the
values

Answer / nitin bisht

PRIMARY KEY: A tabLe can aontain only one PRIMARY KEY. It
Doesn't allow null values, it is used as Foreign Key In
Another Table(like Reference Key).

UNIQUE KEY: A Table may Contain one or more UNIQUE
constraints. Its aloow only one null value . Use this key We
maintain unique vales in the table.

FOREIGN KEY: A key used in one table to represent the value
of a primary key in a related table. While primary keys must
contain unique values, foreign keys may have duplicates. For
instance, if we use student ID as the primary key in a
Students table (each student has a unique ID), we could use
student ID as a foreign key in a Courses table: as each
student may do more than one course, the student ID field in
the Courses table (often shortened to Courses.student ID)
will hold duplicate values.

Answer / ganesan s

a key which is uniquely identified by a record is called
primary key.

Answer / doraswamy

One table allows only one primary key but there is no
restriction for unique keys.
These two are same but one difference is unique key will
allow nulls.
Primary key create on a combination of mulitiple colums.

Foreign key is reference of another table primiary key. It
will not allow null values.

~Doraswamy

Answer / kiran chandra sarkar

PRIMARY KEY: A table can contain only one PRIMARY KEY. It
doesn’t allow null values; it is used as Foreign Key in
another Table (like Reference Key).

UNIQUE KEY: A Table may contain one or more UNIQUE
constraints. It’s allowing only one null value. Use this
key we maintain unique vales in the table.

FOREIGN KEY: A key used in one table to represent the value
of a primary key in a related table. While primary keys
must contain unique values, foreign keys may have
duplicates. For instance, if we use student ID as the
primary key in a Students table (each student has a unique
ID), we could use student ID as a foreign key in a Courses
table: as each student may do more than one course, the
student ID field in the Courses table (often shortened to
Courses. student ID) Will hold duplicate values.

Answer / nizamuddin

primery key is unique not null.
in a table only one primery key

Answer / heena verma

Primary Key:- it is a contraint(checks) provided by DBMS.
if we want to make a coumn unique and not null then the
column is defined as primary key. it is used to create
relations among the tables.

Explain the table term used in database.

0 Answers  

write a query for the fifth highest salary?

17 Answers   IBM, Matlabs, Ramco,

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

0 Answers   Wipro,

Explain alternate key?

0 Answers  

characters of DBMS A) non redundant B) data independence C) increased security D) all the above

1 Answers   Accenture, XP,

What is the difference between database and server?

0 Answers  

What are the three types of anomalies in database and Explain?

9 Answers  

Explain normalization in one line?

0 Answers   C DAC, CDAC,

What is ole db used for?

0 Answers  

What is ole db ado?

0 Answers  

After normalization, what are the conditions which have to keep in mind to de-normalize it?

0 Answers   C DAC, CDAC,

What the various ways to tune a teradata query

0 Answers