1Z0-027 - Oracle Exadata Database Machine Administration, Software Release 11.x Exam
Go back to Oracle
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 tables. You decide to compress these tables without causing unacceptable performance overheads to the OLTP application. Which three are true regarding this requirement?
Using 'compress for oltp' will compress the data less than if using Hybrid Columnar Compression when specified with compress for query low.
The compression method compress for archive high is the worst fit for this requirement.
The compression is performed on the database servers when using 'compress for oltp' in an Exadata environment.
Which statement is true about operating systems on database Machine multi-rack configuration consisting of two full racks and one Exadata storage rack?
All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the same O/s.
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 while performing task. The Exadata storage server is an X3-8 Database Machine and storage grid is not partitioned. Which two factors would prevent you from moving the disks from one Exadata storage server to another one?
The existence of an external redundancy ASM diskgroup
The existence of an ASM diskgroup with its compatible.asm attribute set to 10.2.0.0.0
Which two are Oracle recommendations for media based backups performed for a database running on a Database Machine?
Allocate equivalent number of channels and instances per tape drive.
Use the InfiniBand network between the database server and media server.
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 your performance requirements. Given the results of your testing, you consider dropping the index. Which two statements are true?
You must retain the index and set the constraint to DISABLE NOVALIDATE RELY to enforce the constraint
You must retain the index and make it visible again for the constraint to be enforced.
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?
The targets must be configured by an Enterprise Manager administrator manually using Grid Control.
There may be more than one target for each plug-in.
You plan to migrate your Oracle Version 220.127.116.11 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?
Upgrade source database to 11.2.0 and migrate using a physical standby database.
Migrate using Data Pump.
Which two are true about the use of DBFS in a Database Machine environment?
DBFS must be used to bulk load data into a production database on the Database Machine.
DBFS must use the DBFS_DG diskgroup for any DBFS store.
In which two locations should files be staged, to be loaded using external tables into a database on a Database Machine?
On a dbfs file system stored in a staging database on the Database Machine
On an nfs file system mounted on a database server where the external table will be accessed.
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 connections to database instances 2. Fault tolerance providing higher availability for connections to perform management functions on the database and storage servers. 3. Full monitoring of all Database Machine components using Enterprise Manager Which three components require external Ethernet network cables to connect your existing network infrastructure to your database machine to satisfy this requirement?
Power distribution units (PDUs)
Cisco Ethernet switch
You recently upgraded your Exadata image to the latest release; previously you were using 18.104.22.168. 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?
Use ALTER TABLE in the database to set CELL_FLASH_CACHE = KEEP for the tables belonging to the affected application.
Configure Smart Flash Log on the cells to use some of these of the space on the cell flash devices.
Which two statements are true about the use of direct path loads when selecting from external tables in a database on a Database Machine?
INSERT INTO . . . SELECT FROM statements, executed serially, which select from external tables, require the APPEND hint to use direct path loading.
CREATE TABLE . . . AS SELECT statements, which select from external tables, attempt to use in direct path loading automatically.
Identify two permitted uses of external InfiniBand connections to a Database Machine.
To connect an ExaLogic Elastic Cloud Machine
To connect an external tape library
You are using Hybrid Columnar Compression for a table stored in a tablespace that is contained in an Exadata-based ASM diskgroup. Identify three statements that correctly explain where the compression and decompression can be done.
Decompression can be done on the database servers.
Compression can be done on the database servers.
Decompression can be done on the Exadata storage servers.
Which three factors should you consider when choosing a method for migrating a database to the Database Machine?
Type of database workload
Size of the source database
Endian format of the source database
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 set the thresholds for these hardware components and why to assure that sensor readings, faults any related alerts, are visible in Enterprise Manager?
No thresholds need ho set because they are preset in the ILOM and these are sufficient for monitoring.
Which three storage components are available after the standard initial Database machine deployment?
The DATA_<DBM_Name> ASM diskgroup
The RECO_<DBM_Name> ASM diskgroup
Mirrored system partitions on hard disk 0 and hard disk 1
Which tool will provide you with diagnostic information for all the software log, trace files, and OS information on Database Machine?
You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to the Exadata Database Machine. The database currently supports an application requiring fast response times, which satisfies stringent requirements, and most of the application queries use index access to the tables in the application schema. For which case would you consider dropping indexes to allow Smart Scans to occur?
Drop non-constraint Indexes if Smart Scan performs better than any index scans on the corresponding table.
Which is true regarding Enterprise Manager monitoring and configuration?
Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents without, any additional network configuration.
What is the benefit of bonding the client access network configuration?
Which two communication methods are used by which components in the Enterprise manager Architecture for the Database Machine?
SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process
SNMP traps for alerts are sent by the storage server MS process to the enterprise Manager agent
Identity the resource bottleneck for which QoS Management can generate recommendation?
CPU resource bottlenecks
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?
At the front, because the air flow is from front to back
You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your Database Machine. Following are details for the source database: Database version: 10.2.0 Byte order: Big Endian HP-UX (64-bit) Database size: 24 TB Storage: ASM with 1 MB allocation unit size Which two are supported migration methods?
Logical migration using Oracle Streams
Logical migration using logical standby
Which two activities are supported on the storage servers in the Database Machine?
configuring secure shell user equivalency for the callmonitor user
changing root password
Which two are true about Exadata storage server alerts?
Metric threshold; if set, will persist across storage server reboots.
SMTP alert notifications must be sent to both ASR manager and Enterprise Manager Agents
Your database Machine has the exachk utility pre-installed and you decide to use it periodically, to validate the installation against Oracle's recommended best practices. Which two actions could you take to do this?
Use a cron job on a database node to run it at regular intervals.
Create a Job in Enterprise Manager to run the exachk utility at regular intervals.
Which two are true about the use of the Integrated Lights Out Manager (ILOM) on the Database Machine?
ILOM can be used to power-on the database servers.
ILOM provides a remote console for the storage servers.
Which two statements are true about the IPTables firewall configuration on a Database Machine- Machine after the default Initial deployment?
IPTables is configured with Oracle supplied rules on the cells.
IPTables is installed and available but not configured on the database servers.
Identify two valid reasons for creating multiple griddisks on a Single celldisk.
To segregate storage into multiple pools with different performance characteristics
To segregate storage into multiple pools that can be assigned to different databases
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
size of the RECO ASM diskgroup
O/S owner mode (standard O/S authentication or role-separated O/S authentication)
RDBMS DBA group name
Which three are true about Smart Flash log?
I/O Resource Manager database plans can be used to enable or disable Smart Flash Log for different databases.
LGWR will not wait for writes to Smart Flash log if the write to a disk based log file completes first.
You can remove Smart Flash Log from a single storage server with the drop flashing command.
Which type of network traffic is transported over the internal InfiniBand network in a Database Machine?
IDB protocol traffic, Clustered ASM traffic, and RAC database instance traffic
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?
Resource Consumer Group I/O
Which two are regarding the case of storage indexes?
To increase the chance of using the a storage index, you can make table indexes invisible.
To maximize the benefit of storage Indexes, load your data stored on the filtered columns.
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?
CellCLI> LIST GRIDDISK ATTRIBUTE name WHERE asmdeactivationoutcome != `Yes'
CellCLI> ALTER GRIDDISK ALL INACTIVE
CellCLI> LIST GRIDDISK WHERE STATUS != `inactive'
`shutdown h now' on the affected cell
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?
griddisk on hard drive-based intervleaved celldisks.
griddisk on Flash-base celldisks.
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?
The CELLIP.ORA files on the database servers in CLUSA
The CELLIP.ORA files on the database servers in CLUSB
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, having standby database on another Database Machine. You wish to have scripts that contain the appropriate command to patch your environment. Your patch bundle is on the first database server and is located at /u01/stage. You have downloaded the oplan utility to the first database server and run the following: $ORACLE_HOME/oplan/oplangenerateApplySteps /u01/stage Which two are true concerning oplan?
It will generate instructions for patching the RAC Oracle Home on the primary location.
It will generate instructions for patching the Grid Infrastructure home on the primary location.