1Z0-006 Database Objects and Constraints 2

Question 1

What is a view in Oracle Database?

Accepted Answer

A named query stored in the database that behaves as a virtual table

Answer

A view is a stored SELECT query that acts as a virtual table; it does not store data itself but derives results from underlying tables each time it is queried.

Question 2

Which pseudo-column retrieves the NEXT value from an Oracle sequence and increments the counter?

Accepted Answer

sequence_name.NEXTVAL

Answer

The NEXTVAL pseudo-column retrieves the next available value from a sequence and advances the sequence counter each time it is accessed.

Question 3

What does the CURRVAL pseudo-column of an Oracle sequence return?

Accepted Answer

The most recently generated value from the sequence in the current session

Answer

CURRVAL returns the most recently generated sequence value within the current session; NEXTVAL must be called at least once before CURRVAL can be referenced.

Question 4

Which clause in a CREATE VIEW statement ensures that INSERT and UPDATE operations through the view only affect rows the view can still select?

Accepted Answer

WITH CHECK OPTION

Answer

WITH CHECK OPTION ensures that any row inserted or updated through the view must satisfy the view's WHERE condition, preventing data from being modified outside the view's scope.

Question 5

Which CREATE VIEW clause prevents any INSERT, UPDATE, or DELETE operations through the view?

Accepted Answer

WITH READ ONLY

Answer

The WITH READ ONLY clause creates a view that blocks all DML operations, making the view strictly a read-only window into the underlying data.

(1Z0-006) Oracle Database Foundations Associate Practice Test

(1Z0-006) Oracle Database Foundations Associate Practice Test

1Z0-006 Database Objects and Constraints 2