ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
What is the difference between column level constraints and 
table level constraints?
 Question Submitted By :: Zikku
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the difference between column level constraints and table level constraints?
Answer
# 1
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 ?    9 Yes 3 No
Nilesh
 
  Re: What is the difference between column level constraints and table level constraints?
Answer
# 2
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 ?    8 Yes 1 No
Mohan
 
 
 
  Re: What is the difference between column level constraints and table level constraints?
Answer
# 3
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 ?    3 Yes 0 No
Gurupatham
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
What is a Temporary Segment ?  1
Can a property clause itself be based on a property clause ? Oracle1
What are the advantages of Views ?  1
what are views? TCS5
Can we create more than one index on particular column?  1
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?  1
What is a heap related to database ? TCS1
What is the difference between Outer join and Full outer join?  1
what diffrence between function and procedure?  3
What is a Segment ?  1
a query to select maxmun 3 salaries of employee table Polaris5
What is an Extent ?  2
Difference between sub query and nested query ? Keane-India-Ltd5
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.  1
What is Row Chaining ?  1
what are the differen between key flexifild and discriptive fiexifild.  1
Can Multiple instances be run on Single Machine???  2
What are the different type of Segments ?  1
Can anyone give me information about oracle certification  1
Is primary key = unique key,not null? If yes,please explain IF No,please explain  3
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com