Braindumps: Dumps for 1Z0-032 Exam Brain Dump

Braindumps for "1Z0-032" Exam

Oracle9i Database: Fundamentals II 1Z0-032

Section A

Question 1.
When performing incomplete recovery using UNTIL SEQUENCE with RMAN, which two pieces of information are required? (Choose two)

A. Thread number.
B. Log Sequence number.
C. Control file sequence number.
D. Name of the last archived log.

Answer: A & C

Explanation:
Thread number and control file sequence number are required to perform incomplete recovery using UNTIL SEQUENCE option with RMAN. The syntax of command is:

RECOVER DATABASE UNTIL SEQUENCE sequence_number THREAD tread_number;

Log sequence number is not required to perform this type of incomplete recovery.

You don’t need the name of the last archive log to do that.

Reference:
OCP Oracle9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 363-366
Chapter 15: RMAN Incomplete Recovery

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

A. Bitmap indexes.
B. Reverse key indexes.
C. Function-based indexes.
D. Key-compressed indexes on regular tables.
E. Key-compressed indexes on IOT (including secondary indexes)

Answer: B, C, D & E

Explanation:
It’s possible to rebuild reverse key, function-based, key-compressed indexes on regular tables and on IOT (including secondary indexes).

Oracle9i does not currently support online index rebuilding for bitmap or partitioned local and global indexes.

Reference:
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 74-83
Chapter 2: Availability Enhancements
Oracle 9i New Features, Robert Freeman, p. 46-53
Chapter 2: Oracle9i Architecture Changes

Question 3.
Examine the list of variables and their data types:

NAME DATA Type
TS, TS1 TIMESTAMP
TSZ TIMESTAMP WITH TIME ZONE
TLZ TIMESTAMP WITH LOCAL TIME ZONE
IYM INTERVAL YEAR TO MONTH
IDS, IDSI INTERVAL YEAR To SECOND

Which three expressions using the new data and time data types are valid? (Choose three)

A. IDS* 2
B. TS + IYM
C. TS –TSI
D. IDS – TS
E. IDS + IYM

Answer: A, B & E

Explanation:
IDS*2, TS+IYM and IDS+IYM are valid new date and time data types.

You cannot subtract timestamps. Also it is not possible to subtract timestamp from the interval day to second.

Reference:
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 266-271
Chapter 5: Language Enhancements
Oracle 9i New Features, Robert Freeman, p. 132-135
Chapter 5: Miscellaneous Oracle9i Features and Enhancements

Question 4.
Consider the following statement:

SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_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 regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.
C. The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema.
D. 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.

Answer: C

Explanation:
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.
The Oracle server does not create a new histogram based on existing histogram.
Histogram creation is not regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.
The Oracle server creates a histogram not only based on application usage, but based on data distribution also.

Reference:
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 220-222
Chapter 4: Performance and Scalability Enhancements
Oracle 9i New Features, Robert Freeman, p. 180-181
Chapter 6: Oracle9i SQL, PL/SQL New Features

Question 5.
Which two are true regarding external tables? (Choose two)

A. External tables can be updated.
B. External tables are read-only tables.
C. Indexes can be created on external tables.
D. Indexes cannot be created on external tables.

Answer: B & D

Explanation:
External tables are read-only tables whose data resides in an external OS flat file, and whose definition is stored inside the database. Indexes cannot be created on external tables.
External tables cannot be updated. They are read-only tables.

Indexes cannot be created on external tables.

Reference:
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 131-134
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 111-116
Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features

Question 6.
When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view?

A. During a query’s parse time only.
B. During a query’s execution time only.
C. During any kind of DML statement execution.
D. During the execution of an INSERT statement only.

Answer: A

Explanation:
During a query's parse time Oracle9i flags an index as being used in the V$OBJECT_USAGE view. You can query the V$OBJECT_USAGE view to review the index utilization data. If the index has been used within the period of time it was monitored, the USED column within this view will contain a YES value; it will contain a NO otherwise.

