OCP 11g试题解析：1Z0-051-039题

OCP 11g试题解析：1Z0-051-039题，完整题库请点击这里联系老师咨询了解

39. Evaluate the following command:

CREATE TABLE employees

(employee_id NUMBER(2) PRIMARY KEY,

last_name VARCHAR2(25) NOT NULL,

department_id NUMBER(2)NOT NULL,

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 two statements are true regarding the above view? (Choose two.)

A. It allows you to insert rows into the EMPLOYEES table .

B. It allows you to delete details of the existing sales staff from the EMPLOYEES table.

C. It allows you to update job IDs of the existing sales staff to any other job ID in the EMPLOYEES table.

D. It allows you to insert IDs, last names, and job IDs of the sales staff from the view if it is used in multitable INSERT statements.

Answer: BD