Act now and download your Oracle 1Z0-027 test today! Do not waste time for the worthless Oracle 1Z0-027 tutorials. Download Renew Oracle Oracle Exadata Database Machine Administration, Software Release 11.x exam with real questions and answers and begin to learn Oracle 1Z0-027 with a classic professional.
Online Oracle 1Z0-027 free dumps demo Below:
NEW QUESTION 1
Which two may act as building blocks for the creation of two or more griddisks residing on the same physical device and which have more balanced performance characteristics?
- A. griddisk on hard drive-based intervleaved celldisks.
- B. griddisk on hard drive-based celldisks consumed by ASM when creating diskgroups using ASM-based intelligent Data Placement (IDP)
- C. griddisk on hard drive-based non-interleaved celldisks.
- D. griddisk on Flash-base celldisks.
Interleaved Griddisks mean equally fast Griddisks, whereas with non Interleaved Griddisks (the default) the Griddisks created first are being taken from the outer tracks of the underlying physical disk.
NEW QUESTION 2
In which two locations should files be staged, to be loaded using external tables into a database on a Database Machine?
- A. On a dbfs file system stored in a staging database on the Database Machine
- B. On an Exadata-based ACFS file system on the Database Machine
- C. On an nfs file system mounted on a database server where the external table will be accessed.
- D. On local storage on one or more cells that are accessible to the database server where the load will be performed.
Reference: Installing Oracle E-Business Suite Release 12 with the Oracle Exadata Database Machine
NEW QUESTION 3
Which two activities are supported on the storage servers in the Database Machine?
- A. Installing an alternative package manager
- B. configuring secure shell user equivalency for the callmonitor user
- C. changing root password
- D. upgrading the Storage Server software package using RPN
- E. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
NEW QUESTION 4
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.
5. The only data types for the table are varchar (2), number, or date.
6. The largest number of columns for any table is 29.
7. 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
NEW QUESTION 5
You are about to run the oplan utility to patch the servers on your test Database Machine before patching the production environment.
The following task might be performed:
A) Test the failback procedure
B) Run the exachk utility
C) Read the README file.
D) Automate the patch application process as appropriate.
E) Verify that the patch provides the functionality it is meant to.
F) Apply the patch.
G) Evaluate the system performance.
In which order should the tasks be performed to patch in the recommended fashion?
- A. C, B, D, F, B, E, A
- B. C, D, F, B, E, G, A, B
- C. C, B, D, F, E, G, A
- D. C, B, D, F, E, A, G
- E. C, B, D, F, B, E, G, A
NEW QUESTION 6
Consider the following sequence of CELLCLI commands and SQL statements:
All CELLCLI commands and SQL statements are executed successfully without warnings. Which statement is true about the I/O performance of the DATA01 ASM diskgroups?
- A. The DATA01 diskgroups has better performance because the DATA01 griddisks were created first.
- B. The DATA02 ASM diskgroup has better performance because the DATA02 diskgroups was created first.
- C. The DATA01 diskgroup has better performance because the DATA01 griddisks are created on interleaved cell disks.
- D. The performance of both diskgroups is balanced because they are created on interleaved griddisks.
Griddisks are the fourth layer of abstraction, and they will be the Candidate Disks to build your ASM diskgroups from. By default (interleaving=none on the Celldisk layer), the first Griddisk that is created upon a Celldisk is placed on the outer sectors of the underlying Harddisk. It will have the best performance therefore
Not D: non-interleaved is the default.
NEW QUESTION 7
You have configured a multi-rack Database Machine with two X3-8 full racks all in a single cluster and storage grid.
Which two are true regarding the servers on which Enterprise manager agents must be deployed in order to monitor all components of the multi-rack Database Machine?
- A. On only one database server in the first rack
- B. On all storage servers in all racks
- C. On at least two storage servers in the first rack
- D. On all database servers in the first rack
- E. On only one database server in second rack
- F. On all database servers in second rack
- G. On at least two storage servers in the second rack
* The Enterprise Manager agent must be deployed to all compute nodes of the Database Machine.
* Oracle's documentation uses the term compute node when referring to the database server tier of the platform.
* The Exadata Database Machine runs Oracle Database 11g Real Application Cluster. The cluster and the database run on the servers known as database nodes or compute nodes (or simply “nodes”).
* Cells and compute nodes are not shared between partitions.
* Compute nodes in same partition share the same Cluster.
NEW QUESTION 8
You are checking the status of the ports on the one of the InfiniBand switches in your Database Machine.
You have run the getportstatus as shown:
You have 36 ports to check.
Which two methods would you use to check the status of all 36 ports?
- A. Use Enterprise Manager.
- B. Use the ibqueryerros.pl script logged into the InfiniBand switch as root.
- C. Use Database Control.
- D. Create user-defined metrics for the InfiniBand switch.
NEW QUESTION 9
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
* Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface. To invoke the CLI, simply login to the Exadata cell as cellmonitor, celladmin, or root, and type "cellcli". Within cellcli, a wide range of commands can be invoked to monitor the cell.
* While connected to cellcli as the Linux account celladmin, you can perform all cellcli commands except calibrate.
While logged into the cell server as cellmonitor, you can do any "read-only" commands; you cannot change any configuration or attributes.
NEW QUESTION 10
Which three are true abort Enterprise Manager plug- in configuration for the Database Machine?
- A. There are several separate plug-ins for Grid Control.
- B. There is one plug-in for Cloud Control.
- C. There are several separate plug-ins for Cloud Control.
- D. Some plug-ins require SNMP trap forwarders.
- E. All plug-ins require SNMP trap forwarders.
- F. There is one plug-in for Grid Control.
NEW QUESTION 11
You are about to replace one memory DIMM in an Exadata storage server and need to power off the affected cell.
Which four commands must you execute to safely power off the storage server in your standard deployed quarter rack Database Machine assuming that redundancy is not compromised?
- A. ‘crsctl stop cluster -all’ on one of the database servers
- B. CellCLI> LIST GRIDDISK ATTRIBUTE name WHERE asmdeactivationoutcome != ‘Yes’
- C. CellCLI> ALTER GRIDDISK ALL INACTIVE
- D. CellCLI> LIST GRIDDISK WHERE STATUS != ‘inactive’
- E. ‘shutdown –h now’ on the affected cell
/B: Step 1:
Run the following command to check if there are other offline disks
CellCLI> LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes'
If any grid disks are returned, then it is not safe to take the storage server offline because proper Oracle ASM disk group redundancy will not be intact.
/C: Step 2:
Inactivate all the grid disks when Oracle Exadata Storage Server is safe to take offline using the following command:
CellCLI> ALTER GRIDDISK ALL INACTIVE
Taking the storage server offline when one or more grid disks are in this state will cause Oracle ASM to dismount the affected disk group, causing the databases to shut down abruptly.
/D: Step 3:
-- Verify all grid disks are INACTIVE to allow safe storage server shut down by running the following command:CellCLI> LIST GRIDDISK ATTRIBUTES name, asmmodestatusCellCLI> LIST GRIDDISKIf all grid disks are INACTIVE, then the storage server can be shutdown without affecting database availability
/E: Step 4:
To stop a server, use the shutdown command. To stop immediately and keep it down, i.e. not reboot, execute:
shutdown -h -y now
NEW QUESTION 12
Which two are regarding the case of storage indexes?
- A. To increase the chance of using the a storage index, you can make table indexes invisible.
- B. To maximize the benefit of storage Indexes, load your data stored on the filtered columns.
- C. The cell physical 10 bytes saved by storage index statistic returns multiple rows, one for each storage server.
- D. Storage indexes are retained after a cell is rebooted.
- E. Avoid the use of bind variables because Storage Indexes do not work with bind variables.
To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes.
* With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required
* subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.
NEW QUESTION 13
You have used setupem.sh to deploy a plug in for Grid Control.
In which two ways do all the targets supported by the plug-in get configured?
- A. The targets must be configured by an Enterprise Manager administrator manually using Grid Control.
- B. Setupem.sh is used again to configure the targets.
- C. The targets must be configured by an O/S administrator manually.
- D. The targets must be configured by a database administrator manually.
- E. There may be more than one target for each plug-in.
NEW QUESTION 14
Which two are true about Smart Scan?
- A. a query rewrite may occur to a container table stored in Exadata but will never benefit From Smart scan.
- B. Column projection does not contribute to the performance benefit of Smart Scan
- C. It is possible to offload single row functions to the storage servers.
- D. Some joins can be offloaded to the storage servers.
- E. A query rewrite may occur to a container table stored Exadata, and it will always benefit from Smart Scan.
- F. All joins can be offloaded to the storage servers.
C: With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.
D (not F):
* Exadata performs joins between large tables and small lookup tables, a very common scenario for data warehouses with star schemas. Joining large tables and small lookup tables is implemented using Bloom Filters, which are a very efficient probabilistic method to determine whether a row is a member of the desired result set.
* If storage indexes are so great, why doesn’t Oracle Exadata use them all the time? The short answer is that they are created and used only when they will be beneficial.
* To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes. Applications with queries that include predicates and perform a lot of full table scans or fast full scans of indexes—typically those used in data warehousing environments—will benefit greatly from storage indexes. Online
* transaction processing (OLTP) applications, on the other hand, typically access a small number of rows through standard indexes and do not perform full table scans, so they may not benefit from storage indexes.
* Storage indexes reside in the memory of the storage servers—also called storage cells—and significantly reduce unnecessary I/O by excluding irrelevant database blocks in the storage cells.
* To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes.
Not B: Exadata provides column filtering, also called column projection, for table scans. Only the columns requested are returned to the database server rather than all columns in a table. For example, when the following SQL is issued, only the employee_name and employee_number columns are returned from Exadata to the database kernel.
SELECT employee_name, employee_number FROM employee_table.
For tables with many columns, or columns containing LOBs (Large Objects), the I/O bandwidth saved can be very large. Using both predicate and column filtering dramatically improves performance and reduces I/O bandwidth consumption. In addition, column filtering also applies to indexes, allowing for even faster query performance.
Reference: Oracle Communications Data Model Implementation and Operations Guide, Exadata Smart Scan Processing and Storage Index
NEW QUESTION 15
You plan to monitor storage servers after configuring an I/O resource manager plan with directives for inter-database plans and intra-database plans.
Which two types if metrics would help assess the impact of the intra-database plans on I/O to the storage servers?
- A. Category I/O
- B. Database I/O
- C. Resource Consumer Group I/O
- D. Smart Flash Log I/O
- E. Smart Flash Cache I/O
B: Database metrics provide information about the size of the I/O load from each database specified in the interdatabase plan.
C: Consumer group metrics provide information about the size of the I/O load from each consumer group specified in a database resource plan. Each database in the interdatabase plan has metrics for each of its consumer groups.
* I/O Resource Manager (IROM) Settings
Not A: Category metrics provide information about the size of the I/O load from each category specified in the current IORM category plan.
NEW QUESTION 16
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
* cellinit.ora, cellip.ora
-- on database server
cellinit.ora - identifies the storage network interface on the database server cat /etc/oracle/cell/network-config/cellinit.ora
cellip.ora - identifies the Exadata cells that are accessible to the database server cat /etc/oracle/cell/network-config/cellip.ora
* The cellip.ora is the configuration file, on every compute node, that tells ASM instances which cells are available to this cluster.
Here is a content of a typical cellip.ora file for a quarter rack system:
$ cat /etc/oracle/cell/network-config/cellip.ora cell="192.168.10.3"
NEW QUESTION 17
Identity the resource bottleneck for which QoS Management can generate recommendation?
- A. CPU resource bottlenecks
- B. Global Cache resource bottlenecks
- C. I/O resource bottlenecks
- D. Network resource bottlenecks
NEW QUESTION 18
You plan to migrate your Oracle Version 22.214.171.124 database to your Exadata Database Machine.
The database supports an online transaction processing (OLTP) workload and is currently hosted on a Little Endian platform
Which two are the supported and appropriate migration methods to minimize downtime?
- A. Upgrade source database to 11.2.0 and migrate using a physical standby database.
- B. Migrate using Data Pump.
- C. Migrate using GoldenGate.
- D. Migrate using cross platform Transportable Database.
- E. Migrate using ASM online migration.
Reference: Migrating the Oracle E-Business Suite Database to Oracle Exadata Database Machine Using Transportable Tablespaces
Reference: Migrating Oracle E-Business Suite to Oracle Exadata Database Machine Using Oracle Data Pump
NEW QUESTION 19
Identify the correct sequence of commands to completely power off a Database Machine in an Orderly fashion:
1. Execute “crsctl stop cluster –all” as the grid user from one database server.
2. Execute “crsctl stop cluster –all” as the root user from one database server.
3. Power off all network switches using their power switch.
4. Execute “crsctl stop cluster –all” as the root user from one database server.
5. Execute “crsctl stop cluster –all” as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute “shutdown –h now” on all database servers.
8. Execute “shutdown –h now” on all Exadata storage servers.
1. 9. Execute “shutdown –h now” on all servers.
- A. 1, 9, 3 and 6
- B. 2, 9 and 6
- C. 4, 7, 8, 3 and 6
- D. 5, 8, 7, 3 and 6
- E. 2, 8, 7, 3 and 6
- F. 1, 8, 7, 3 and 6
- G. 2, 7, 8 and 6
- H. 2, 8, 7 and 6
NEW QUESTION 20
Which two are true concerning the allocation of I/O resources by the IORM within the CELLSRV process?
- A. Control File I/O is managed automatically at high priority by IORM.
- B. Control File I/O is considered part of the SYSTEM resource Consume group by IORM.
- C. Log Writer I/O to the Smart Flash Log is considered part of the SYSTEM resource consumer group by IORM.
- D. Log Writer I/O to the Smart Flash Log is managed automatically at high priority by IORM.
- E. Database Writer I/O is managed automatically at normal priority by IORM.
- F. Database Writer I/O is considered part of the SYSTEM resource consumer group by IORM.
* IORM Rules
IORM is only "engaged" when needed.
/ (A) Redo and control file writes always take precedence.
/ (E) DBWR (database writer) writes are scheduled at the same priority as user IO.
/ IORM does not intervene if there is only one active consumer group on one database.
/ Any disk allocation that is not fully utilized is made available to other workloads in relation to the configured resource plans.
/ Background IO is scheduled based on their priority relative to user IO.
/ For each cell disk, each database accessing the cell has one IO queue per consumer group and three background queues.
/ Background IO queues are mapped to "high", "medium", and "low" priority requests with different IO types mapped to each queue.
/ If no intradatabase plan is set, all non-background IO requests are grouped into a single consumer group called OTHER_GROUPS.
Reference: Using IORM with Exadata
NEW QUESTION 21
Which three must be true for Smart Scans to be done?
- A. Executing a query in parallel
- B. Setting _serial_direct_read=true in the session issuing the SQL statements
- C. Having direct path reads used at run time
- D. Having a 4 meg AU size for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored
- E. Cell_offload_process = true for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored.
- F. cell.smart_scan_capable=true for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored.
NEW QUESTION 22
P.S. Dumps-hub.com now are offering 100% pass ensure 1Z0-027 dumps! All 1Z0-027 exam questions have been updated with correct answers: https://www.dumps-hub.com/1Z0-027-dumps.html (72 New Questions)