Oracle%20Interview%20Questions%20and%20Answers
Question: What are the Referential actions supported by FOREIGN KEY integrity constraint?Answer: UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What are the components of physical database structure of Oracle database?
- What are the components of logical database structure of Oracle database?
- What is a tablespace?
- What is SYSTEM tablespace and when is it created?
- Explain the relationship among database, tablespace and data file?