转:1Z0-043记录(四)

43、You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database:

INSTANCE_TYPE = RDBMS

DB_NAME = PROD

LARGE_POOL_SIZE = 8MB

DB_BLOCK_SIZE = 4K

LOG_ARCHIVE_DEST = +dgroupA

LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"

DB_CREATE_FILE_DEST = +dgroupA

COMPATIBLE =10.1.0.2.0

CONTROL_FILES = +dgroupA

Which parameter would be ignored while starting up the instance for the database PROD?

A. LARGE_POOL_SIZE

B. DB_CREATE_FILE_DEST

C. LOG_ARCHIVE_DEST

D. CONTROL_FILES

E. LOG_ARCHIVE_FORMAT

F. DB_BLOCK_SIZE

Editor’s notes:

INSTANCE_TYPE defaults to RDBMS and specifies that this instance is an RDBMS instance. LOG_ARCHIVE_FORMAT is ignored if LOG_ARCHIVE_DEST is set to an incomplete ASM file name, such as +dGroupA. If LOG_ARCHIVE_DEST is set to an ASM directory (for example, +dGroupA/myarchlogdir/), then LOG_ARCHIVE_FORMAT is used and the files are non-OMF. Unique file names for archived logs are automatically created by the Oracle database.

The following parameters accept the multifile creation context form. of ASM file names as a destination:

•DB_CREATE_ONLINE_LOG_DEST_n

•DB_CREATE_FILE_DEST

•DB_RECOVERY_FILE_DEST

•CONTROL_FILES

•LOG_ARCHIVE_DEST_n

•LOG_ARCHIVE_DEST

•STANDBY_ARCHIVE_DEST

Note: Because extent maps for ASM files are allocated from the LARGE_POOL, you must set the LARGE_POOL_SIZE initialization parameter to at least 8 MB, preferably higher.

 

44、You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes? (Choose all that apply.)

A. SQL scripts

B. Recovery Manager (RMAN) script

C. Data Pump

D. SQL*Loader

E. Flashback database

Editor’s notes:

Flashback database cann’t be used for physical corruption.In this conditon, you must usetraditional recovery methods.

Flashback Database lets you quickly bring your database to a prior point in time by undoing all the changes that have taken place since that time. This operation is fast, because you do not need to restore the backups. You can use this feature to back out changes that have resulted in logical data corruptions.

 

45、In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups, DGROUP1, is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective:

DROP DISKGROUP dgroup1 EXCLUDING CONTENTS;

What would be the result of this command?

A. This command would result in an error because the disk group is not empty.

B. The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.

C. The command would result in the contents being moved to the parent disk group and dropping of the disk group.

D. The command would result in the disk group being marked as INVALID because it cannot be dropped.

E. The command would drop the disk group, ignoring the EXCLUDING CONTENTS option.

Editor’s notes:

I am not sure about the answer.the document of ASM is so little.what can I find is “including contents”.

you can delete a disk group along with all its files. To avoid accidental deletions, the INCLUDING CONTENTS option must be specified if the disk group still contains any files besides internal ASM metadata. The disk group must be mounted in order to drop it. After ensuring that none of the disk group files are open, the group and all its drives are removed from the disk group. Then the header of each disk is overwritten to eliminate the ASM formatting information.

 

46、View the Exhibit and examine the properties of the USERS tablespace.You execute the following statement to shrink the TRANS table existing on the USERS tablespace:

SQL> ALTER TABLE trans SHRINK SPACE CASCADE;

Which objects would be affected by this command? (Choose all that apply.)

Exhibit:

A. the materialized views based on the TRANS table

B. the materialized views log of the TRANS table

C. the TRANS table

D. the B*Tree indexes on the TRANS table

E. the large object (LOB) segments of the TRANS table

Editor’s notes:

The ALTER command is used to invoke segment shrink on an object. The object’s type can be one of the following: table (heap- or index-organized), partition, subpartition, index, materialized view, or materialized view log. The SHRINK SPACE clause is used to shrink space in a segment. If CASCADE is specified, the shrink behavior. is cascaded to all the dependent segments that support a shrink operation, except materialized views, LOB indexes, IOT mapping tables, and overflow segments.

During a shrink operation, you can indicate that only the compaction phase be executed by specifying the SHRINK SPACE COMPACT clause. If COMPACT is not specified, the segment space is compacted, and at the end of the compaction phase, the HWM is adjusted and the unused space is released.

 

