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

Before adding a nonstandard block size to your database, which preparatory task must you complete?

A. Define a new buffer pool by setting the DB_nK_CACHE_SIZE parameter where n is the new block size.

B. Rebuild the control file using an instance with an initialization file containing two DB_nK_CACHE_SIZE parameters, one for the standard and one for the new block size.

C. Redefine the buffer pool by setting the DB_mK_CACHE_SIZE and DB_nK_CACHE_SIZE parameters, where m is the standard block size and n is the new block size.

D. Rebuild the control file using an instance with an initialization file containing two DB_BLOCK_SIZE parameters, one for the standard and one for the new block size.

Discussion 0

Correct Answer: A Vote an answer

Question #38

What does the optimizer plan stability feature use to maintain different stored outlines for the same SQL statement?

A. categories

B. resource manager

C. profiles

D. schemas

Discussion 0

Correct Answer: A Vote an answer

Question #39

What are three advantages of index-organized tables? (Choose three.)

A. Fewer I/O operations are needed to retrieve data.

B. The table needs to be analyzed less frequently.

C. Less physical storage space is needed for the data.

D. Data is stored in primary key sequence.

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #40

Which two statements are true regarding the use of UTF-16 encoding? (Choose two.)

A. European characters are represented in one or two bytes

B. Asian characters are represented in three characters

C. enables easier loading of multinational data

D. uses a fixed-width multibyte encoding sequence

E. uses a variable-width multibyte encoding sequence

Discussion 0

Correct Answer: C,D Vote an answer

Question #41

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 fail because quota limits do not activate the resumable space allocation feature

B. to invoke the default trigger that resets user quota, if there is free space in the related tablespace

C. to wait in a suspended state until the quota is increased or until the timeout value is reached

D. to wait indefinitely for the quota to be increased, regardless of the timeout setting for other space allocation problems.

Discussion 0

Correct Answer: C Vote an answer

Question #42

The EMPLOYEES table is stored in the SAMPLE tablespace.
The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in the INDX tablespace.
Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace.
Which objects will be exported by this command? exp system/manager tablespaces=SAMPLE

A. the EMPLOYEES table, IPK_EMP index, and the SALES table

B. only the EMPLOYEES table and its corresponding primary key index

C. only the EMPLOYEES table

D. the EMPLOYEES table and partition P1

Discussion 0

Correct Answer: A Vote an answer

Question #43

What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED; command?

A. the standby database is protected against write operations

B. the primary database is protected against write operations

C. the primary database is protected against data loss and data divergence

D. the standby database is protected against data loss and data divergence

Discussion 0

Correct Answer: C Vote an answer

Question #44

Oracle Enterprise Manage (OEM) can generate database reports. Which statement about this feature is true?

A. Report generation is scheduled in the job system.

B. The report is placed in a table for suitable selects.

C. Generating reports requires a repository.

D. The reports are in HTML format for viewing in a browser.

Discussion 0

Correct Answer: D Vote an answer

Question #45

Which two statements are true? (Choose two.)

A. Composite partitioning provides high performance and manageability, like range partitioning.

B. Composite partitioning is ideal for both historical data and data placement.

C. Composite partitioning enables you to prevent partition elimination.

D. Composite partitioning supports hash partitioned global indexes.

Discussion 0

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