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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Database Management
 
 


 

 
 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
Explain the key constraints and constraints on Null Values
with examples?
 Question Submitted By :: Zeadbinyahya
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Explain the key constraints and constraints on Null Values with examples?
Answer
# 1
hi ,

key constraits i.e. referential integerity  means

all values in foreign key must be in primary key , but it 
may happnes that NULL  values may be in foreign key , but 
not in primary key .

this is done to cater some of the exception conditions.
 
Is This Answer Correct ?    2 Yes 0 No
Amit
 

 
 
 
Other Database Management Interview Questions
 
  Question Asked @ Answers
 
What are the different kind of export backups ?  1
I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . How can i do that?  2
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?  1
Explain about User_Defined Exceptions?  1
Which of the packaged procedure is UNRESTRICTED ?  1
What is Full Backup ?  1
For a field in a repeating frame, can the source come from a column ?  1
If CPU is very slow What can u do to speed up?  1
What is a logical backup ?  2
What are ACID properties?  4
What is the use of RECORD option in EXP command ?  1
Can we attach the same List of Values to different fields in Design time ?  1
From where ENQUEUE resources parameter information is derived ?  1
What are the different events in Triggers ?  1
Can we assign Explicitly transaction to a rollback segment  1
when A set of Dictionary tables are created ?  1
What is the use of Snapshot?  1
wHAT IS THE difference between foreign key and reference key  1
Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz  1
When do you get a .PLL extension ?  1
 
For more Database Management 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