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 physical copy of a table stored separately

Answer

A backup of a table captured at a point in time

Answer

A type of index that speeds up queries

Question 2

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

Accepted Answer

sequence_name.NEXTVAL

Answer

sequence_name.CURRVAL

Answer

sequence_name.INCREMENT

Answer

sequence_name.NEXT

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

The next value the sequence will generate

Answer

The maximum value the sequence can reach

Answer

The starting value of the sequence

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 READ ONLY

Answer

WITH CONSTRAINT

Answer

WITH FILTER OPTION

Question 5

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

Accepted Answer

WITH READ ONLY

Answer

WITH CONSTRAINT

Answer

WITH NO DML

Answer

WITH CHECK OPTION

Question 6

Which CREATE SEQUENCE option defines the lowest value a descending sequence can reach?

Accepted Answer

MINVALUE

Answer

START WITH

Answer

INCREMENT BY

Answer

CACHE

Question 7

Which of the following is a key advantage of using views in Oracle Database?

Accepted Answer

Views can simplify complex queries and restrict user access to specific columns or rows

Answer

Views always pre-compute results for faster retrieval

Answer

Views store redundant copies of data for backup purposes

Answer

Views automatically create indexes on the underlying tables