Oracle 1z0-032: Oracle 9i Database Fundamentals-II #4

QUESTION NO: 16

What is the new Oracle Shared Server?
A. An improved version of multithreaded server configuration.
B. A connection pooling configuration where several clients are connected to the same server process.
C. Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected.
D. A configuration of Real Application Cluster where the client connection is routed to the least busy instance.

Answer: A

Explanation:

Oracle Shared Server is an improved version of multithreaded server configuration.

Incorrect Answers
B: Oracle Shared Server does not provide configuration where several clients are connected to the same server process.
C: Oracle Shared Server does not include two or more database servers, which share data by means of database links.
D: Oracle Shared Server is not a configuration of Real Application Clusters where the client connection is routed to the least busy instance.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 144-152
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 59-60
Chapter 2: Oracle9i Architecture Changes

QUESTION NO: 17

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

QUESTION NO: 18

You are attempting to create an Oracle-Managed Files (OMF) tablespace in a production database with the following statement and receive the following error message:

CREATE TABLESPACE tbsl;

ORA-02199: missing DATAFILE/TEMPFILE clause
oerr ora 2199 02199, 00000, “missing DATAFILE/TEMPFILE clause”

*Cause: A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause.
*Action: specify DATAFILE/TEMPFILE clause.

What is the corrective action to create the OMF based tablespace?
A. Issue the CREATE TABLESPACE tbsl DATAFILE SIZE 10M; command.
B. Issue the CREATE TABLESPACE tbsl EXTENT MANAGEMENT ORACLE; command.
C. Set the db_create_file_dest parameter using the ALTER SESSION command and reissue the statement.
D. An OMF tablespace is now allowed; only control files and/or redo log files can be created by OMF.

Answer: C

Explanation:

You can set the DB_CREATE_FILE_DEST parameter using the ALTER SESSION command and re-issue the statement. You should define directories for OMF datafiles, redo log files and control files. Oracle9i gives you two new initialization parameters, DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n, to specify the location where Oracle will create and manage OMFs; n can take a value from 1 to 5.

Incorrect Answers

A: This command will not fix the problem.
B: There is no EXTENT MANAGEMENT ORACLE option in the CREATE TABLESPACE command.
D: An OMF tablespace is allowed; datafiles, control files and redo log files can be created by OMF.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-160
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 2-12
Chapter 1: Oracle9i Database Administration and Management Features

QUESTION NO: 19

Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?

A. Data blocks have to be written more frequently by DBWR.
B. Redo blocks have to be written more frequently by LGWR.
C. You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records.
D. You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.

Answer: A

Explanation:

If you set a value for the FAST_START_MTTR_TARGET too low DBWR will write the data blocks more frequently to reduce recovery time in accordance with the FAST_START_MTTR_TARGET parameter. It can cause the overall database performance degradation.

Incorrect Answers

B: It will not make LGWR to write redo blocks more frequently: data blocks will be written more frequently by DBWR.
C: You don’t need to substantially increase the size of your database buffer cache to hold the additional checkpoint records.
D: You don’t need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.

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 NO: 20

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

A. It can contain parameters with distinct values for each distance.
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