1Z0-043记录(一)

1、You have set some of the initialization parameters as:

DB_BLOCK_SIZE = 8KB

SGA_MAX_SIZE = 2GB

SGA_TARGET = 0

SHARED_POOL_SIZE = 120MB

DB_CACHE_SIZE = 896MB

STREAM_POOL_SIZE = 0

LARGE_POOL_SIZE = 110 MB

Which two statements are correct? (Choose two.)

A. You cannot set a value for the DB_8K_CACHE_SIZE parameter.

B. If you increase the size of the large pool to 120 MB, then the memory allocated to the shared poll will be reduced to 110 MB.

C. If the value for SGA_TARGET is changed to 1 GB and SHARED_POOL_SIZE is set to 120 MB, then memory cannot be taken from the shared pool, even if the shared pool has free space available.

D. If an application attempts to allocate more than 120 MB from the shared pool and free space is available in the buffer pool, then the free space from the buffer pool is allocated to the shared pool.

Editor’s notes:Why answer A is right?

DB_nK_CACHE_SIZE (where n = 2, 4, 8, 16, 32) specifies the size of the cache for the nK buffers. You can set this parameter only when DB_BLOCK_SIZE has a value other than nK. For example, if DB_BLOCK_SIZE=4096, then it is illegal to specify the parameter DB_4K_CACHE_SIZE (because the size for the 4 KB block cache is already specified by DB_CACHE_SIZE).

Do not set this parameter to zero if there are any online tablespaces with an nK block size.

Operating system-specific block size restrictions apply. For example, you cannot set DB_32K_CACHE_SIZE if the operating system's maximum block size is less than 32 KB. Also, you cannot set DB_2K_CACHE_SIZE if the minimum block size is greater than 2 KB.

 

2、You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario? (Choose two.)

A. You must ensure that the SALES database is mounted or open.

B. You must restore a backup control file to perform. a block media recovery.

C. You must take the tools01.dbf data file offline before you start a block media recovery.

D. You must put the database in NOARCHIVELOG mode to perform. a block media recovery.

E. You can perform. only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.

Editor’s notes:See for block media recovery.

One advance of the block media recovery is that the datafile could not be set offlin and the recovery time is short

The syntax of the block media recovery is that:

For example, you may discover the following messages in a user trace file:

