Oracle Interview Report
- 1of 1 vote
AnswersWhich 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?
- ankit July 14, 2011
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| Report Duplicate | Flag | PURGE
Oracle Developer Program Engineer Database - 0of 0 votes
AnswersAn organization stores its employee records in a table, “Emp”. This table has various attributes such as First Name, Last Name, Designation and Salary. The organization stores details of the employee's children in another table, “EmpChildren”. The EmpChildren table has attributes like First Name, Last Name, and Birth Date. The Emp table is a parent table and EmpChildren table is a child table. An employee may have many children, but each child will have only one parent.
- ankit July 14, 2011
From the following options, select the type of database model depicted by the above scenario.
Relational model
Network model
Hierarchical model
Object database mode| Report Duplicate | Flag | PURGE
Oracle Developer Program Engineer Database - 0of 0 votes
AnswersSelect the option that represents the definition of network database model.
- ankit July 14, 2011
Attempts to bring closer interactivity between database administrators and application programmers
Represents the entire information content of the database in only one way
Organizes the data in the form of a tree of records, with each record having one parent record and many children records
Allows each record to have multiple parent and child records, thereby forming a lattice structure| Report Duplicate | Flag | PURGE
Oracle Developer Program Engineer Database