Oracle Certification Exam Question:

Download Job Interview Questions and Answers PDF

What is the difference between primary key and foreign key

Oracle Certification Interview Question
Oracle Certification Interview Question

Answer:

Primary Key is unique Key entire the table and which is
also NOT NULL
where as foriegn key is the null & which references the
primary key .

Download Oracle Certification Interview Questions And Answers PDF

Previous QuestionNext Question
Explain When does a transaction complete? (Choose all that apply.)
A. When a DELETE statement is executed
B. When a ROLLBACK command is executed
C. When a PL/SQL anonymous block is executed
D. When a data definition language statement is executed
E. When a TRUNCATE statement is executed after the pending transaction
How to use STANDBY_ARCHIVE_DEST parameter and explain its need?