Free Oracle 1Z0-035 Exam Dumps Questions & Answers

What does the Metadata Application Programming Interface (API) allow you to do?

• A.  extract data definition commands from the data dictionary in a variety of formats
• B.  repair damaged data dictionary entries
• C.  prepare pseudocode modules for conversion to Java or PL/SQL programs with a Metadata code generator
• D.  delete data dictionary information about database objects you no longer need

Which operation causes an index to be considered "used" while monitoring is turned on for that particular index?

• A.  when a statement is parsed and the resulting execution plan contains a reference to the index
• B.  when data is fetched by an execution plan that uses that index
• C.  when a statement is executed and the execution plan contains a reference to the index
• D.  only when the index is specified in a hint

You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback? (Choose two.)

• A.  You can only use an Oracle Flashback view of the data if the required records are still in the online redo log files.
• B.  Oracle Flashback uses undo information to construct consistent data.
• C.  Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.
• D.  You can use a PL/SQL cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.

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

You decide to activate the resumable space allocation feature for all your database users by enabling the feature in a logon trigger.
This causes a statement that requires space beyond a user's quota _____.

• A.  to invoke the default trigger that resets user quota, if there is free space in the related tablespace
• B.  to wait in a suspended state until the quota is increased or until the timeout value is reached
• C.  to wait indefinitely for the quota to be increased, regardless of the timeout setting for other space allocation problems.
• D.  to fail because quota limits do not activate the resumable space allocation feature