ORA-01578: ORACLE data block corrupted (file # 7, block # 3)

ORA-01110: data file 7: '/oracle/oradata/trgt/tools01.dbf'

ORA-01578: ORACLE data block corrupted (file # 2, block # 235)

ORA-01110: data file 2: '/oracle/oradata/trgt/undotbs01.dbf'

You can then specify the corrupt blocks in the BLOCKRECOVER command as follows:

BLOCKRECOVER

DATAFILE 7 BLOCK 3

DATAFILE 2 BLOCK 235;

 

3、You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?

A. You do not need to restore all the data files.

B. You do not need to open the database with the RESETLOGS operation

C. You do not need to perform. a full backup after the RESETLOGS operation.

D. You do not need to recover all the data files to the same system change number (SCN).

Editor’s notes:

Because the database will not apply an archived log to a datafile unless the RESETLOGS SCN and time stamps match, the RESETLOGS prevents you from corrupting datafiles with archived logs that are not from direct parent incarnations of the current incarnation.

In prior releases, it was recommended that you back up the database immediately after the RESETLOGS. Because you can now easily recover a pre-RESETLOGS backup like any other backup, making a new database backup is optional. In order to perform. recovery through resetlogs you must have all archived logs generated since the last backup and at least one control file (current, backup, or created).

If you want to recover the database to prior time of resetlogs,you must change the incarnation when you recover.This is what we talk about “though incarnation recover”.But,it’s still a good idea to make a backup after you resetlogs.

 

4、Exhibit

View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting? (Choose two.)

A. The members of LOW_GROUP would get more priority than those of OTHER_GROUPS.

B. The members of SYS_GROUP would get most of the CPU allocation at level 1.

C. The members of LOW_GROUP would get most of the CPU allocation because it has CPU allocation at two different levels.

D. The members of LOW_GROUP would get no CPU allocation at level1 if the members of OTHER_GROUPS are using all the CPU at level 2.

E. The members of SYS_GROUP would get no CPU allocation at level 1 if the members of OTHER_GROUPS are using all the CPU at level 2.

Editor’s notes:You can see the deail contents in <10G OCP官方教材043.pdf>.But,the knowledge of the managing resource is not so popular.so,just see see.

 

5、The current time zone for one of the user sessions is set to the database local time zone. For one application, the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective? (Choose two.)

A. use the ALTER SYSTEM command to change the time zone

B. use the ALTER SESSION command to change the time zone

C. use the ALTER DATABASE command to change the time zone

D. set the value for the operating system variable ORA_SDTZ on the client machine

E. set the value for the operating system variable ORA_SDTZ on the database server machine

Editor’s notes:

Configuring the Database Local Timezone

You can use the TIME_ZONE parameter to change the default timezone for your session. Use the ALTER SESSION SET time_zone command, and supply one of the following values:

Absolute offset: [+ | -] hh:mm

Timezone region: The desired timezone specified by name instead of using an offset.

·LOCAL: The operating system local timezone

·DBTIMEZONE: The database local timezone

ORA_SDTZ is an operating system environment variable which may be used to set the default time zone for a session. It may be set to:

Absolute offset or timezone region

·OS_TZ: The operating system local timezone

·DB_TZ: The database local timezone

You can specify a region or absolute offset for the timezone of the database, either during database creation or later, using an ALTER DATABASE command. The database time zone is only relevant for TIMESTAMP WITH LOCAL TIME ZONE columns. If you do not specify a timezone when creating the database, the operating system's timezone offset is used. If you alter the timezone for a database after the database has been created, you must shutdown and restart the instance for the change to take effect.

 

6、You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)

A. Flashback logs are not archived.

B. Flashback logs are maintained in redo log files.

C. Flashback logs are maintained in the Flash Recovery Area.

D. Flashback logs are used to maintain Flashback Database related errors.

E. Flashback logs need to be cleared manually after you disable Flashback Database

Editor’s notes:I am just not sure that flashback logs can be deleted after you disable the flashback database.

Configuring Flashback Database

You can configure Flashback Database as follows:

1. Configure the flash recovery area.

2. Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter. You can specify an upper limit, in minutes, on how far back you want to be able to flash back the database. The example uses 2880 minutes which is equivalent to two days. This parameter is only a target and does not provide any guarantee. Your flashback time interval depends on how much flashback data has been kept in the flash recovery area.

3. Enable Flashback Database with the following command:

ALTER DATABASE FLASHBACK ON;

Before you can issue the command to enable Flashback Database, the database must be configured for archiving and started in MOUNT EXCLUSIVE mode. You can determine whether Flashback Database is enabled with the following query:

SELECT flashback_on FROM v$database;

You can disable Flashback Database with the ALTER DATABASE FLASHBACK OFF command. As a result, all existing Flashback Database logs are deleted automatically.

 

7、You executed the following query:

SELECT operation, undo_sql, table_name

FROM flashback_transaction_query;

Which statement is correct regarding the query output?

A. It would return information regarding only the last committed transaction.

B. It would return only the active transactions in all the undo segments in the database.

C. It would return only the committed transactions in all the undo segments in the database.

D. It would return both active and committed transactions in all the undo segments in the database.

E. It would return information regarding the transactions that began and were committed in the last 30 minutes.

Editos’s notes:

FLASHBACK_TRANSACTION_QUERY displays information about all flashback transaction queries in the database.

I think about that uncommited data may be in this views

 

8、Consider the following configuration:

/devices/D1is a member of disk group dgroupA.

/devices/D2is a member of disk group dgroupA.

/devices/D3is a member of disk group dgroupA.

You plan to add a new disk, /devices/D4,to the disk group dgroupA.

You execute the following command:

SQL> ALTER DISKGROUP dgroupA ADD DISK '/devices/D*';Which task would be accomplished by the command:

A. The command adds the new disk, D4, to the disk group.

B. The command would result in an error because the is no disk by the name "'/devices/D*'"

C. The command will be ignored because disks starting with "D" are already members of the disk group.

D. The command would result in an error because no wildcard characters can be used in the disk name.

E. The command first detaches all the member disks starting with "D", and the reattaches them including the new disk.

Editor’s notes:

/devices/A1 is a member of disk group DGROUPA.

/devices/A2 is a member of disk group DGROUPA.

/devices/A3 is a member of disk group DGROUPA.

/devices/A4 is a candidate disk.

So,if you execute the command above,oracle will add a member automaticly.

Reblance is automatically done as disks are added, dropped, or resized

 

9、Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management (ASM) instance, you find that the performance of the database decreases initially, until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform. to maintain a consistent performance of the database while adding or removing disks? (Choose two.)

A. increase the number of checkpoint processes

B. define the POWER option while adding or removing the disks

C. increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES

D. increase the number of slave database writer processes by setting up a higher value forDBWR_IO_SLAVES

E. increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal

Editor’s notes：

ASM_POWER_LIMIT controls the speed for a rebalance operation. Values range from1 to 11, with 11 being the fastest. If omitted, this value defaults to 1. The number of slaves is derived from the parallelization level specified in a manual rebalance command (POWER), or by the ASM_POWER_LIMIT parameter.

ALTER DISKGROUP dgroupB REBALANCE POWER 5;

 

10、You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1and DG2 with one device each. In the parameter file of the production database, the following parameters have been specified:

DB_CREATE_ONLINE_LOG_DEST_1 = '+dg1'

DB_CREATE_ONLINE_LOG_DEST_2 = '+dg2'

What would be the impact of this setting?

A. When a new log group is added, it would have one member in each disk group.

B. When a new log group is added, it would have two members in each disk group.

C. When a new tablespace is added, it would have one data file in each disk group.

D. When a new log file is added, it would have one member spread across the disk groups.

Editor’s notes:

DB_CREATE_ONLINE_LOG_DEST_n (where n = 1, 2, 3, ... 5) specifies the default location for Oracle-managed control files and online redo logs. If more than one DB_CREATE_ONLINE_LOG_DEST_n parameter is specified, then the control file or online redo log is multiplexed across the locations of the other DB_CREATE_ONLINE_LOG_DEST_n parameters. One member of each online redo log is created in each location, and one control file is created in each location.

Specifying at least two parameters provides greater fault tolerance for the control files and online redo logs if one of the locations should fail.

If a file system directory is specified as the default location, then the directory must already exist; Oracle does not create it. The directory must have appropriate permissions that allow Oracle to create files in it. Oracle generates unique names for the files, and a file thus created is an Oracle-managed file.

 

11、While creating a job class using the DBMS_SCHEDULERpackage, you set the logging level to LOGGING_RUNS. What would be the impact of this setting?

A. Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.

B. Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.

C. Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.

D. Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.

Editor’s notes:

Job Logging

By default, all job runs are logged. However, when creating a new class, you can specify parameters that further control what information is logged and how long the logging information is retained. The logging_level parameter for a class can be set to one of the following constant values of the DBMS_SCHEDULER package:

·LOGGING_OFF: No logging is performed for any jobs in this class.

·LOGGING_RUNS: The scheduler writes detailed information to the job log for each run of

each job in this class.

·LOGGING_FULL: Besides recording every run in the job log, the scheduler also logs all other operations performed on all jobs in this class, such as creating new jobs, enabling or disabling jobs, and so on.

The DBA_SCHEDULER_JOB_LOG view stores a row for each job operation logged.

The log_history parameter specifies how many days a log entry remains in the log before it is eligible for purging.

A PURGE_LOG job is created automatically. This job clears out old log entries once a day. Log entries may also be cleared out manually by using the DBMS_SCHEDULER.PURGE_LOG procedure.

 

12、You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls, listed in chronological order. Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?

A. create a hash cluster to store the data

B. create an index cluster to store the data

C. create a partitioned table to store the data

D. create a sorted hash cluster to store the data

E. create a heap table with rowid to store the data

Editor’s notes:There are three cluster types:index cluster/hash cluster/sort hash cluster.how can these cluster types be uesd?

Web site associate:

http://www.itpub.net/viewthread.php?tid=442689&highlight=Index%2BCluster

http://www.itpub.net/viewthread.php?tid=138815&highlight=index%2Bcluster

 

13、You set the recovery window to seven days and the backup optimization to ON using the CONFIGUREcommand of Recovery Manager (RMAN). The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only. On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLStablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace, you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting?

A. configure a default device for RMAN backups

B. temporarily disable the retention policy for RMAN backups

C. configure automatic channel allocation for RMAN backups

D. use the CONFIGURE command to reconfigure the recovery window to 60 days

Editor’s notes:

Backup Optimization When Backing Up Backup Sets If backup optimization is enabled when you issue the command to back up a backup set, and if the identical backup set has already been backed up to the same device type, then RMAN skips the backup of this backup set. For example, when backup optimization is turned on, the following command backs up to tape only those backup sets not already backed up on device type sbt:

BACKUP DEVICE TYPE sbt BACKUPSET ALL;

 

14、Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived and it contained information from 10:35 a.m. onwards. The current time is 11:00 a.m. Because of a disk crash, you executed the following command to perform. an incomplete recovery:

RMAN> RUN {

2> SET UNTIL SEQUENCE 230 THREAD 1;

3> ALTER DATABASE MOUNT;

4> RESTORE DATABASE;

5> RECOVER DATABASE;

6> ALTER DATABASE OPEN RESETLOGS;

7> };

With reference to this scenario, which statement is true?

A. RMAN recovers up to log sequence 230, but not including 230.

B. RMAN returns an error because the log sequence number mentioned in the command should be 229.

C. RMAN returns an error because the log sequence number mentioned in the command may never be missing.

D. RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing

Editor’s notes:

With RMAN-managed backups you can specify the last log sequence number to be used for database recovery with the UNTIL SEQUENCE clause. Once all log files up to but not including the specified log file have been applied, recovery terminates.

Using the UNTIL CHANGE clause for user-managed backups and the UNTIL SCN clause for RMAN-managed backups, you specify the system change number (SCN) of the last committed change to be recovered. Recovery terminates after all changes up to the specified SCN are committed. Use this approach when recovering databases in a distributed environment.

 

15、In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using thefollowing command:

RMAN> RESTORE CONTROLFILE;

Which two operations do you need to perform. after restoring the control file from backup? (Choose two.)

A. shut down and restart the instance

B. add new tempfiles to the temporary tablespaces after recovery

C. perform. a media recovery and open the database with the RESETLOGS option

D. perform. a media recovery and bring the database to NOARCHIVELOG mode

Editor’s notes:

If you have a recovery catalog, you do not have to set the DBID or use the control file autobackup to restore the control file. You can use the RESTORE CONTROLFILE command with no arguments:

RMAN> RESTORE CONTROLFILE;

The instance must be in NOMOUNT state when you perform. this operation, and RMAN must be connected to the recovery catalog. The restored control file will be written to all locations listed in the CONTROL_FILES initialization parameter.

If you have also lost the SPFILE for the database and need to restore it from the autobackup, the procedure is similar to restoring the control file from autobackup. You must first set the DBID for your database, and then use the RESTORE SPFILE FROM AUTOBACKUP command. After you have started the instance with the restored server parameter file, RMAN can restore the control file from the autobackup. After you restore and mount the control file, you have the backup information necessary to restore and recover the database.

Limitations of Restoring the Control File

·After restoring the control files of your database from backup, you must perform. complete media recovery and then open your database with the RESETLOGS option.

·After restoring a backup control file, entries for tempfiles in locally-managed temporary tablespaces are removed. Hence, you must add new tempfiles to these tablespaces after you OPEN RESETLOGS.

 

16、Exhibit

One of the important tables in the USERStablespace was dropped and purged from the recycle bin at 9:00 a.m. You noticed this at 11:00 a.m. and you want to perform. an incompleterecovery to recover the table. Which statement is true?

A. You must recover all data files to the required system change number (SCN).

B. You must recover all data files, except those that are offline, to the required SCN.

C. You must recover all data files belonging to the USERS tablespace to the required SCN.

D. You cannot recover all data files because segment space management is performed manually for the undo tablespace

Editor’s notes:

RMAN can perform. recovery of the database to a past time, SCN, or log sequence number. This is called incomplete recovery because it does not use all of the available redo. Incomplete database recovery is also called database point-in-time recovery (DBPITR).

Incomplete recovery of the database requires you to open the database with the RESETLOGS option. This option gives the online redo logs a new time stamp and SCN, thus eliminating the possibility of corrupting data files by the application of obsolete archived redo logs. You cannot recover some data files to a time before the RESETLOGS and others to a time after the RESETLOGS. You must recover all data files to the same SCN. The only exception is if the data file is offline normal or read-only. You can bring files in read-only or offline normal tablespaces online after the RESETLOGS because there are no transactional changes for these files stored in the redo logs.

Note: You can use RMAN to restore the data files only if the backups were taken or registered with RMAN.

Why answer C is wrong?

Compare whit DBPITR,there is TSPITR.TSPITR need a auxiliary instance. Recovers the restored datafiles in the auxiliary instance to the specified time

 

17、The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn writes?

A. The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.

B. The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.

C. The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.

D. The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.

E. The Oracle database will check data blocks in the SYSTEM and SYSAU tablespaces only, by going through the data on each block, making sure the data is self-consistent

Editor’s notes:

DB_BLOCK_CHECKING has four values showed like that: OFF | LOW | MEDIUM | FULL

Off will not check the data bolck,but system tablespace’s data block will always check.

Low will check the basic block header off all data block that changed in memory(eg. Update or insert).

Medium and full is check more than off.

 

 

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

转载于:http://blog.itpub.net/14730395/viewspace-673996/