Oracle.1Z0-051.175q(19)

OCP 11g 051题库

A. The view will be created and you can perform DML operations on the view.

B. The view will be created but no DML operations will be allowed on the view.

C. The view will not be created because the join statements are not allowed for creating a view.

D. The view will not be created because the GROUP BY clause is not allowed for creating a view.

Answer: B

QUESTION 41

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

A. A subquery that defines a view cannot include the GROUP BY clause.

B. A view that is created with the subquery having the DISTINCT keyword can be updated.

C. A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated.

D. A data manipulation language ( DML) operation can be performed on a view that is created with the subquery having all the NOT N

Answer: CD

QUESTION 42

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

A. Views can be created only from tables.

B. Views can be created from tables or other views.

C. Only simple views can use indexes existing on the underlying tables.

D. Both simple and complex views can use indexes existing on the underlying tables.

E. Complex views can be created only on multiple tables that exist in the same schema.

F. Complex views can be created on multiple tables that exist in the same or different schemas.

Answer: BDF

QUESTION 43

Evaluate the following CREATE SEQUENCE statement:

CREATE SEQUENCE seq1

START WITH 100

INCREMENT BY 10

MAXVALUE 200

CYCLE

NOCACHE;

The SEQ1 sequence has generated numbers up to the maximum limit of 200. You issue the following SQL

statement:

SELECT seq1.nextval FROM dual;

What is displayed by the SELECT statement?

A. 1

B. 10

C. 100

D. an error

Answer: A