yes, we can ex. create table t1 (empno number(4) not null, ename var

Can we create more than one constraint to column ?

Question Posted / tripti gour

Answer Posted / tripti gour

yes, we can
ex.

create table t1
(empno number(4) not null,
ename varchar2(30),
constraint u_k_t1 unique key (empno));

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to load a large xml file?

1002

What are the differences between char and varchar2 in oracle?

1072

What happens if you set the sga too low in oracle?

1052

How to create a stored function in oracle?

1037

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5413

What is an oracle user account?

930

State any two functions of oracle?

981

How to see the table columns used in an index?

958

Please explain drop constraint oracle?

1026

What is the max number of columns in an oracle table?

929

Design database draw er diagram for a certain scenario ?

4528

How to export data to a csv file?

1201

What are the different pseudo commands? Explain in general?

1020

How to assign values to variables?

1043

What is SQL access advisor in Oracle?

1136