Free Oracle 1Z0-035 Exam Dumps Questions & Answers

What is true regarding fact tables having bitmap join indexes defined on them?

• A.  Tables participating in the join condition of the bitmap join index definition cannot be updated concurrently.
• B.  You can create a bitmap join index on a temporary table.
• C.  You cannot have more than one dimension table being part of the join condition of a bitmap join index definition.
• D.  You can create a bitmap join index on an index-organized table.

Which two can be obtained from the summary advisor? (Choose two.)

• A.  summary space requirements
• B.  summary accounting
• C.  summary recommendations
• D.  summary refresh plan

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

Which statement is true when using the DBVERIFY utility to detect corruptions in an Oracle data block?

• A.  The utility can cause contention in the shared pool when there is high activity in the database.
• B.  The utility can be used with the database shut down.
• C.  The utility can be used to verify redo-log files for corruption.
• D.  The utility is useful only when the database is in ARCHIVELOG mode.

What are three advantages of using Oracle Advanced Queuing? (Choose three.)

• A.  allows you to put time constraints on messages so that they will be removed from the queue after a specified time
• B.  allows you to use VARCHAR2, DATE, NUMBER and CHAR data type messages
• C.  allows you to prioritize or order messages
• D.  allows you to use a REPLY queue to receive answers to your messages
• E.  allows you to use RAW or user-defined data types for messages