GeeksforGeeks

GeeksforGeeks » Interview Questions

Oracle Interview Question for Software Engineer/Developer (Fresher) about Terminology

(2 posts)

1. 

   gul
   guest
   Posted 1 year ago #
   
   

   Which one of the following is NOT a referential integrity issue in a relational database where the DEPT column of the EMPLOYEE table is designated as a foreign key into the DEPARTMENT table?

   Inserting a new row into DEPARTMENT with a primary key that is not the value of the DEPT column of any row in EMPLOYEE

   Deleting a row of DEPARTMENT

   Updating the value of DEPT in a row of EMPLOYEE with a value that is not the primary key of any of the rows in DEPARTMENT

   Inserting a new row into EMPLOYEE with a DEPT whose value is not the primary key of any of the rows in DEPARTMENT

2. 

   PanCracyXYE
   guest
   Posted 4 months ago #
   
   

   OKOKOKO

Reply

You must log in to post.

RSS feed for this topic