1Z0-027 Exam Questions

Which two statements are true about the use of direct path loads when selecting from external tables in a database on a Database Machine?

Your customer wants you to partition the database and storage grids in his X3-2 full rack, creating database clusters and two storage grids. One cluster will be used for production...

Which three statements are true about the initial storage configuration after the standard deployment of a new database Machine?

You are in the planning stage of the network configuration for your Database Machine. The requirements are: 1. A fault-tolerant network, providing higher availability for connectio...

Identify two permitted uses of external InfiniBand connections to a Database Machine.

You are evaluating the performance of a SQL statement that accesses a very large table, and have run the following query producing the output shown: For which two reasons would the...

You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Database Machine. You use RAC for your database and also use Data Guard, havin...

Consider the following list of software components: 1. DCLI 2. Management Server (MS) 3. ASM Instance 4. RDBMS instance 5. Restart Server (RS) 6. Cellcli 7. Cell Server (CELLSRV) 8...

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 wou...

You configuring has two half racks, one with high capacity disks and other with high performance disks and high capacity expansion half rack. There are two RAC clusters, one on eac...

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:

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?

Which type of network traffic is transported over the internal InfiniBand network in a Database Machine?

In which two locations should files be staged, to be loaded using external tables into a database on a Database Machine?

Which three are true about Smart Flash log?

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 o...

Which three factors should you consider when choosing a method for migrating a database to the Database Machine?

Which three are among the software components that constitute the QoS Management framework?

Which two communication methods are used by which components in the Enterprise manager Architecture for the Database Machine?

Which three statements are true regarding the configuration of Auto Service Request (ASR) on your Database Machine?

Which two are true about Smart Scan?

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 whic...

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?

Identify three valid configuration options that can be implemented during the initial configuration process of a new Database Machine by using the Exadata Deployment Assistant

Which two are true about the use of the Integrated Lights Out Manager (ILOM) on the Database Machine?

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...

A table in one of your database schemas contains only varchar, number, and date data types for the columns. Which three operations can be offloaded to the Exadata storage servers w...

Which three must he true for Smart Scans to be done?

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...

You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to the Exadata Database Machine. The database currently supports an ap...

Your Database Machine has a large database with some very large tables supporting OLTP workloads. High volume Insert applications and high volume update workloads access the same t...

Which statement is true about operating systems on database Machine multi-rack configuration consisting of two full racks and one Exadata storage rack?

Which three are true regarding the use of Storage Indexes?

Which four statements are true about Exadata Smart Flash Cache?

You have altered an index supporting a constraint to be invisible on a large read only data warehouse table, to determine it Smart Scan operations will be fast enough to satisfy yo...

Which two activities are supported on the storage servers in the Database Machine?

You plan to monitor the status of the motherboard, memory, power, fans, and network cards on the database nodes in your Database machine using Enterprise Manager. Where must you se...

Which three are true abort Enterprise Manager plug- in configuration for the Database Machine?

Which is true regarding Enterprise Manager monitoring and configuration?

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

Which three are true about Exadata storage server alerts?

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...

Which two are true concerning the allocation of I/O resources by the IORM within the CELLSRV process?

Last weekend, an Exadata storage server flashdisk entered the predictive failure state. The flashdisk is used by the flashcache and has a griddisk which is a member of a normal red...

Which two are true concerning the allocation of I/O resources by the IORM within the CELLSRV process?

To troubleshoot a possible hardware problem, you consider moving all disk drives from one Exadata storage server to a replacement chassis. You must contain storage availability whi...

Which two are regarding the case of storage indexes?

Identity the resource bottleneck for which QoS Management can generate recommendation?

Which two are Oracle recommendations for media based backups performed for a database running on a Database Machine?

To guarantee proper cooling, you plan to place perforated floor tiles near your Database Machine. Where, in relation to the cabinet, should they be placed?