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 #55

Which three things can the ALTER INDEX REBUILD command accomplish? (Choose three.)

A. move the index to a different tablespace

B. rebuild a reverse index from an existing B-tree index

C. convert a bitmap index to a B-tree index

D. change the storage parameters for the index

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #56

Consider this syntax:
MERGE INTO t1
USING t2 ON (join predicate).
What does the MERGE syntax do?

A. It performs a merge join of the row from T2 only if it doesn't exist in the T1 table.

B. It creates a natural join of tables T1 and T2 for all columns that have the same name.

C. It creates a Cartesian product of table T1 and table T2 for all columns that have the same name.

D. For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.

Discussion 0

Correct Answer: D Vote an answer

Question #57

Online index rebuild functionality has been extended to include which four index structures? (Choose four.)

A. key-compressed indexes on regular tables

B. reverse key indexes

C. bitmap indexes

D. key-compressed indexes on IOT (including secondary indexes)

E. function-based indexes

Discussion 0

Correct Answer: A,B,D,E Vote an answer

Question #58

What are the two methods used to add a second, or subsequent, block size to an existing database? (Choose two.)

A. Create a new tablespace and include a block size specification.

B. Re-create the control file to specify a new block size for specific data files.

C. Take a tablespace offline, and then put it back online with a new block size specification.

D. Transport a tablespace with a different block size into the database.

Discussion 0

Correct Answer: A,D Vote an answer

Question #59

What can you see when querying V$LOGMNR_CONTENTS?

A. the SQL statement run, and the relevant undo SQL statement

B. the SQL statement run, and the old image

C. the old image and the new image of the row that was modified

D. only the redo generated by the current schema

E. the SQL statement run, and the new image

Discussion 0

Correct Answer: A Vote an answer

Question #60

What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?

A. information stored inside a data dictionary table

B. the filename format

C. information stored in the ALERT.LOG file for the corresponding instance

D. information stored inside the corresponding initialization parameter file for the instance

Discussion 0

Correct Answer: B Vote an answer

Question #61

What is true regarding a shared, server-side parameter file for a Real Application Clusters database?

A. It can contain only parameters with identical values for each instance.

B. It can contain parameters with distinct values for each instance.

C. It must be located in the default location for the primary instance's parameter file.

D. It must contain an IFILE parameter for each instance's individual parameter file.

Discussion 0

Correct Answer: B Vote an answer

Question #62

Which CREATE TABLE parameter should you be concerned with if the length of rows in an index-organized table vary over a wide range of values?

A. PCTTHRESHOLD

B. PCTUSED

C. PCTFREE

D. PCTINCREASE

Discussion 0

Correct Answer: A Vote an answer

Question #63

You can control instance recovery performance by setting parameters to define targets for _____.

A. the size of the redo buffer in the SGA

B. the number of passes through the redo logs made by the recovery process to identify blocks needing recovery

C. the instance that will perform recovery in a Real Application Clusters database

D. the number of blocks to be read during instance recovery, or the time needed to complete instance recovery

Discussion 0

Correct Answer: D 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.