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

When querying the new v$spparameter view, the column ISSPECIFIED displays the value TRUE for a number of parameters. What does this mean?

A. The value for the parameters is TRUE.

B. The parameters are specified in the SPFILE parameter file.

C. The parameters are specified in the PFILE parameter file.

D. Changes to the parameter are only in the currently running instance.

Discussion 0

Correct Answer: B Vote an answer

Question #11

Which two factors can influence the time taken for instance recovery? (Choose two)

A. size of the redo log buffer

B. value of RECOVERY_PARALLELISM

C. size of the system tablespace

D. the number of archived redo logs that have to be read

E. the number of tables stored in the database buffer cache at the moment of failure

F. value of FAST_START_IO_TARGET

Discussion 0

Correct Answer: B,F Vote an answer

Question #12

What does fine-grained access enable you to do?

A. choose the schema in which a stored PL/SQL block will execute in

B. select how external object references are resolved in queries

C. associate policies with tables and views

D. select which user's privilege map is used during execution

Discussion 0

Correct Answer: C Vote an answer

Question #13

To assist you in migrating your existing LONG columns to LOB data types, the ALTER TABLE syntax has been enhanced to support LONG to CLOB migration and LONG RAW to BLOB migration.
During this migration, if redo logging is enabled for the table or for the LOB being created, the ALTER TABLE ?MODIFY command temporarily _____ the space requirements.

A. halves

B. quadruples

C. doubles

D. triples

Discussion 0

Correct Answer: C Vote an answer

Question #14

Consider the following statement:
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS (2> ownname => 'OE', 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, 4> method_opt => 'for all columns size AUTO');
What is the effect of 'for all columns size AUTO' of the METHOD_OPT option?

A. The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema.

B. The Oracle server creates a histogram based on data distribution and application usage of the column/s for all table, column, and index statistics for the OE schema.

C. The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

D. The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.

Discussion 0

Correct Answer: B Vote an answer

Question #15

What is true regarding fact tables having bitmap join indexes defined on them?

A. Tables participating in the join condition of the bitmap join index definition cannot be updated concurrently.

B. You can create a bitmap join index on a temporary table.

C. You can create a bitmap join index on an index-organized table.

D. You cannot have more than one dimension table being part of the join condition of a bitmap join index definition.

Discussion 0

Correct Answer: A Vote an answer

Question #16

What is the meaning of using "character semantics" to create a table?

A. You use only CHAR data types.

B. You use only character type data types (CHAR, NCHAR, VARCHAR2, NVARCHAR2, CLOB, NCLOB).

C. You use single letter names of all columns.

D. You specify the width of a column in characters, not in bytes.

E. All columns are a single character wide.

Discussion 0

Correct Answer: D Vote an answer

Question #17

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

A. allows you specify message grouping

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

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

D. allows you to specify multiple recipients for messages

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #18

Users complain that SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.
What is the least disruptive recovery strategy available in Oracle9i?

A. Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again.

B. Rebuild the index using the online option.

C. Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.

D. Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

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.