Oracle.1Z0-051.175q(17)

OCP 11g 051题库

SQL> DROP TABLE products;

What is the implication of this command? (Choose all that apply.)

A. All data along with the table structure is deleted.

B. The pending transaction in the session is committed.

C. All indexes on the table will remain but they are invalidated.

D. All views and synonyms will remain but they are invalidated.

E. All data in the table are deleted but the table structure will remain.

Answer: ABD

QUESTION 38

Which two statements are true regarding views? (Choose two.)

A. A simple view in which column aliases have been used cannot be updated.

B. Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.

C. Rows added through a view are deleted from the table automatically when the view is dropped.

D. The OR REPLACE option is used to change the definition of an existing view without dropping and re-creating it.

E. The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.

Answer: BD

QUESTION 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 AS4 ? 4;

SELECT employee_id, last_name,job_id4 ? 4;

FROM employees4 ? 4;

WHERE job_id LIKE 'SA_%'4 ? 4; 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