Oracle
1Z0-047 · Question #239
1Z0-047 Question #239: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #239. The question stem and answer options stay visible for context.
Question
Evaluate the following command: CREATE TABLE employees (employee_id NUMBER(2) PRIMARY KEY, last_name VARCHAR2(25) NOT NULL, department_id NUMBER(2), job_id VARCHAR2(8), salary NUMBER(10,2)); You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization: CREATE OR REPLACE VIEW sales_staff_vu AS SELECT employee_id, last_name,job_id FROM employees WHERE job_id LIKE 'SA_%' WITH CHECK OPTION; Which statements are true regarding the above view? (Choose all that apply.)
Options
- AIt allows you to insert details of all new staff into the EMPLOYEES table.
- BIt allows you to delete the details of the existing sales staff from the EMPLOYEES table.
- CIt allows you to update the job ids of the existing sales staff to any other job id in the EMPLOYEES table.
- DIt allows you to insert the IDs, last names and job ids of the sales staff from the view if it is used in multitable
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 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.