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

Which two are true regarding a list-partitioned table? (Choose two.)

A. The keyword MAXVALUE can be specified as a partition literal value for one partition of a list-partitioned table.

B. It is NOT possible to have multiple columns as the partition key of a list-partitioned table.

C. The keyword NULL can be specified as a partition literal value for one partition of a list-partitioned table.

D. It is possible to partition an index-organized table using the LIST method.

Discussion 0

Correct Answer: B,C Vote an answer

Question #47

What statement is true about taking a database default temporary tablespace offline?

A. You must ensure that all users are assigned to an alternative temporary tablespace first.

B. You must first ensure that the default temporary tablespace has the permanent tablespace characteristic.

C. You cannot take a default temporary tablespace offline.

D. The database must be quiesced before you perform this action.

Discussion 0

Correct Answer: C Vote an answer

Question #48

Which two are true regarding automatic space management segments? (Choose two.)

A. You can create an automatic space management segment only in a locally managed tablespace.

B. You can successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment.

C. You can create an automatic space management segment in a dictionary-managed tablespace.

D. You CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment.

Discussion 0

Correct Answer: A,D Vote an answer

Question #49

In which tablespace are temporary LOBs stored?

A. in the user's default tablespace

B. any tablespace depending on the temporary LOBs' definition

C. in the user's temporary tablespace

D. in the SYSTEM tablespace

Discussion 0

Correct Answer: C Vote an answer

Question #50

Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature? (Choose three.)

A. SWITCH_ESTIMATE

B. MAX_SESS_POOL

C. SWITCH_TIME

D. SWITCH_GROUP

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #51

Which statement is true when using the DBVERIFY utility to detect corruptions in an Oracle data block?

A. The utility can be used with the database shut down.

B. The utility can cause contention in the shared pool when there is high activity in the database.

C. The utility is useful only when the database is in ARCHIVELOG mode.

D. The utility can be used to verify redo-log files for corruption.

Discussion 0

Correct Answer: A Vote an answer

Question #52

Your present networking environment is set up to run TCP/IP. In addition, you have hundreds of concurrent users accessing a single server. Which Oracle networking solution can you use to manage this environment using the multiplexing technique?

A. Connection Manager

B. Security Server

C. Net8

D. Open Gateway

E. Advanced Networking Option

F. Oracle Names

Discussion 0

Correct Answer: A Vote an answer

Question #53

Click the Exhibit button.
Given the partition definition, which insert statement will fail?

A. insert into sales(year,month,day) values (2000,02,33);

B. insert into sales(year,month,day) values (2000,01,01);

C. insert into sales(year,month,day) values (2000,01,17);

D. insert into sales(year,month,day) values (2000,03,32);

Discussion 0

Correct Answer: D Vote an answer

Question #54

Which password resource type needs to be set to enable the lifetime of the password?

A. PASSWORD_VERIFY_FUNCTION

B. PASSWORD_LIFE_TIME

C. FAILED_LOGIN_ATTEMPTS

D. PASSWORD_LOCK_TIME

Discussion 0

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