Online Access Free 1Z0-035 Practice Test

Examine this statement, which creates a Cartesian product of the COUNTRIES and REGION tables:
SQL> SELECT c.country_name, 2> r.region_name 3> FROM countries c, region r;
Oracle9i SQL:1999 syntax supports the same functionality with which join type?

• A.Equijoin
• B.Cross join
• C.Merge join
• D.Natural join

When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view?

• A.during the execution of an INSERT statement only
• B.during a query's execution time only
• C.during a query's parse time only
• D.during any kind of DML statement execution

A table is partitioned on the PROJECTSTART column. You need to create an index with the PROJECTID column as the leftmost portion of the index key followed by the OWNER column. Which index type is required?

• A.bitmap
• B.reverse key
• C.non prefixed
• D.prefixed

Which statements are true regarding the new Persistent Configuration feature in RMAN? (Choose two.)

• A.It enables you to store the settings for Channel attributes so that you do not have to specify them in each backup or restore command.
• B.It enables you to store your Channel attribute settings in the Recovery Catalog with each script.
• C.It remembers the last backup command you used so that you can reschedule it easily.
• D.It allows you to set the retention period of backups.

What is true regarding a transaction executed in Automatic Undo Management mode?

• A.It is possible for the transaction to use inactive extents from another undo tablespace.
• B.It is possible for the transaction to extend the undo tablespace, even if defined with AUTOEXTENSIBLE set to FALSE.
• C.It is possible for the transaction to span different undo segments.
• D.It is possible for the transaction to reuse inactive extents from another undo segment.