Online Access Free 1Z0-035 Exam Questions

Which statement correctly describes the function of the Oracle9i Cache Fusion feature?

• A.It provides each session with its own view of the database at a different point in the past.
• B.It allows you to add new sites to multimaster replication environment without quiescing the master definition site.
• C.It enables you to execute scalable applications on a clustered database without having to partition the users or the database tables.
• D.It lets you dynamically reassign memory in your database buffer cache to different block buffer sizes.

You use the TABLESPACES option of the Export command to export, not transport, the contents of a set of tablespaces. What are the only contents of the dump file?

• A.1. non-partitioned tables in the tablespace set
  2.partitioned tables that have all their partitions in the tablespace set
  3.indexes on all the exported tables
• B.1. non-partitioned tables in the tablespace set
  2.partitioned tables that have at least one partition in the tablespace set
  3.tables (including all partitions, if they exist) that have an index in the tablespace set
  4.indexes on all the exported tables
• C.1. non-partitioned tables in the tablespace set
  2.partitioned tables that have all their partitions in the tablespace set
  3.indexes on the exported tables if the indexes are in the tablespace set or have at least one partition in the tablespace set
• D.1. non-partitioned tables in the tablespace set
  2.partitioned tables that have at least one partition in the tablespace set
  3.indexes on all the exported tables

A switchover to a standby database differs from a failover to the standby in a number of ways. What are two of the key differences that characterize a switchover? (Choose two.)

• A.The operation is planned and causes no data loss.
• B.The standby database must be running in a no data divergence mode.
• C.The old primary database can take on the standby role and be available for a future switchover.
• D.The primary and standby database must be using exactly the same release and patch level of Oracle9i.
• E.Either the primary database's online or archived log files, but not necessarily both, must be available.

Examine the statement:
DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES;
What is the result of the statement?

• A.The statement will only succeed if the IND2 tablespace was built using Oracle-Managed Files (OMF) data files.
• B.The statement will only succeed if the data files belonging to the IND2 tablespace are Oracle-Managed Files (OMF) or if the database was created using OMF.
• C.The contents of the tablespace are dropped along with all its data files except those identified with the Oracle-Managed Files (OMF) naming convention.
• D.The contents and data files belonging to the IND2 tablespace are dropped.

The TYPE clause used in the creation of an external table defines which access driver is used to convert the data when needed by SQL statements inside the database. Which type of access driver is supported for external tables?

• A.Import
• B.Direct path export
• C.ORACLE LOADER
• D.Metadata API