1Z0-043记录(三)

29、You have a disk group, DGROUP1, with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group:

ALTER DISKGROUP dgroup1

ADD TEMPLATE my_temp

ATTRIBUTES (MIRROR FINE);

Which statement is true?

A. When a file is created in DGROUP1 with the template, it would have three-way mirroring.

B. When a file is created in DGROUP1, the MY_TEMP template becomes the default template.

C. When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.

D. When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.

E. When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file striping.

Editor’s notes:

ASM file templates are named collections of attributes applied to files during file creation. Templates simplify file creation by mapping complex file-attribute specifications onto a single name. Templates, while applied to files, are associated with a disk group.

When a disk group is created, ASM establishes a set of initial system default templates associated with that disk group. These templates contain the default attributes for the various Oracle database file types. Attributes of the default templates may be changed by the administrator. Additionally, administrators may add their own unique templates as required. This enables you to specify the appropriate file creation attributes as a template for less sophisticated administrators to use. System default templates cannot be deleted.

 

30、You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this?

A. The index tablespace contains bitmap indexes.

B. The index tablespace contains more than one data file.

C. The index tablespace supports only complete recovery.

D. The index tablespace is not a dictionary-managed tablespace.

E. There is a dependency relationship between a table and its indexes.

 

31、For the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?

A. Set the CPU time per call in the users profile.

B. Set the CPU time per session in the users profile.

C. Set the CPU levels for the user's group using Resource Manager.

D. Set the TIMED_STATISTICS parameter to TRUE in the parameter file.

Editor’s notes:

What’s the diffference between cpu limitation of resource manager and cpu limitation of profile?

Cpu limitation of profile:

SESSION级LIMITE：

   CPU_PER_SESSION：定义了一个SESSION占用的CPU的时间（1/100 秒），当达到这个限制用户不能在此会话中执行任何操作，此时必须先断开连接，再连接才行。

   CPU_PER_CALL：限制每次调用SQL语句期间(parse、execute、fetch)可用的CPU时间总量，单位是百分之一秒。达到限制时语句以报错结束。不同于CPU_PER_SESSION的是，没达到CPU_PER_SESSION限制，还可以进行新的查询。

so,profile is limitation of time.

 

32、Exhibit:

View the Exhibit and examine the characteristic of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented. Which advisory component would you refer to, in order to find information about table fragmentation?

A. Memory Advisor

B. Segment Advisor

C. SLQ Tuning Advisor

D. SLQ Access Advisor

E. Automatic Database Diagnostic Monitor (ADDM)

Editor’s notes:

How to use segment advisor?

1．  You can use segment advisor on OEM

2．  You can use segment advisor manually.

3．  Oracle scheduler jobs will run the segment advisor like gathering statistics.you can see the dedail by querying dba_scheduler_jobs.

The example of using segment advisor manually:

dbms_advisor.create_task (

  advisor_name     => 'Segment Advisor',

  task_name        => 'Manual_T' );

 

dbms_advisor.create_object (

  task_name        => 'Manual_T',

  object_type      => 'TABLE',

  attr1            => user,

  attr2            => 'T',

  attr3            => NULL,

  attr4            => NULL,

  attr5            => NULL,

  object_id        => obj_id);

 

dbms_advisor.set_task_parameter(

  task_name        => 'Manual_T',

  parameter        => 'recommend_all',

  value            => 'TRUE');

 

dbms_advisor.execute_task('Manual_T');
web site associate:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2049277600346543592

http://www.remote-dba.net/t_advanced_segment_advisor.htm

http://warehouse.itpub.net/post/777/473414

 

33、You execute the following RMAN command in the order shown below:

BACKUP VALIDATE DATABASE;

BLOCKRECOVER CORRUPTION LIST;

What will these commands do?

A. Create a backup of the database and recover all corrupted blocks found in the backup.

B. Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.

C. Run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the view.

D. Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the view.

E. Run a backup validation, repair any corrupt blocks found during the validation process, and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

Editor’s notes:

You can use the VALIDATE option to check for physical and logical errors in database files. When using the BACKUP command with the VALIDATE option, RMAN scans the specified files and verifies their contents, testing whether this file can be backed up. This command does not actually backup up the specified files.

 

