New Features for Administrators - Question 097

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

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

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. The keyword MAXVALUE can be specified as a partition literal value for one partition of a list-partitioned table.

Answer: B, C

Explanation:

It is NOT possible to have multiple columns as the partition key of a list-partitioned table. It’s possible to specify the keyword NULL as a partition literal value for one partition of a list-partitioned table: the set of values that specifies a partition cannot be empty; it must contain at least one value.

Incorrect Answers

A: List partitioning is supported for heap tables only. IOTs do not support this feature.

D: You cannot specify MAXVALUE. You can specify a NULL value.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 134-136 Chapter 3: Manageability Enhancements

Oracle 9i New Features, Robert Freeman, p. 102-107 Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features

New Features for Administrators - Question 096

What is required for the Character Set Scanner to operate?

A. Oracle Enterprise Manager

B. A special schema installed with csminst.sql

C. A separate tablespace called csscan to store the results

D. A GUI capable workstation, because it uses a Java interface

Answer: D

Explanation:

A GUI capable workstation is required for the Character Set Scanner to operate.

Incorrect Answers

A: Oracle Enterprise Manager is not required for the Character Set Scanner utility.

B: The Character Set Scanner does not require a special schema installed with csminst.sql.

C: The Character Set Scanner does not require a separate tablespace called csscan to store the results.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 273-275 Chapter 5: Language Enhancements

Oracle 9i New Features, Robert Freeman, p. 141 Chapter 5: Miscellaneous Oracle9i Features and Enhancements

New Features for Administrators - Question 095

What is true regarding a shared, server-side parameter file for a Real Application Clusters database?

A. It can contain parameters with distinct values for each instance.

B. It can contain only parameters with identical values for each instance.

C. It must contain an IFILE parameter for each instance's individual parameter file.

D. It must be located in the default location for the primary instance's parameter file.

Answer: A

Explanation:

The server-side parameter file for a Real Application Clusters database can contain parameters with distinct values for each instance.

Incorrect Answers

B: It can contain not only parameters with identical values for each instance, but distinct values for each instance.

C: It is not required that it must contain an IFILE parameter for each instance's individual parameter file. It needs to be done when the DBA stores the common parameters in one file and references that common file in each instance by using the IFILE initialization parameter.

D: It can be not located in the default location for the primary instance's parameter file.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 227-230 Chapter 4: Performance and Scalability Enhancements

Oracle 9i New Features, Robert Freeman, p. 188-192 Chapter 7: Oracle9i Real Application Clusters

New Features for Administrators - Question 094

What does the Character Set Scanner command line utility do?

A. Reports only on any Unicode character conversions required

B. Performs character set conversions to the new specified character set

C. Scans on any character set conversion required, then converts the data

D. Checks for any character definitions that will fail conversion to the new character set

Answer: D

Explanation:

Oracle9i provides you with the Character Set Scanner (csscan) utility that scans the data to discover potential problems with character set migrations. The scanner verifies the following: that the data in the target database can fit into the column’s data size, that the data in the source can be mapped without being replaced in the target database, that the data can be correctly converted particularly when dealing with differences in byte sizes and fixed/variable byte encoding systems.

Incorrect Answers

A: It does not report only on any Unicode character conversions required.

B: The Character Set Scanner does not perform character set conversions to the new specified character set.

C: It does not convert the data, only scans it.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 273-275 Chapter 5: Language Enhancements

Oracle 9i New Features, Robert Freeman, p. 141 Chapter 5: Miscellaneous Oracle9i Features and Enhancements

New Features for Administrators - Question 093

An index-organized table (IOT) called SPARSE has had many records deleted.

Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?

A. EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.

B. ALTER TABLE _ COALESCE ;

C. ALTER INDEX _ REBUILD ONLINE ;

D. CREATE TABLE _ AS SELECT _ ONLINE;

Answer: B

Explanation:

The ALTER TABLE table_name COALESCE statement will reorganize the IOT. The rebuild operation creates a new tree to defragment the index, as opposed to the coalesce operation that coalesces the leaf blocks within the same branch of the tree.

Incorrect Answers

A: You cannot do this using EXPORT and IMPORT with specified options. There is no INDEX option in EXPORT utility. Only INDEXES option exists.

C: This command can be used to rebuild the secondary index of IOT only.

D: This command is incorrect: you cannot use the ONLINE option that way.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 76-78 Chapter 2: Availability Enhancements

Oracle 9i New Features, Robert Freeman, p. 46-53 Chapter 2: Oracle9i Architecture Changes

New Features for Administrators - Question 092

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

Answer: C

Explanation:

The failure resolution policy specifies what should happen on the primary database if all the standby databases ion the configuration are unable to archive the redo logs. To specify guaranteed protection, you must establish the PROTECTED mode for the primary database. The PROTECTED mode will establish a zero divergence and zero data loss configuration.

Incorrect Answers

A: The standby database is not protected against write operations by this operation. The standby database can be mounted for recovery or open as read-only database.

B: The primary database is not protected against write operations.

D: The primary, not standby, database is protected against data loss and data divergence.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 64-72 Chapter 2: Availability Enhancements

Oracle 9i New Features, Robert Freeman, p. 86-99 Chapter 3: New Oracle9i Availability and Recoverability Features

New Features for Administrators - Question 091

Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table.

Which two steps are you recommended to do prior to issuing the dbms_redefinition_start_redef table procedure call? (Choose two).

A. Grant privileges on the interim table

B. Invoke the dbms_redefinition.can_redef_table procedure

C. Invoke the dbms_redefinition.sync_interim_table procedure

D. Create any triggers, indexes, or constraints on the interim table

E. Create an empty interim table with all the desired characteristics

Answer: B, E

Explanation:

Before the issuing the dbms_redefinition_start_redef table procedure call it’s recommended to invoke the dbms_redefinition.can_redef_table procedure and create an empty interim table with all the desired characteristics. Dbms_redefinition_start_redef procedure verifies that the table can be redefined online.

Incorrect Answers

A: You don’t need to grant privileges on the interim table.

C: It is recommended to periodically synchronize the interim table with the source one when a large amount of DML is executed on the table while the re-organization is taking place by calling the dbms_redefinition.sync_interim_table() procedure. But this step is not required.

D: You don’t need to create any triggers, indexes, or constraints on the interim table.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 78-80 Chapter 2: Availability Enhancements

Oracle 9i New Features, Robert Freeman, p. 46-53 Chapter 2: Oracle9i Architecture Changes