Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can we create more than one constraint to column ?

Answers were Sorted based on User's Feedback



Can we create more than one constraint to column ?..

Answer / deva

yes we can

Is This Answer Correct ?    2 Yes 0 No

Can we create more than one constraint to column ?..

Answer / vijay

u can create more than one constraint on on column

Vijay Kushwaha

Is This Answer Correct ?    2 Yes 0 No

Can we create more than one constraint to column ?..

Answer / nageswararao.kamineni

we can create morethan one constrint on column
for example
create table emp11
(empno number(2) primary key,
ename varchar2(20) unique,not null
sal number(7,2));
here a table can containe only one primary key,if we wnat
declare more then one primary key,we can create like this
using unique and not null constarint.

Is This Answer Correct ?    2 Yes 0 No

Can we create more than one constraint to column ?..

Answer / madhava

s we can create

Is This Answer Correct ?    1 Yes 0 No

Can we create more than one constraint to column ?..

Answer / 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

Can we create more than one constraint to column ?..

Answer / mosab

yes we can create more than constraints to only columns

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What happens to the data files if a tablespace is dropped?

0 Answers  


How to initialize variables with default values?

0 Answers  


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

0 Answers  


How to name query output columns in oracle?

0 Answers  


How to grant create session privilege to a user in oracle?

0 Answers  


pls explain connect by prior with example and its real time use

3 Answers  


How to Select second Maximum salary in a Table ?

13 Answers   Oracle,


Can you use a commit statement within a database trigger?

4 Answers  


How to use fetch statement in a loop?

0 Answers  


How to delete an existing row from a table in oracle?

0 Answers  


what is the difference between oracle enterprise edition and oracle express edition?

2 Answers  


What are the different types of failures that occur in Oracle database?

0 Answers   HCL,


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • 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)