Oracle
1Z0-141 · Question #31
1Z0-141 Question #31: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-141 to reveal the answer and full explanation for question #31. The question stem and answer options stay visible for context.
Question
The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table. You are developing a Human Resources application. HR clerks use the Employees form to query, update, and insert employee records. They occasionally attempt to add an employee who is in a new department that has not yet been entered into the database. When this happens, they receive an error indicating that the parent record cannot be found, so they cannot commit the employee record. The HR clerks have requested that you place a button on the form to enable them to invoke the Departments form to enter the new department and save it independently. Then they want to be able to return to the Employees form and decide whether or not to save the new employee record. How should you code the When-Button-Pressed trigger to achieve this?
Options
- ACALL_FORM('Departments');
- BCALL_FORM('Departments',NO_HIDE);
- COPEN_FORM('Departments');
- DOPEN_FORM('Departments',ACTIVATE,SESSION);
- EOPEN_FORM('Departments',NO_ACTIVATE,NO_SESSION);
- FNEW_FORM('Departments');
- GPOST; NEW_FORM('Departments',FULL_ROLLBACK);
Unlock 1Z0-141 to see the answer
You've previewed enough free 1Z0-141 questions. Unlock 1Z0-141 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.