CareerCup

Oracle Interview Question for Developer Program Engineers

1

of 1 vote

5
Answers
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?

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 DEPARTMENT with a primary key that is not the value of the DEPT column of any row in EMPLOYEE

Deleting a row of DEPARTMENT

Inserting a new row into EMPLOYEE with a DEPT whose value is not the primary key of any of the rows in DEPARTMENT
- ankit July 14, 2011 | Report Duplicate | Flag | PURGE
Oracle Developer Program Engineer Database

Email me when people comment.

Email me when people comment.

Loading...

An error occurred in subscribing you.

More Questions from This Interview

Email me when people comment.

Email me when people comment.

Loading...

An error occurred in subscribing you.

Comment hidden because of low score. Click to expand.

5

of 5 vote

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

- Anonymous August 13, 2011 | Flag Reply

Comment hidden because of low score. Click to expand.

-1

of 1 vote

Deleting a row of DEPARTMENT

- sushant August 04, 2012 | Flag

Comment hidden because of low score. Click to expand.

0

of 0 vote

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

- Subrahmanyam April 17, 2013 | Flag Reply

Comment hidden because of low score. Click to expand.

0

of 0 vote

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

- harshad.sindhav May 14, 2014 | Flag Reply

Comment hidden because of low score. Click to expand.

-2

of 2 vote

Deleting a row in Dept will have effect on the employee table.... we have to mention on delete for that..

- Subrahmanyam April 17, 2013 | Flag Reply

Books

is a comprehensive book on getting a job at a top tech company, while focuses on dev interviews and does this for PMs.

Videos

CareerCup's interview videos give you a real-life look at technical interviews. In these unscripted videos, watch how other candidates handle tough questions and how the interviewer thinks about their performance.

Resume Review

Most engineers make critical mistakes on their resumes -- we can fix your resume with our custom resume review service. And, we use fellow engineers as our resume reviewers, so you can be sure that we "get" what you're saying.

Mock Interviews

Our Mock Interviews will be conducted "in character" just like a real interview, and can focus on whatever topics you want. All our interviewers have worked for Microsoft, Google or Amazon, you know you'll get a true-to-life experience.