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 define a specific record type?

1072

Differentiate between translate and replace?

1083

How to create a new oracle data file?

1019

What is a user role in oracle?

1102

How to specify default values in insert statement using oracle?

1084

Explain what are the uses of rollback segment?

992

Can we store images in oracle database?

989

What are the differences between blob and clob in oracle?

1066

Explain user account with reference to oracle.

960

What are the general rules on data consistency?

989

Which environment variables are absolutely critical in order to run the OUI?

2104

Explain about integrity constraint?

1108

What is a dynamic performance view in oracle?

977

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1081

Is the After report trigger fired if the report execution fails ?

2901