34、In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

Which two events would cause the control file to be backed up automatically? (Choose two)

A. A tablespace is taken offline.

B. The database instance is restarted.

C. A new data file is added to an existing tablespace.

D. A successful backup is recorded in the RMAN repository.

E. The RMAN connection is disconnected from the target database.

Editor’s notes:

By default, control file autobackups are turned off. If you enable control file autobackups, then RMAN automatically backs up the control file and the current server parameter file (if used to start up the database) in one of two circumstances:

·A successful backup must be recorded in the RMAN repository

·A structural change to the database affects the contents of the control file which therefore must be backed up

 

35、You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?

A. Use the CHANGE_PASSWORD command of the Listener control utility.

B. Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.

C. Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.

D. Manually modify the listener.ora file to include the password for the listener and restart the listener.

Editor’s notes:

The command of Set password must execute first when you  when you set the password for the listener. It is just like a passport.

Change_password is the command for changing or setting password.

In windows,the change_password commond may be not useful.it may be a bug..

Example:

LSNRCTL> stat

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production

Start Date                12-7月 -2010 08:50:19

Uptime                    69 days 7 hr. 6 min. 44 sec

Trace Level               off

Security                  ON

SNMP                      OFF

Listener Parameter File   /home/oracle/oracle92/network/admin/listener.ora

Listener Log File         /home/oracle/oracle92/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "zxin" has 2 instance(s).

  Instance "zxin", status UNKNOWN, has 1 handler(s) for this service...

  Instance "zxin", status READY, has 1 handler(s) for this service...

The command completed successfully

 

LSNRCTL> change_password

Old password:

New password: fztxttqh

Reenter new password: fztxttqh

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

Password changed for LISTENER

The command completed successfully

 

LSNRCTL> save_config

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

TNS-01169: The listener has not recognized the password

 

LSNRCTL> stat

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

TNS-01169: The listener has not recognized the password

 

LSNRCTL> set password    -----you must set password to get the passprot

Password: fztxttqh

The command completed successfully

 

LSNRCTL> save_config

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

Saved LISTENER configuration parameters.

Listener Parameter File   /home/oracle/oracle92/network/admin/listener.ora

Old Parameter File   /home/oracle/oracle92/network/admin/listener.bak

The command completed successfully

 

LSNRCTL> stat

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production

Start Date                12-7月 -2010 08:50:19

Uptime                    69 days 7 hr. 10 min. 53 sec

Trace Level               off

Security                  ON

SNMP                      OFF

Listener Parameter File   /home/oracle/oracle92/network/admin/listener.ora

Listener Log File         /home/oracle/oracle92/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "zxin" has 2 instance(s).

  Instance "zxin", status UNKNOWN, has 1 handler(s) for this service...

  Instance "zxin", status READY, has 1 handler(s) for this service...

The command completed successfully

 

36、Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table:

ERROR at line 1:

ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES

While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform. to overcome this error without affecting the queries that are currently being executed? (Choose two)

A. Drop and re-create the inbox.

B. Coalesce the ORDERS_IND index.

C. Coalesce the INDEXES tablespace.

D. Drop and re-create the ORDERS table.

E. Rebuild the index online and move it to another tablespace.

Editor’s notes:

Just think about why recreate index is not useful and why coalesce is usefull without changing tablesapce.

 

37、In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?

A. REBUILD

B. CASCADE

C. TRUNCATE

D. ROW MOVEMENT

E. SHRINK SPACE COMPACT

F. SHRINK SPACE CASCADE

Editor’s notes:

The difference between answer E and F is that:

Manual Segment Shrinking is done by the statement:

ALTER TABLE test SHRINK SPACE

You can shrink all the dependent segments as well:

ALTER TABLE test SHRINK SPACE CASCADE

To only compact the space in the segment:

ALTER TABLE test SHRINK SPACE COMPACT

Web site associated:

http://www.globusz.com/ebooks/Oracle/00000016.htm

http://hi.baidu.com/wschao2005/blog/item/aa79dba263f0d8a7cbefd0b9.html

 

