인테넷에 검색하면 Oracle Database 1Z0-027시험덤프공부자료가 헤아릴수 없을 정도로 많이 검색됩니다. 그중에서 Pass4Test의  Oracle Database 1Z0-027제품이 인지도가 가장 높고 가장 안전하게 시험을 패스하도록 지름길이 되어드릴수 있습니다.

 

 

NO.1 Which two are true about Exadata storage server alerts?

A. Metric alerts are never stateful.

B. Metrics have no thresholds set on them by default.

C. SNMP alert notifications can be sent to only one destination.

D. Metric threshold; if set, will persist across storage server reboots.

E. SMTP alert notifications must be sent to both ASR manager and Enterprise Manager Agents

Answer: D,E

 

NO.2 The only data types for the table are varchar (2), number, or date.

 

NO.3 The largest number of columns for any table is 29.

 

NO.4 You recently upgraded your Exadata image to the latest release; previously you were using

11.2.0.3.

At the same time, you decide to address some performance problems as follows:

You noticed increased latency for the database log writer, especially during the quarterly battery

learn cycle on the cells.

You have complaints of erratic performance from certain write-intensive applications.

Which two actions could improve performance in these areas?

A. Enable write-back flashcache by setting lunWriteCacheMode to Write Back Mode.

B. Use ALTER TABLE in the database to set CELL_FLASH_CACHE = KEEP for the tables

belonging to the affected application.

C. Configure Smart Flash Log on the cells to use some of these of the space on the cell flash

devices.

D. Configure the table belonging to the affected application using CELLCLI, to the set

CELL_FLASH_CACHE = KEEP .

E. Configure Smart Flash Log on the database server to use server flash memory.

Answer: B,C

 

NO.5 No access is based on ROWID, or virtual columns.

Which two access paths will always generate either a set of “cell smart table scan” or a set of “cell

smart index scan” requested?

A. Full scans on sorted hash clustered tables executed in parallel

B. Full table scans on index organized tables executed in parallel.

C. Full table scans on heap tables executed in parallel

D. Full scans on index clustered tables executed in parallel

E. full scans on hash clustered tables executed in serially

F. fast full scans on B*Tree indexes executed in parallel

G. full index scans on B*Tree indexes executed in parallel

Answer: B,G

8. You must drop all celldisks on all the cells in a quarter rack as part of a reconfiguration project,

to

support normal redundancy interleaving.

Select two actions that describe the operating system (O/S) account on the cells to which you

should log in, and the tool that may be used to drop the celldisks.

A. To the CELLMONITOR account using CELLCLI interactively on each cell.

B. To CELLADMIN account calling CELLCLI on all cells using DCLI

C. To either the CELIMONITOR or the CELLADMIN account calling CELLCLI on all cells using

DCLI

D. To the CELLMONITOR account calling CELLCLI on all cells using DCLI

E. To the CELLADMIN account using CELLCLI interactively on each cell

F. To either the CELLMONITOR or CELLADMIN account calling interactively on each cell

Answer: B,E

 

NO.6 Which two are true about the use of DBFS in a Database Machine environment?

A. DBFS must be used to bulk load data into a database on the Database Machine if the staging

area requires Exadata based shared storage.

B. DBFS must be used to have a POSIX compliant shared storage solution that is accessible from

the database servers on a Database Machine.

C. DBFS must be used to bulk load data into a production database on the Database Machine.

D. DBFSmust use the DBFS_DG diskgroup for any DBFS store.

E. DBFS must be used to have a POSIX-compliant Exadata-based shared storage solution.

Answer: A,B

5. Which tool will provide you with diagnostic information for all the software log, trace files, and

OS

information on Database Machine?

A. dbmcheck.sh

B. diagget.sh

C. oswatcher

D. adrci

E. Enterprise Manager

Answer: B

6. You have a partitioned database grid on an X3-2 full rack with two four-node RAC clusters

called

CLUSA and CLUSB. The storage grid, however, has not been partitioned.

Which files on which servers must be modified after connecting an Exadata storage full expansion

rack to your X3-2 Exadata Database Machine on the InfiniBand network so that the cells on the

expansion rack are added to the storage grid?

A. The CELLINIT.ORA files on database servers in CLUSA

B. The CELLIP .ORA files on the database servers in CLUSA

C. The CELLINIT.ORA files on the database servers in CLUSB

D. The CELLIP .ORA files on all existing and newly added Exadata storage servers.

E. The CELLIP .ORA files on the database servers in CLUSB

Answer: B,E

7. A read-only application is in development and is using a test database on a Database Machine.

You are examining SQL statements from this application in an attempt to determine which ones

will benefit from the Exadata Smart scan capability.

The following is true about the tables used by the application:

1. The data for the tables has just been loaded.

2. There are no applications accessing the tables currently.

3. None of the indexes are compressed or reverse key indexes.

4. The tables use the default organization type data.

 

NO.7 Which three storage components are available after the standard initial Database machine

deployment?

A. The DATA_<DBM_Name> ASM diskgroup

B. The RECO_<DBM_Name> ASM diskgroup

C. Mirrored system partitions on hard disk 0 and hard disk 1

D. The DBFS_DG diskgroup with external redundancy

E. Exadata Smart Flash Cache using all of the flashdisk space

Answer: A,B,D