During a query's execution time Oracle9i does not flag an index as being used in the V$OBJECT_USAGE view.

Oracle9i flags an index as being used in the V$OBJECT_USAGE view during a query's parse time, not during any kind of DML statement execution.

Oracle9i flags an index as being used in the V$OBJECT_USAGE view during a query's parse time, not during execution of an INSERT statement.

Reference:
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 212-214
Chapter 4: Performance and Scalability Enhancements
Oracle 9i New Features, Robert Freeman, p. 56-57
Chapter 2: Oracle9i Architecture Changes

Question 7.
Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automaticsegment- space managed objects? (Choose three)

A. It readily responds to dynamic changes for concurrent access.
B. It improves performance and space utilization in a multiple-instance environment.
C. It requires fewer space related options then freelist managed structures.
D. It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.

Answer: A, B, D

Explanation:
Managing space with automatic segment-space managed objects can respond to dynamic changes for concurrent access, improves performance and space utilization in a multi-instance environment and improves performance for SYSTEM table spaces where a high degree of concurrency is required.

Incorrect Answers
C: It requires more space related options than free list managed structures.

Reference:
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 138-140
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 53-54
Chapter 2: Oracle9i Architecture Changes

Question 8.
The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan?

A. ALTER TABLE employees monitor index employee_idx_fk;
B. ALTER INDEX employee_idx_fk monitoring on;
C. ALTER TABLE employees monitor all indexes;
D. ALTER INDEX employee_idx_fk monitoring usage;

Answer: D

Explanation:
This statement provides correct syntax to start monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan.

This command requires MONITORING USAGE clause with ALTER INDEX command to be used, not MONITOR INDEX clause with ALTER TABLE command.

This command requires MONITORING USAGE clause to be used, not MONITORING ON clause.

This command requires MONITORING USAGE clause with ALTER INDEX command to be used, not MONITOR ALL INDEXES clause with ALTER TABLE command.

Question 9.
You can control instance recover performance by setting parameters to define targets for ______.

A. The size of the redo buffer in SGA.
B. The instance that will perform recovery in Real Application Cluster database.
C. The number of blocks to be read during instance recovery, or the time needed to complete instance recovery.
D. The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.

Answer: C

Explanation:
Oracle9i added the FAST_START_MTTR_TARGET parameter to define targets for the number of blocks to be read during instance recovery, or the time needed to complete instance recovery. Oracle internally uses the FAST_START_MTTR_TARGET parameter value to calculate and set the FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL parameters. If you specified the FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL parameter values, they will override the values Oracle calculates from the FAST_START_MTTR_TARGET parameter.

You cannot control instance recovery performance by setting parameters to define targets for the size of the redo buffer in the SGA

It’s not possible to control instance recovery performance for the instance that will perform recovery in a Real Application Clusters database.

The number of passes through the redo logs made by the recovery process to identify blocks needing recovery will not help to control instance recovery performance.

Reference:
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 42-45
Chapter 2: Availability Enhancements
Oracle 9i New Features, Robert Freeman, p. 73-75
Chapter 3: New Oracle9i Availability and Recoverability Features

Question 10.
Which three statements are true about the privileged connection options available in Oracle9i? (Choose three)

A. The CONNECT INTERNAL is disallowed.
B. The Server Manager tool is no longer supplied.
C. The listener must be running to make a connection.
D. The use of remote password login file (orapw) is unchanged.

Answer: A, B & C

Explanation:
The CONNECT INTERNAL is disallowed in Oracle9i. The Server Manager tool is no longer supplied also. And the listener must be running to make a connection.

The use of a remote password login file (orapw) is changed in Oracle9i.

Reference:
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 5-10
Chapter 1: Security Enhancements
Oracle 9i New Features, Robert Freeman, p. 132-135
Chapter 5: Miscellaneous Oracle9i Features and Enhancements