Oracle >> 1z0-070

Which two cases would you consider dropping indexes that are not used for constraints after the migration to assure that Smart Scans occur?

by

You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to an X6 Exadata Database Machine.The database currently supports an application requiring fast response times to satisfy stringent business requirements, and most of the application queries use indexed access to tables.For which two cases would you consider dropping indexes that are … Read more

Which two methods would you use to check the status of all 36 ports?

by

You are checking the status of the ports on one of the InfiniBand switches on your X5 Database Machine.You run the getportstatus command as shown:[root@exampsw-ib2 bin] # getportstatus 17bPort status for connector 17B Switch Port 2Adminstate:………………….EnabledLinkWidthEnabled: ……………1X or 4XLinkWidthSupported:…………..1X or 4XLinkWidthActive………………4XLinkSpeedSupported: ………….2.5 Gbps or 5.0 Gbps or 10.0 GbpsLinkState: ………………….ActivePhysLinkState: …………….LinkUpLinkSpeedActive: …………..10.0 GbpsLinkSpeedEnabled: ………….2.5 Gbps … Read more

Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?

by

You plan to monitor the status of the motherboard, memory, power, fans, and network cards on the database nodes in your Exadata X6 Database Machine using Enterprise Manager.Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager? Question: … Read more

Which two options should be used to identify a damaged or failing flash card on an X6 Database Machine high-capacity storage server?

by

Correct Answer for the Question – Which two options should be used to identify a damaged or failing flash card on an X6 Database Machine high-capacity storage server? is given below Using the CELLCLI CALIBRATE command on the storage server after logging in as the root user Using the CELLCLI LIST LUN DETAIL command as the … Read more

Which two methods would you use to check the status of all 36 ports?

by

Correct Answer for the Question – Which two methods would you use to check the status of all 36 ports? is given below Use the ibqueryerrors.pl script after logging in to the InfiniBand switch as root. Use Enterprise Manager.Cloud Control. Use Enterprise Manager Express. Create user-defined metrics for the InfiniBand switch. Correct Answer The Correct Answer … Read more

Which two migration methods are supported?

by

Correct Answer for the Question – Which two migration methods are supported? is given below Data Pump cross-platform Transportable Database Physical Standby database Logical Standby database Correct Answer The Correct Answer for this Question is Data Pump Logical Standby database Explanation The Question – Which two migration methods are supported? has been answered correctly and answers … Read more

Which three access paths always generate “cell single block physical read” or “cell multiblock physical read” requests?

by

Correct Answer for the Question – Which three access paths always generate “cell single block physical read” or “cell multiblock physical read” requests? is given below An important application has been migrated to a database on an X5 Database Machine.You are examining high-load SQL statements from this application, in an attempt to determine which ones will … Read more

Which three operations can be offloaded to Exadata Storage Servers when performing a Smart Scan on this table?

by

Correct Answer for the Question – Which three operations can be offloaded to Exadata Storage Servers when performing a Smart Scan on this table? is given below A heap-organized table in one of your database schemas contains only date, char, varchar2, and number data type columns.Which three operations can be offloaded to Exadata Storage Servers when … Read more

Which two statements are true about the EXACLI utility?

by

Correct Answer for the Question – Which two statements are true about the EXACLI utility? is given below Which two statements are true about the EXACLI utility?The exadcli utility facilitates centralized management across an Oracle Exadata system by automating the execution of ExaCLI commands.Exadcli executes the commands on a set of remote nodes and returns the … Read more

Which three statements are true concerning InfiniBand port and subnet monitoring on an X5 Database Machine?

by

Correct Answer for the Question – Which three statements are true concerning InfiniBand port and subnet monitoring on an X5 Database Machine? is given below Which three statements are true concerning InfiniBand port and subnet monitoring on an X5 Database Machine?B: From any InfiniBand switch in the network (leaf switch or spine switch), log in as … Read more