Can we create more than one constraint to column ?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

515


what is the scripts in data base?

1602


What are the parameters that we can pass through a stored procedure?

553


What is an oracle and why it is used?

623


Why cursor variables are easier to use than cursors?

570






What is the best way to do multi-row insert in oracle?

563


How to start your 10g xe server from command line?

548


What are data pump export and import modes?

611


What are the most common interview questions on ETL Testing for experience?

597


How to create a new table by selecting rows from another table?

553


How to use windows user to connect to the server?

534


How to create an oracle database manually?

569


what is dynamic SGA and static SGA

3840


what are the advantages of running a database in archive log mode?

1735


What is a select query statement in oracle?

545