1Z0-042 记录(四)

242. Consider the following scenario: 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';

REF.: Oracle(r) 10g Administrator Guide, 12-28

 

244. You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason?

A. None of the SYSAUX occupants can be relocated.

B. The USERS tablespace is a bigfile tablespace (BFT).

C. The united Job Scheduler occupant cannot be relocated.

D. The SYSAUX occupants can be relocated to the SYSTEM tablespace only.

Editor’s notes:

A - Not true. Same off the occupants can be move

B - Not true. The USERS occupant , isn't , by default a BFT tablespace, and even tought, you should be able to move anything to a BFT tablespace. The point it's about to move, SYSAUX occupant.

C - True answer, as you con check , by the following query : SELECT occupant_name, move_procedure, FROM v$sysaux_occupants;

OCCUPANT_NAME MOVE_PROCEDURE

 

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

 

AO DBMS_AW.MOVE_AWMETA.

EM emd_maintenance.move_em_tblspc

JOB_SCHEDULER *** MOVE PROCEDURE NOT APPLICABLE **

LOGMNR SYS.DBMS_LOGMNR_D.SET_TABLESPACE

LOGSTDBY SYS.DBMS_LOGSTDBY.SET_TABLESPACE

ODM MOVE_ODM

ORDIM *** MOVE PROCEDURE NOT APPLICABLE ***

ORDIM/PLUGINS *** MOVE PROCEDURE NOT APPLICABLE ***

ORDIM/SQLMM *** MOVE PROCEDURE NOT APPLICABLE ***

SDO MDSYS.MOVE_SDO

STATSPACK Use export/import (see export parameter file spuexp.par)

STREAMS

TEXT DRI_MOVE_CTXSYS

ULTRASEARCH MOVE_WK

WM DBMS_WM.move_procD - Not true. Can move SYSAUX occupants, whem is possible, to any tablespace that you want.

REF.: Metalink Note: 243246.1: 10G : SYSAUX Tablespace

 

247. You are connecting to an Oracle database server from a client by using the following connect string:

SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb

Which naming method is being used in this case?

A. Local Naming

B. Easy Connect

C. External Naming

D. Directory Naming

Editos’s notes:You must watch the oracle 10g release(B14212-02 Configuring Naming Methods)

 

257. Exhibit. Which two options are used to enable the connect-time failover feature? (Choose two.)

A. Use only the first address.

B. Try one address, selected at random.

C. Try each address, in order, until one succeeds.

D. Try each address, randomly, until one succeeds.

E. Use each address in order until destination reached.

Editos’s notes:How can I talk about the answer.fuck.fool.

If you set loadblance=on,answer D is right.

 

275. In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace?

A. flash back the database

B. perform. point-in-time recovery

C. perform. a full database recovery

D. drop and re-create the tablespace

E. use Recovery Manager (RMAN) to recover the database

Editos’s notes:OK,now you can see that temp tablespace can be deleted.

 

281. Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control, which two options would you select to balance the connectionload across all the listener processes? (Choose two.)

A. Use only the first address.

B. Try one address, selected at random.

C. Try each address, in order, until one succeeds.

D. Try each address, randomly, until one succeeds.

Editos’s notes:

The picture above is from < Oracle Database 10g: Administration Workshop I 12-22 >

Web site associated:

http://www.itpub.net/thread-505819-1-1.html#

 

284. In your database, you may be forced to perform. a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this?

A. %t_%s.dbf

B. arch_%t.arc

C. arch_%d.arc

D. arch_%t_%d.arc

E. arch_%d_%s_.dbf

F. arch_%t_%s_%r.arc

Editos’s notes:LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc

This setting will generate archived logs as follows for thread 1; log sequence numbers 100, 101, and 102; resetlogs ID 509210197. The identical resetlogs ID indicates that the files are all from the same database incarnation:

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

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