Oracle 1Z0-035 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z0-035
Exam Name/Title: Oracle9i dba new features for Oracle7.3 and Oracle9 ocps
Certification Provider: Oracle
Corresponding Certification: 9i DBA

Exam Questions: 168
Updated On: Jul 13, 2026

Question #19

You decide to split a partition of an index. For which type of index is this allowed?

A. local nonprefixed

B. bitmap prefixed

C. global prefixed

D. local prefixed

Discussion 0

Correct Answer: C Vote an answer

Question #20

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

A. Oracle Flashback uses undo information to construct consistent data.

B. Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.

C. 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.

D. You can only use an Oracle Flashback view of the data if the required records are still in the online redo log files.

Discussion 0

Correct Answer: A,C Vote an answer

Question #21

Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table.
Which two steps are you recommended to do prior to issuing the dbms_redefinition.start_redef_table procedure call? (Choose two).

A. grant privileges on the interim table

B. create any triggers, indexes, or constraints on the interim table

C. invoke the dbms_redefinition.sync_interim_table procedure

D. create an empty interim table with all the desired characteristics

E. invoke the dbms_redefinition.can_redef_table procedure

Discussion 0

Correct Answer: D,E Vote an answer

Question #22

Consider this RMAN command:
RMAN> CONFIGURE RETENTION POLICY CLEAR;
What is the effect of this command?

A. It removes any retention policy.

B. Backups will never expire.

C. The DELETE OBSOLETE command will fail with an error.

D. It sets the retention policy to the default of REDUNDANCY 1.

Discussion 0

Correct Answer: D Vote an answer

Question #23

What must you do to enable Automated SQL Execution Memory Management?

A. Set the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and SORT_AREA_RETAINED_SIZE all to AUTO.

B. Execute the DBMS_STATS.GATHER_SYSTEM_STATS procedure with appropriate values

C. Unset the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and SORT_AREA_RETAINED_SIZE.

D. Set the instance parameters PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY to appropriate values.

Discussion 0

Correct Answer: D Vote an answer

Question #24

What should you look at first to compute the number of undo blocks written per second to disk?

A. V$ROLLSTAT

B. DBA_UNDO_EXTENTS

C. DBA_ROLLBACK_SEGS

D. V$TRANSACTION

E. V$UNDOSTAT

Discussion 0

Correct Answer: E Vote an answer

Question #25

If you create your database using Oracle Managed Files (OMF), what is true?

A. You must use Oracle predefined names to identify raw partitions that will hold OMF structures.

B. You must define directories for two online redo log groups and three copies of the control file.

C. If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.

D. You must use only OMF data files when adding new tablespaces or data files to your database in the future.

Discussion 0

Correct Answer: C Vote an answer

Question #26

User defined events in Oracle Enterprise Manager return status, and possibly values, to the Oracle Enterprise Manager Event Monitor. What are user defined events?

A. scripts run by the Agent in any language on the host server

B. database based scripts (PL/SQL, Java) run by the Agent

C. Database Event Triggers, which issue Alerts to the Agent

D. user written PL/SQL programs in the database, which the OEM console can execute and display the results

Discussion 0

Correct Answer: A Vote an answer

Question #27

You need to version enable the MORTGAGE table containing customer mortgage trend information. Which syntax version enables the MORTGAGE table?

A. DBMS_LT.ENABLEVERSIONING('MORTGAGE');

B. DBMS_WM.ENABLE_TABLE('MORTGAGE');

C. DBMS_WM.ENABLEVERSIONING('MORTGAGE');

D. DBMS_LT.ENABLETABLE('MORTGAGE');

Discussion 0

Correct Answer: C Vote an answer

Download Free Oracle 1Z0-035 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-035 exam.