what is primary key and foreign key when and where have to use
Answer Posted / chandrika
primary key has unique value, it dostnt contain null values
and duplicate values.
foregin key is primary key of another table
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How many file formats are supported to export data?
What is the data type of dual table?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How do we get field details of a table?
Explain oracle left join with an example?
How to check the server version in oracle?
How to get the Installed Oracle Version Information ?
Explain enable novalidate constraint.
What's dateware house and what's clustor with practicle example
How to assign data of the deleted row to variables?
Explain about your project and its relation to the current job position you are applying to?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to resolve name conflicts between variables and columns?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What is transport network substrate (tns) in oracle?