What is the difference between column level constraints and
table level constraints?

Answers were Sorted based on User's Feedback



What is the difference between column level constraints and table level constraints?..

Answer / nilesh

Column level constraints are applicable to that column
only, whereas table level conatraints are used to define
composite keys like primary key for the combination of two
or more columns in a table

Is This Answer Correct ?    201 Yes 35 No

What is the difference between column level constraints and table level constraints?..

Answer / mohan

column level constraints contain all types of constraints
(like, not null,primary key,foregin key,unique).but table
level except not null constraint its supports all
constraints.

Is This Answer Correct ?    125 Yes 32 No

What is the difference between column level constraints and table level constraints?..

Answer / gurupatham

Column Level Constraints refers Only One Column .Which does
not have the column name at declaration time .
Ex : Create table emp
( empno number primary Key,
--,
--);

Table Level constraints refers one or more than one column .
Which does have column name at declaration time.
Ex: Create table emp
( empno number ,
--,
--,
Constraints pk_con primary Key(empno));

All constraints can be created as Column and Table level
expect Not Null constraints .
Not Null constraints can only be created as column level
constraints . Does not have constraints name.

Is This Answer Correct ?    88 Yes 24 No

What is the difference between column level constraints and table level constraints?..

Answer / vijay

1)Column level constraint is declared at the time of
creating a table but table level constraint is created
after table is created.

2)NOT NULL constraint can't be created at table level.

3)Composite primary key must be declared at table level.

4)All the constraints can be created at table level but for
table level NOT NULL is no allowed.

Is This Answer Correct ?    48 Yes 25 No

What is the difference between column level constraints and table level constraints?..

Answer / chaitu

If constraint is defined at the column definition(refer the below exmpls) then it is known to be column level, where as table leevel constraints is defined at the especially incase of composite primary key or composite foriegn key.

Examples
----------

CREATE TABLE CLASS ( ROOM NUMBER(10) CONSTRAINT ID CHECK (ID BETWEEN 1 AND 2000),
..........
.........
........
.........);

Table level
==================

CREATE TABLE CLASS (
ROOM NUMBER(10) ,
SUBJECT VARCHAR2(200),
CODE VARCHAR2(50) NOT NULL, /* Column level constraint*/
ID NUMBER(8,2),
CLASS_DATE DATE,
CONSTRAINT PK_1 PRIMARY KEY (ROOM)); /* table level

Is This Answer Correct ?    30 Yes 9 No

What is the difference between column level constraints and table level constraints?..

Answer / rajan sharma

Column level are those constraints that are inserted after
the declaration of the data typeot

Syntax :

CREATE TABLE table_name
(Column_name Datatype NOT NULL )

Example : Not null,pimary key,foreign key, unique and check.

Table level constraints are those that are inserted at the
end of the table.

Example : pimary key,foreign key, unique and check.

Thanks

Is This Answer Correct ?    21 Yes 4 No

What is the difference between column level constraints and table level constraints?..

Answer / priya

Constraints define the conditions or predictions under
which data is valid.
column level constraints are applicable to single column
only like if we want to make Unique constraint on column
level then as shoen below:-
<column Name><data type>Unique
At table level
Unique(<coulmn>,<column>);
Table level constraints means when constraints apply on
more than single column.

Is This Answer Correct ?    22 Yes 6 No

What is the difference between column level constraints and table level constraints?..

Answer / pcsenthil

we can achive all type of constraint in both level but we
cannot use NOT NULL in table Level, the reason was "All
Constraint will give logical view to that particular column
but NOT NULL will assign to the structure of the table
itself.. that's why we can see NOT NULL constraint while
Describe the table, no other constraint will be seen.

Is This Answer Correct ?    17 Yes 5 No

What is the difference between column level constraints and table level constraints?..

Answer / adinarayana

COLUMN LEVEL
1.Column level constraints can be defined along with the
columns.
2.NOT NULL constraints can be defined at this level(to only
one column).
3.Composite keys can't be defined at this level

TABLE LEVEL
1.Table level constraints can be defined after defining the
all columns
2.NOT NULL constraints can't be defined at this level.
3.Composite key can be defined at this level

Is This Answer Correct ?    8 Yes 0 No

What is the difference between column level constraints and table level constraints?..

Answer / rahulnayan007@gmail.com

clc = column level constraints
tlc = table level constraints

a) tlc do not support null constraint but clc do.
b) tlc can be used to construct composite keys but clc can't.
c) tlc and clc,using both we can assign names to consraints . being applied to any column.
d)

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Oracle General Interview Questions

How do you rate yourself in oracle and sql server ?

2 Answers   Keane India Ltd,


How many types of tables supported by oracle?

0 Answers  


Is postgres faster than oracle?

0 Answers  


What is literal?

0 Answers  


What is the use of Redo Log Information ?

2 Answers  






What is meant by redo log buffer ?

2 Answers  


Where do we use decode and case statements?

0 Answers  


What is different bet native dynamic sql and Dbms_Sql?

4 Answers   Thermotech,


Select the Nth lowest value from a table?

4 Answers  


Can anyone give me information about oracle certification

1 Answers  


How to start a new transaction in oracle?

0 Answers  


What is a oracle database?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)