Oracle Interview Question Developer Program Engineers

  • oracle-interview-questions
    0
    of 0 votes
    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 on July 14, 2011 Report Duplicate | Flag
    Oracle Developer Program Engineer Database



Comment hidden because of low score. Click to expand.
4
of 4 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 on August 13, 2011 | Flag Reply
Comment hidden because of low score. Click to expand.
-1
of 1 vote

Deleting a row of DEPARTMENT

- sushant on 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 on 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 on May 14, 2014 | Flag Reply
Comment hidden because of low score. Click to expand.
-1
of 1 vote

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

- Subrahmanyam on April 17, 2013 | Flag Reply


Add a Comment
Name:

Writing Code? Surround your code with {{{ and }}} to preserve whitespace.

Books

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

Learn More

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.

Learn More

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.

Learn More

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.

Learn More