저희는 수많은 IT자격증시험에 도전해보려 하는 IT인사들께 편리를 가져다 드리기 위해 Oracle Data base 1Z0-027실제시험 출제유형에 근거하여 가장 퍼펙트한 시험공부가이드를 출시하였습니다. 많은 사이트에서 판매하고 있는 시험자료보다 출중한 Pass4Test의 Oracle Database 1Z0-027덤프는 실제시험의 거의 모든 문제를 적중하여 고득점으로 시험에서 한방에 패스하도록 해드립니다.Oracle Data base 1Z0-027시험은 Pass4Test제품으로 간편하게 도전해보시면 후회없을 것입니다.
NO.1 The only data types for the table are varchar (2), number, or date.
NO.2 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.3 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
NO.4 The largest number of columns for any table is 29.
NO.5 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.6 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.7 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