38、You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?

A. The location used for control files.

B. The location used for redo log files.

C. The location set by using $ORACLE_BASE.

D. The location set by using $ORACLE_HOME.

E. The location set by using CORE_DUMP_DEST.

F. The location set by using BACKGROUND_DUMP_DEST.

Editor’s notes:

before you set the flashback log on ,you muse ensure the database is in archive mode.the location of flashback log is in the flash recover area. flashback logs can only be stored in the flash recovery area.

 

39、Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

A. PMON

B. SMON

C. MMNL

D. MMAN

E. MMON

Editor’s notes:

The Automatic Shared Memory Management feature uses a new background process named Memory Manager (MMAN). MMAN serves as the SGA Memory Broker and coordinates the sizing of the memory components. The SGA Memory Broker keeps track of the sizes of the components and pending resize operations

MMON: The Manageability Monitor (MMON) process was introduced in 10g and is associated with the Automatic Workload Repository new features used for automatic problem detection and self-tuning. MMON writes out the required statistics for AWR on a scheduled basis.

REF.: Metalink Note:268197.1: New Background Processes In 10g

 

40、Which six files are maintained in the Flash Recovery Area? (Choose six.)

A. control file

B. RMAN files

C. password file

D. parameter file

E. flashback logs

F. data file copies

G. core dump files

H. archived log files

I. RMAN recovery scripts

J. control file autobackpus

Editor’s notes:

The Flash Recovery Area is a unified storage location for all recovery-related files and activities in an Oracle Database. It includes Control File, Archived Log Files, Flashback Logs, Control File Autobackups, Data Files, and RMAN files

 

41、You have a directory, data, under the disk group tdgroup

A. You want to create an alias for one of the data files and you execute the following command:

ALTER DISKGROUP tdgroupA

ADD ALIAS '+tdgroupA/data/datafile.dbf'

FOR '+tdgroupA.231.45678';

Which task would be accomplished by the command?

A. The command drops the file +tdgroupA.231.45678

B. The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.

C. The command creates a copy of the +tdgroupA.231.45678 file and places it in +tdgroupA/data after remaining the file to datafile.dbf.

D. The command creates a synonym, datafile.dbf, and places it in +tdgroupA/data and does not remove the +tdgroupA.231.45678 file.

E. The command creates a file, datafile.dbf, in +tdgroupA/ data and removes the references for +tdgroupA.231.45678 from the data dictionary views.

Editor’s notes:

Alias names (or just "aliases") are intended to provide a more user-friendly means of referring to ASM files, rather than using the system-generated filenames. You can create an alias for a file when you create it in the database, or you can add an alias to an existing file using the ADD ALIAS clause of the ALTER DISKGROUP statement. You can create an alias in any system-generated or user-created ASM directory. You cannot create an alias at the root level (+), however. The following statement adds a new alias name for a system-generated file name:

ALTER DISKGROUP dgroup1

ADD ALIAS '+dgroup1/mydir/second.dbf'

FOR '+dgroup1/sample/datafile/mytable.342.3';

 

42、Exhibit

One the evening of April 22, you are working on a database created using Oracle

Database 10g. This database operates in the ARCHIVELOG mode. You discover

that you need crucial data that was dropped from the database at 8:00 a.m. No full

backup has been taken after April 15.

What would you do?

A. recover the database until April 10

B. recover the database until April 15

C. recover the database until 22 7:59 a.m.

D. recovery is not possible; manually re-create the object

Editor’s notes:

RMAN simplifies recovery operations using backups taken from earlier database incarnation so that it is easy as recovering a backup from the same incarnation. The simplified recovery through RESETLOGS feature is an enhancement to recovery operations so that previous incarnation backups can be used for recovery of the current database incarnation. You use this feature when you have performed an incomplete recovery (or a recovery using a backup control file) and opened the database with the RESETLOGS option.

To perform. incomplete recovery, use the SET UNTIL command to specify the time, SCN, restore point, or log sequence number at which recovery terminates. Alternatively, specify the UNTIL clause on the RESTORE and RECOVER commands.

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

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