47、Which two statements regarding compressed backups in Recovery Manager (RMAN) are true? (Choose two.)

A. Backup compression is disabled by default.

B. Backup compression can be used with both backup sets and image copies.

C. Backup compression cannot be enabled using the CONFIGURE command.

D. Backup compression works only if the COMPATIBILITY parameter is set to9.0.0.0 or higher.

E. Backup compression applies to only backup sets.

F. Backup compression applies to only image copies.

Editor’s notes:

Compressed backups reduce the amount of space required for storing backup sets. You create a compressed backup of a database by using the command:

RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;

The compressed backup set feature cannot be used with pre–Oracle Database10gdatabases. The COMPATIBILITY database initialization parameter must be set to at least10.0.0.0. The compression applies only to backup sets, not image copies.

You can configure RMAN to automatically make compressed backup sets with the CONFIGURE DEVICE TYPE command:

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2

2> BACKUP TYPE TO COMPRESSED BACKUPSET;

By default compression is disabled.

 

48、You executed the following FLASHBACK TABLE command:

FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi');

Which two statements are correct? (Choose two.)

A. The FLASHBACK TABLE statement will not be written to the alert log file.

B. The EMP table that was dropped by mistake from the database will be restored.

C. The changes made to the EMP table since the specified time will be undone.

D. The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.

E. The FLASHBACK TABLE statement will be executed within a single transaction.

F. The list of transactions that have modified the EMP table since the specified time will be displayed.

Editor’s notes:

Why flashback table must be executed within a single transaction?the answer is that:

A Flashback Table statement is executed as a single transaction. All tables must be flashed back successfully or the entire transaction is rolled back.

Note: You can use Flashback Versions Query and Flashback Transaction Query to determine the appropriate flashback time.

 

49、The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter(s) should be configured to perform. a transportable tablespace import?

A. DB_4K_CACHE_SIZE only

B. DB_8K_CACHE_SIZE only

C. DB_BLOCK_SIZE and DB_4K_CACHE_SIZE

D. DB_BLOCK_SIZE and DB_8K_CACHE_SIZE

E. SGA_TARGET and DB_4K_CACHE_SIZE

F. DB_CACHE_SIZE only

 

50、You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true? (Choose two.)

A. The member jobs would get dropped when the job class is dropped.

B. Both the jobs would be executed concurrently.

C. The member jobs would get disabled when the job class is dropped.

D. The attributes defined at the class level would be applied to both the jobs.

E. Jobs in the job class must have been assigned the same priority.

 

51、You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface:

SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP

(CONSUMER_GROUP =>'group1', COMMENT => 'New Group');

This command errors out displaying the following message:

ERROR at line 1:

ORA-29371: pending area is not active

ORA-06512: at "SYS.DBMS_RMIN", line 115

ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108

ORA-06512: at line 1

What action would you take to overcome this error?

A. activate the Pending Area before creating the consumer group

B. create the Pending Area before creating the consumer group

C. increase the size of the database buffer cache to accommodate the Pending Area

D. increase the size of the shared pool to accommodate the Pending Area

E. increase the size of the large pool to accommodate the Pending Area

Editor’s notes:

the difination of ora-29371 is that:

ORA-29371: pending area is not active

Cause: An attempt was made to make changes without creating a pending area.

Action: Invoke procedure CREATE_PENDING_AREA before making any changes.

 

52、You have a read-only tablespace on read-only media. You want to perform. a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?

A. take data files from the read-only tablespace offline before performing a recovery

B. recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the database

C. drop the read-only tablespace and re-create the tablespace after recovery

D. perform. a recovery; status of the tablespace in control file will be changed automatically

Editor’s notes:

If you have a read-only tablespace on read-only media, then you may encounter errors or poor performance when recovering with the USING BACKUP CONTROLFILE option.

This situation occurs when the backup control file indicates that a tablespace was read/write when the control file was backed up. In this case, media recovery may attempt to write to the files. For read-only media, the database issues an error saying that it cannot write to the files.

Following are alternatives you can use to recover read-only media when using a backup control file:

·Take data files from read-only tablespaces offline before doing recovery with a backup control file, and then bring the files online at the end of media recovery.

·Use the correct version of the control file for the recovery. If the tablespace will be readonly when recovery completes, then the control file backup must be from a time when the tablespace was read-only. Similarly, if the tablespace will be read/write at the end of recovery, then the control file must be from a time when the tablespace was read/write.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22598114/viewspace-677797/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22598114/viewspace-677797/