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 04, 2026

Question #1

What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?

A. It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1.

B. It is possible to switch to UNDO2, but current active transactions will abort.

C. It is NOT possible to switch unless no active transaction exists in UNDO1.

D. It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.

Discussion 0

Correct Answer: A Vote an answer

Question #2

Which three parameters are ignored when creating an automatic space management segment? (Choose three.)

A. FREELISTS

B. MAXTRANS

C. PCTUSED

D. PCTFREE

E. FREELIST GROUPS

F. INITRANS

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #3

What does using the package DBMS_RESOURCE_MANAGER enable you to do?

A. distribute available processing resources among sets of users

B. guarantee a minimum degree of parallelism to a set of users

C. limit the degree of parallelism on a given set of tables

D. dynamically change profiles assigned to sets of users

E. guarantee certain sets of users a minimum amount of disk space

Discussion 0

Correct Answer: A Vote an answer

Question #4

Your database has tablespaces with different block sizes. What must you do to back these up with RMAN?

A. You need to use RMAN BACKUP BLOCKSIZE=nK to select tablespaces that are not the same size as the standard block size.

B. You must allow for the fact that RMAN will generate several backupsets, one for each block size, when you issue the RMAN BACKUP command.

C. You can simply issue the RMAN BACKUP command, because a backup set can contain tablespaces of different block sizes.

D. You need to issue a separate RMAN BACKUP command to group tablespaces with the same block size.

Discussion 0

Correct Answer: B Vote an answer

Question #5

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

A. allows you to use VARCHAR2, DATE, NUMBER and CHAR data type messages

B. allows you to use a REPLY queue to receive answers to your messages

C. allows you to prioritize or order messages

D. allows you to use RAW or user-defined data types for messages

E. allows you to put time constraints on messages so that they will be removed from the queue after a specified time

Discussion 0

Correct Answer: C,D,E Vote an answer

Question #6

What does the DBMS_OLAP.VALIDATE_DIMENSION procedure do?

A. verifies that the columns in the dimension exist in the summary

B. verifies that the table referenced in the dimension exists

C. verifies that the columns in a dimension satisfy the one-to-many relationship in the hierarchy

D. verifies that the columns in the dimension exist in the materialized view

Discussion 0

Correct Answer: C Vote an answer

Question #7

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

A. The contents of the tablespace are dropped along with all its data files except those identified with the Oracle-Managed Files (OMF) naming convention.

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 and data files belonging to the IND2 tablespace are dropped.

D. The statement will only succeed if the IND2 tablespace was built using Oracle-Managed Files (OMF) data files.

Discussion 0

Correct Answer: C Vote an answer

Question #8

ABC Company consolidated into one office building, so the very large EMPLOYEES table no longer requires the OFFICE_LOCATION column. The DBA decided to drop the column using the syntax below:
ALTER TABLE hr.employees DROP COLUMN building_location CASCADE CONSTRAINTS; Dropping this column has turned out to be very time consuming and is requiring a large amount of undo space.
What could the DBA have done to minimize the problem regarding time and undo space consumption?

A. Use the Export and Import utilities to bypass undo.

B. Add a checkpoint to the DROP UNUSED COLUMNS command to minimize undo space.

C. Mark the column as UNUSED.
Remove the column at a later time when less activity is on the system.

D. Mark the column INVALID prior to beginning the drop to bypass undo.
Remove the column using the DROP UNUSED COLUMNS command.

E. Drop all indexes and constraints associated with the column prior to dropping the column.

Discussion 0

Correct Answer: C Vote an answer

Question #9

The enterprise data warehouse routinely receives data from various production OLTP databases. The database block size on the data warehouse is 8192, and in the OLTP databases it may be 2048, 4096 or 8192. The current SGA is 112 MB.
Oracle9i has the ability to transport tablespaces with different block sizes.
Which two parameters are required in order to "plug in" the OLTP tablespaces into the warehouse database? (Choose two.)

A. DB_4K_CACHE_SIZE

B. DB_4K_BLOCK_BUFFERS

C. DB_8K_BLOCK_BUFFERS

D. DB_8K_CACHE_SIZE

E. DB_2K_BLOCK_BUFFERS

F. DB_2K_CACHE_SIZE

Discussion 0

Correct Answer: A,F 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.