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.

What does new grouping sets enables you to do?

0 Answers   ADITI,

What is the main difference b/w Teradata and Oracle?

1 Answers   TCS,

Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

0 Answers   Amazon,

Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?

1 Answers  

What is the role of tester in discovery(in Checklist)?

0 Answers  

What is database collection?

0 Answers  

i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

0 Answers   Datamatics,

What is a database string?

0 Answers  

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

0 Answers   Miracle Software,

Explain the table term used in database.

0 Answers  

What is difference between server and database?

0 Answers  

What are different types of clusters present?

0 Answers   C DAC, CDAC,