[Jul-2021] Dumps Brief Outline Of The 1z0-070 Exam - Actual4Labs
1z0-070 Training & Certification Get Latest Oracle Exadata
NEW QUESTION 60
Which four statements are true concerning the configuration or use of Enterprise Manager
Cloud Control to monitor and manage Exadata Database Machine components?
- A. Cloud Control cannot monitor partitioned Exadata Database Machine systems.
- B. Oracle management agents must only be installed on one storage node in a Database
Machine to enable monitoring and management of all storage nodes. - C. Cloud Control can monitor and manage a Database Machine storage Expansion rack.
- D. Oracle management agents must only be installed on one compute node in a Database
Machine to enable monitoring and management of all compute nodes and storage nodes. - E. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.
- F. Cloud control can monitor and manage a Database Machine compute node expansion rack.
- G. Computer nodes forward their SNMP traps to the Management Server process on the same computer node.
Answer: C,D,E,F
Explanation:
B (not A): Oracle Exadata components-including database and storage servers, switches, and power distribution units (PDUs)-use SNMP to raise alerts and report monitoring information.
Oracle's CellCLI interface is a Java-based framework delivered by the storage cell's management server process (MS) that provides administrative capabilities to your storage server entities.
C: Cloud control can monitor the Exadata Database Machine.
Figure: Oracle Enterprise Manager Cloud Control 12c monitoring architecture. Note the
Management Server process (MS) on the Storage servers.
G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every
Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units.
References:http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor- exadata-em12-2291964.html
NEW QUESTION 61
You are in the process of upgrading your X5 Database Machine half rack to a full rack.
The new storage servers are called DM01CEL08 through DM01CEL14.
After creating 96 new griddisks, you issued this SQL statement:
How many failgroups if any, will be added to the DATA diskgroup by executing this SQL statement?
- A. 0, because the new griddisks will be added to the existing failgroups
- B. 12, consisting of seven griddisks each
- C. 96, consisting of seven griddisk each
- D. 1, consisting of all 96 griddisks
- E. 7, consisting of 12 griddisks each
Answer: E
Explanation:
The number of failure groups equals the number of Exadata Cells. Each failure group is composed of a subset of grid disks in the Oracle ASM disk group that belong to a single storage cell.
References:
http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administering-asm.htm
NEW QUESTION 62
A file contains a script with several EXACLI commands that must be executed on each cell in an X5 full rack.
The script must run on each cell simultaneously.
How would you achieve this?
- A. Execute it on all cells using the DBMCLI command specifying the file name containing the EXACLI script.
- B. Execute it on all cells using the EXADCLI command specifying the file name containing the EXACLI script.
- C. Copy the script to all cells using the CELLCLI command and execute it on all cells in parallel using the CELLCLI command.
- D. Copy the script to the cells using the EXACLI command and execute the script on all cells using the EXACLI command.
- E. Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command.
Answer: B
Explanation:
Explanation/Reference:
The exadcli utility runs commands on multiple remote nodes in parallel threads.
You can issue an ExaCLI command to be run on multiple remote nodes. Remote nodes are referenced by their host name or IP address. Unlike dcli, exadcli can only execute ExaCLI commands. Other commands, for example, shell commands, cannot be executed using exadcli.
References: http://docs.oracle.com/cd/E80920_01/DBMMN/exadcli.htm#DBMMN-GUID-4AE469A6-F291-
4737-B975-F1B4B91D0BA0
NEW QUESTION 63
Which three statements are true regarding the configuration of Auto Service Request (ASR) on an X5 Database Machine?
- A. SMTP must be enabled on at least one database server.
- B. ASR Manager may be installed on any type of server running Oracle Solaris.
- C. HTTPS connectivity must be enabled from the ASR Manager host to the Internet.
- D. Oracle Linux must be used on the server where ASR Manager is installed.
- E. ASR Manager must be installed on one of the database servers.
- F. ASR Manager may be installed on any type of server running Oracle Linux.
- G. Oracle Solaris must be used on the server where ASR Manager is installed.
Answer: B,C,F
Explanation:
AB: Oracle recommends that you install Oracle ASR Manager on an external, standalone server. This server receives fault telemetry information from Oracle Exadata Database Machine servers. This server must run an Oracle Solaris or Linux operating system.
G: Before installing Oracle Auto Service Request (Oracle ASR) you must ensure connectivity to the Internet using HTTPS.
References:
Oracle Auto Service Request Exadata Database Machine Quick Installation Guide
http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm#GUID-89192315-1B1A-4B5A-89BB-94BB5B6ABB05
NEW QUESTION 64
Which two statements are true about RMAN incremental level-1 backups for a database running on an X5 Database Machine?
- A. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in archivelog mode.
- B. cellsrv returns all blocks that have been or might have been changed since the last backup, and RMAN filters the blocks that do not require backup.
- C. Block Change tracking (BCT) is not needed for databases in an X5 Database Machine, because ASM automatically does block change tracking when diskgroups are built from griddisks.
- D. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in noarchivelog mode.
- E. Block Change Tracking (BCT) is not needed for databases in an X5 Database Machine, because change tracking is done by cellsrv.
Answer: D,E
Explanation:
D: Whenever data blocks change, the Change Tracking Writer (CTWR) background process tracks the changed blocks in a private area of memory.
When RMAN performs an incremental backup on the Exadata platform, cellsrv filters out unwanted blocks and sends back only those that have changed since the last level 0 or level 1 backup.
E: For the Exadata platform, you may choose to allow cellserv to do all the blocking filtering for incremental backups.
Note: RMAN block change tracking is used to improve the performance of incremental backup. The level 0 incremental backup scans the entire database but level 1 incremental backups use the block change tracking file to scan only the blocks that have changed since the last backup. This significantly reduces the amount of reads that are required on the database.
References: Expert Oracle Exadata (29 Aug 2015), page 319
NEW QUESTION 65
You plan to migrate a database supporting both DSS and OLTP workloads to your new X5 Database machine.
The workloads contain many complex aggregating functions and expensive joins on large partitioned tables in the DSS workload and indexed access for OLTP workloads.
Which three benefits accrue as a result of this migration?
- A. Superior flash cache compression technique
- B. Superior compression capability designed specifically for archival data
- C. Columnar storage capability for data in row major data blocks that is held in flash cache
- D. Superior compression capability designed specifically for data warehouse tables
- E. Cell offload processing for indexed-organized table access
- F. Superior compression capability designed specifically for OLTP workloads
Answer: B,D,F
Explanation:
Explanation/Reference:
There are 6 different kinds of Table Data Compression methods:
1. BASIC compression, introduced in Oracle 8 already and only recommended for Data Warehouse
2. OLTP compression, introduced in Oracle 11 and recommended for OLTP Databases as well
3. QUERY LOW compression (Exadata only), recommended for Data Warehouse with Load Time as a critical factor
4. QUERY HIGH compression (Exadata only), recommended for Data Warehouse with focus on Space Saving
5. ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor
6. ARCHIVE HIGH compression (Exadata only), recommended for Archival Data with maximum Space Saving
Incorrect Answers:
B:
1. BASIC compression, introduced in Oracle 8 already and only recommended for Data Warehouse
2. OLTP compression, introduced in Oracle 11 and recommended for OLTP Databases as well
3. QUERY LOW compression (Exadata only), recommended for Data Warehouse with Load Time as a critical factor
4. QUERY HIGH compression (Exadata only), recommended for Data Warehouse with focus on Space Saving
5. ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor
6. ARCHIVE HIGH compression (Exadata only), recommended for Archival Data with maximum Space Saving
Method 1 and 2 are working by compressing the rows inside of Oracle Blocks - the more redundant values inside the block, the better the compression ratio. OLTP compression might be used with Exadata Database Machine, because Exadata V2 is designed to support OLTP as well as Data Warehouse.
Methods 3 to 6 use Hybrid Columnar Compression (HCC), which is designed to achieve better compression ratios by organizing sets of rows into compression units and then detaching the columns from the rows and collecting them. It is more likely that the same columns store similar (redundant) data, therefore the compression ratio improves with HCC.
References: https://uhesse.com/2011/01/21/exadata-part-iii-compression/
NEW QUESTION 66
You plan to migrate a very large database supporting a DSS workload to your new X5 Database Machine.
It will be the only database on this full rack.
Which three statements are true about Database Machine features that improve performance for the DSS workload?
- A. Smart Storage operations can improve the performance of joins.
- B. Hybrid Columnar Decompression overheads can be offloaded from the database servers for index full scans.
- C. Smart Storage operations can improve the performance of scans.
- D. Hybrid Columnar Compression can reduce the amount of physical I/O required to scan large tables.
- E. Full table scan operations can improve due to the default Smart Flash Cache implementation.
Answer: B,C,E
NEW QUESTION 67
Which two Exadata X5 security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?
- A. Using EXADCLI instead of CELLCLI to create the griddisks
- B. file permissions on the griddisks in each database server
- C. file permissions on the griddisks in each storage server
- D. Exadata storage realms using database-scoped security mode
- E. Exadata storage realms using ASM-scoped security mode
Answer: D,E
Explanation:
Explanation/Reference:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmsq/exadata-security- features.html#GUID-F53D9493-5927-4106-8D86-65D759419E46
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmsq/security-guide-exadata- database-machine.pdf
NEW QUESTION 68
An Exadata storage server physical disk on an X5 high-capacity full rack entered the predictive failure state.
Identify the two steps that you must perform to replace this failed physical disk.
- A. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
- B. Add the griddisks back into the ASM diskgroup they used to be a member of.
- C. Replace the failed physical disk.
- D. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
- E. Create a new celldisk and new griddisks on the replaced physical disk.
Answer: C,D
Explanation:
You may need to replace a physical disk because the disk is in warning - predictive failure status. The predictive failure status indicates that the physical disk will soon fail, and should be replaced at the earliest opportunity. The Oracle ASM disks associated with the grid disks on the physical drive are automatically dropped, and an Oracle ASM rebalance relocates the data from the predictively failed disk to other disks.
Note: After the physical disk is replaced, the grid disks and cell disks that existed on the previous disk in that slot are re-created on the new physical disk. If those grid disks were part of an Oracle ASM group, then they are added back to the disk group, and the data is rebalanced on them, based on the disk group redundancy and ASM_POWER_LIMIT parameter.
References:
http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm#DBMMN21047
NEW QUESTION 69
Your X6 Exadata Database Machine is running Oracle Database 12c, and 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 wish to compress these tables without causing unacceptable performance overheads to the OLTP workload.
Which three are true regarding this requirement?
- A. The compression method column store compress for archive high is the worst fit for this requirement.
- B. Compression is performed on database servers when using row store compress advanced in an Exadata environment.
- C. Compression is performed on Exadata Storage Servers when using row store compress advanced in an Exadata environment.
- D. Using row store compress advanced will compress the data less than if using column store compress for query low.
- E. Using row store compress advanced will compress the data more than if using column store compress for archive low.
Answer: B,C,E
Explanation:
A: Creating a Table with Advanced Row Compression
The following example enables advanced row compression on the table orders:
CREATE TABLE orders ... ROW STORE COMPRESS ADVANCED;
B: ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor Incorrect Answers:
E: QUERY LOW compression (Exadata only), recommended for Data Warehouse with Load Time as a critical factor.
References: https://docs.oracle.com/database/121/ADMIN/tables.htm#ADMIN015
https://uhesse.com/2011/01/21/exadata-part-iii-compression/
NEW QUESTION 70
Which two are benefits of an active/inactive configured InfiniBand network on Exadata
Database Machine X5?
- A. Improved performance when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands
- B. Improved performance for Oracle Network traffic
- C. Improved performance for ASM rebalance network traffic
- D. Improved reliability for Cache Fusion RAC network traffic
- E. Improved reliability when executing Distributed Command Line Interface (DCLI) to run
CELLCLI commands
Answer: D,E
Explanation:
Active-passive bonding provides reliability through failover.
NEW QUESTION 71
Which two statements are true about the EXACLI utility?
- A. It can be executed using the EXADCLI utility.
- B. It supports all CELLCLI commands.
- C. It requires access through a cell user that has role-based privileges granted.
- D. It requires the same privileges as the celladmin linux user to create CELLDISKS and GRIDDISKS.
- E. It can execute commands on multiple cells in parallel.
- F. It can be executed directly on cells.
Answer: A,E
Explanation:
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 output to the centralized management location where the exadcli utility was run.
The exadcli utility runs commands on multiple remote nodes in parallel threads.
Reference: https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/ exadcli.html#GUID-1C738F05-2A69-4B75-BB1E-B578C9081487
NEW QUESTION 72
Which three factors should you consider when choosing a method for migrating a database to the X5 Database Machine?
- A. The type of database workloads
- B. Number of tablespaces in the source database
- C. Size of the source database
- D. Endian format of the source database
- E. The down time allowed for the migration
Answer: A,C,D
Explanation:
B: Endian format: Non-Exadata format
D: Use Real Production Workload - Real Application Testing (RAT)
NEW QUESTION 73
Your X6 Exadata Database Machine is running Oracle Database 12c, and 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 wish to compress these tables without causing unacceptable performance overheads to the OLTP workload.
Which three are true regarding this requirement?
- A. The compression method column store compress for archive high is the worst fit for this requirement.
- B. Using row store compress advanced will compress the data more than if using column store compress for archieve low.
- C. Compression is performed on database servers when using row store compress advanced in an Exadata environment.
- D. Compression is performed on Exadata Storage Servers when using row store compress advanced in an Exadata environment.
- E. Using row store compress advanced will compress the data less than if using column store compress for query low.
Answer: B,C,D
Explanation:
Explanation/Reference:
A: Creating a Table with Advanced Row Compression
The following example enables advanced row compression on the table orders:
CREATE TABLE orders ... ROW STORE COMPRESS ADVANCED;
B: ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor
Incorrect Answers:
E: QUERY LOW compression (Exadata only), recommended for Data Warehouse with Load Time as a critical factor.
References: https://docs.oracle.com/database/121/ADMIN/tables.htm#ADMIN015
https://uhesse.com/2011/01/21/exadata-part-iii-compression/
NEW QUESTION 74
Which two statements are true about Auto Service Request (ASR) with an X5 Database Machine?
- A. ASR Manager must be installed and configured on one of the database servers.
- B. ASR can upload configuration metadata to support problem resolution.
- C. ASR communicates with Oracle support services using HTTPS.
- D. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
- E. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
- F. Configuring ASR is mandatory for all Database Machine assets.
Answer: D,E
Explanation:
A: Oracle recommends that you install Oracle ASR Manager on an external, standalone server.
C: Oracle ASR is designed to generate Oracle service requests automatically when certain types of faults are detected on Oracle products that are qualified for Oracle ASR.
Oracle ASR works only for specific component faults.
Most of the common components, such as disks, fans, and power supplies, are covered. However, some components are not covered.
For example, Oracle ASR does not cover InfiniBand events; there are specific images and specific InfiniBand switch firmware that you must use. You cannot upgrade these components independently.
NEW QUESTION 75
Which two options should be used to identify a damaged or failing flash card on an X6 Database Machine high-capacity storage server?
- A. Using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
- B. Using the CELLCLI LIST LUN DETAIL command as the celladmin user
- C. Using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin
- D. Hardware monitoring using the storage server ILOM
Answer: A,D
Explanation:
The CALIBRATE command runs raw performance tests on cell disks, enabling you to verify the disk performance before the cell is put online. You must be logged on to the cell as the root user to run CALIBRATE.
Oracle ILOM automatically detects system hardware faults and environmental conditions on the server. If a problem occurs on the server, Oracle ILOM will automatically do the following:
Illuminate the Service Required status indicator (LED) on the server front and back panels.
Identify the faulted component in the Open Problems table.
Record system information about the faulted component or condition in the event log.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-cellcli.htm#SAGUG20617
NEW QUESTION 76
Which four statements are true about the configuration of Auto Service Request (ASR) for use with an X5 Database Machine?
- A. ASR can connect to the Internet using Simple Network Management Protocol (SNMP), using a proxy server.
- B. ASR Manager software may be installed on one of the database servers in the Database Machine.
- C. ASR Manager software may be installed on a server that is not part of the Database Machine.
- D. ASR can connect to the Internet directly using Simple Network Management Protocol (SNMP).
- E. ASR Manager can connect to the Internet with HTTPS using a proxy server.
- F. ASR Manager can connect to the Internet directly with HTTPS.
Answer: B,C,E,F
Explanation:
C: If you need to use HTTPS for security purposes, you can set up HTTPS/SSL for the ASR Manager HTTP receiver.
D: As part of the registration process for ASR Manager, you can optionally set the ASR Manager to access the internet through a proxy server.
References:
https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch2_asr_manager.htm#ASRUD137
NEW QUESTION 77
Which three are true concerning Exadata snapshot databases?
- A. They don't support all Exadata features.
- B. They can be created on any type of ASM disk group.
- C. They are supported on non-container databases.
- D. They are integrated with the Multitenant architecture.
- E. They are based on a read-write copy of an existing database.
- F. They can be created only on sparse ASM disk groups.
Answer: C,D,F
Explanation:
A: An Exadata snapshot database can be either a non-container database (non-CDB) or a container database (CDB). Creating an Exadata snapshot database of a CDB enables access to all of the pluggable databases in that container.
C: You can create two types of Exadata snapshots, depending on the current setup of your environment:
* You have a pluggable database (PDB) and want to create a test master from it.
* You have a container database (CDB) and want to create test masters from all its PDBs, or you have a simple non-container database and want to create a test master from it.
D: SPARSE disk group based database snapshots is functionality included in Exadata Storage Software. It requires Exadata Storage Software version 12.1.2.1.0 and Oracle Database 12c version 12.1.0.2 with bundle patch 5 or later. This feature is designed to work on native Exadata ASM storage disk groups. It uses ASM SPARSE grid disk based thin provisioning where snapshot databases created on a SPARSE disk group need only the space for changes plus some metadata, thereby enabling storage efficient snapshot databases.
References:
http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-snapshots.htm#SAGUG-GUID- E1D6EF45-36EF-40E3-A57E-F80B749E6122
http://www.oracle.com/technetwork/database/exadata/learnmore/exadata-database-copy-twp-2543083.pdf
NEW QUESTION 78
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 performing a Smart Scan on this table?
- A. Sort-merge join filtering
- B. MIN/MAX scans
- C. Nested loop join filtering
- D. Predicate filtering
- E. Column filtering
- F. Virtual column filtering
Answer: D,E,F
Explanation:
Explanation/Reference: https://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/1367127.pdf
NEW QUESTION 79
Which three statements are true concerning the configuration of SNMP on an Exadata x5 or x6 Database Machine?
- A. Some SNMP notifications may be configured using the alter cell command on the storage servers.
- B. All SNMP notifications from the storage server ILOMs are sent directly to the Automatic Service Request (ASR) manager.
- C. All SNMP notifications from a database server ILOM are sent directly to the management server (MS) process on the same database server.
- D. All SNMP notifications from a database server ILOM are sent directly to the Automatic Service Request (ASR) manager.
- E. Some SNMP notifications from a storage server ILOM are sent directly to the management server (MS) process on the same storage servers.
- F. The Database Machine internal Cisco Switch communicates directly with the Enterprise Manager agent via SNMP.
Answer: A,D,E
Explanation:
B: You can configure SNMP Trap Destinations for the Exadata Storage Servers with the following command:
# cellcli -e "alter cell snmpSubscriber=(host ='ASR-Manager-name-or-IP- address',port=162,community=public,type=asr)"
D: Exadata Storage Server plug-in
This extends the monitoring of exadata cells in addition to providing a GUI interface. The plug-in uses an SSH connection to the cellmonitor user on the cells and uses list commands only. This is for interactive monitoring. One may also set thresholds using the plug-in which are distinct from any thresholds set using cellcli utility as the celladmin user.
For alerts to be sent to the plug-in, SNMP traps are used as follows:
Cell ILOM alerts are sent to the cell Management Server (MS) via an SNMP trap. The MS then send SNMP notifications onward to the plug-in.
Cell alerts flagged by MS itself, such as cell thresholds being exceeded, or ADR software alerts, are sent to the plug-in using SNMP.
E: Database Server ILOM plug-in
Monitoring databases and their instances, ASM environments, the Grid Infrastructure, and the host software environment are done by Enterprise Manager in the usual way as these are standard targets. But monitoring the hardware for the database servers requires the
ILOM plug-in, as there is no Management Server (MS) on the database servers to receive
SNMP traps from the ILOM. The plug-in will receive sensor state and availability data from the ILOM including alerts based on pre-set ILOM thresholds.
References:
https://dbatrain.wordpress.com/2011/06/
http://docs.oracle.com/cd/E21659_01/html/E21660/z40015671004046509.html
NEW QUESTION 80
Which two statements are true about the EXACLI utility?
- A. It can be executed using the EXADCLI utility.
- B. It supports all CELLCLI commands.
- C. It requires access through a cell user that has role-based privileges granted.
- D. It requires the same privileges as the celladmin linux user to create CELLDISKS and GRIDDISKS.
- E. It can execute commands on multiple cells in parallel.
- F. It can be executed directly on cells.
Answer: A,E
Explanation:
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 output to the centralized management location where the exadcli utility was run.
The exadcli utility runs commands on multiple remote nodes in parallel threads.
NEW QUESTION 81
You have partitioned an X5-2 full rack into two four-node RAC clusters called CLUSA and CLUSB.
No virtualization is used and the storage grid has not been partitioned.
Which two set of files on which servers must be modified after connecting an Exadata storage expansion rack to your X5-2 Exadata Database Machine on the InfiniBand network so that the storage servers in the expansion rack are added to the storage grid?
- A. the CELLIP.ORA files on the database servers in CLUSB
- B. the CELLIP.ORA files on all newly added Exadata storage servers
- C. the CELLINIT.ORA files on the database servers in CLUSB
- D. the CELLINIT.ORA files on the database servers in CLUSA
- E. the CELLIP.ORA files on the database servers in CLUSA
- F. the CELLIP.ORA files on all existing Exadata storage servers
Answer: A,E
Explanation:
The cellip.ora is the configuration file, on every compute node (database server), that tells
ASM instances which cells are available to this cluster.
The cellip.ora file contains the storage cell IP addresses.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-configuring.htm#SAGUG20369
NEW QUESTION 82
Which three are true concerning Exadata Smart Flash Cache on X6 Database Machines with High Capacity Storage Servers?
- A. The "keep" cache is limited to a maximum of 80% of the total Smart Flash Cache capacity.
- B. Single block reads can benefit from Smart Flash Cache.
- C. Smart Scan will always use the Smart Flash Cache for all I/Os for full table scans.
- D. Multiblock reads can benefit from Smart Flash Cache.
- E. Smart Scan will always use the Smart Flash Cache for all I/Os fast full index capacity.
Answer: B,D,E
Explanation:
D: By default Exadata stores only small I/Os in the Exadata Smart Flash Cache. Small I/Os in most cases are single-block reads. During a full table scan Oracle requests blocks in multiblock lumps (by default 16 blocks), and these are
NEW QUESTION 83
Which two statements are true about the X5 Exadata storage server rescue procedure?
- A. The rescue procedure must be used to recover from a failed Exadata storage server software upgrade.
- B. The rescue procedure can be used to restore a corrupt system area.
- C. An Exadata storage server automatically enters the rescue environment when it cannot boot from the system area.
- D. The rescue procedure can be used to repair corruption in an ASM diskgroup.
- E. The rescue procedure can be executed from the CELLBOOT USB flash drive.
Answer: B,E
Explanation:
The rescue procedure is necessary when system disks fail, the operating system has a corrupt file system, or there was damage to the boot area. If only one system disk fails, then use CellCLI commands to recover. In the rare event that both system disks fail simultaneously, you must use the Exadata Storage Server rescue functionality provided on the Oracle Exadata Storage Server Software CELLBOOT USB flash drive.
References: http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm#GUID-
710814E7-4691-49EE-95AD-726D2D6C5BFE
NEW QUESTION 84
......
Certification Training for 1z0-070 Exam Dumps Test Engine: https://www.actual4labs.com/Oracle/1z0-070-actual-exam-dumps.html