1Z0-058 Exam Questions
136 real 1Z0-058 exam questions with expert-verified answers and explanations. Page 1 of 3.
- Question #1
You want to reorganize the DATA diskgroup while continuing database operations. The DATA diskgroup was created using normal redundancy having one disk per failure group. The two di...
- Question #2High Availability
Which two Cluster ware stack administration actions must be performed as the root user?
Clusterware administrationroot user operationsRAC stack managementClusterware startup - Question #3High Availability
You are ready to add two new nodes called RACNODE5 and RACNODE6 to your existing four- node cluster using addNode.sh You have run cluvfy -peer to check the new nodes against a refe...
RAC node additionaddNode.shGrid Infrastructurecluster configuration - Question #4Administer Oracle Clusterware Management and Diagnostics
Which three statements are true about the logging or tracing of Java-based Oracle tools?
srvm_traceJava tools tracingDBCA loggingSRVCTL tracing - Question #5Administer ASM
Choose three correct statements about ASM disk group attributes set from the ASMCA Create Disk Group
ASM disk group attributescompatible.asmcompatible.rdbmsADVM compatibility - Question #6Administer Oracle Clusterware
A policy-managed RAC database that hosts the ACCOUNTS service has only three instances running rather than the usual four on a six-node cluster. Five of the six cluster nodes are a...
server pool stateCSSDVISIBLE statecrsctl status server - Question #7Understand Oracle Grid Infrastructure Architecture
You have configured your eight-node cluster to use GNS. The network administrator has established delegated subdomain for the Custer which is MYCLUSTER.EXAMPLE.COM. DHCP has been c...
GNSSCAN VIPsNode VIPsGNS VIP - Question #8Install Oracle Grid Infrastructure
On the OUI Grid Plug and Play information page, you can configure GRID Naming Service (GNS). What will be the SCAN Name field default to if you enter cluster01 in the cluster Name...
GNS subdomainSCAN nameOUI Grid Plug and Playcluster naming - Question #9Administer Oracle Clusterware
You have a four-node cluster with four node VIPS and three scan VIPS already In use after Oracle Grid Infrastructure installation. You plan to manage a customer-developed, web-base...
VIP application resourcehigh availabilitypublic network adapterroot user resource - Question #10
In the high availability services' provided by Oracle Clusterware are used to protect Oracle resource such as RAC database instances, RAC database services, and other components of...
- Question #12Administer RAC Database Services
You are managing a policy-managed database called RACDB. Examine the output given below: You used these commands to add the service erp: Which statement is true regarding the srvct...
srvctl stop instancepolicy-managed databaseservice failoverRAC services - Question #13Administer RAC Database Services
Which three statements are true about the management of Oracle Services?
Oracle servicesworkload managementsrvctlservice-level requirements - Question #14Manage Global Resources
You notice that there is a very high percentage of wait time for RAC database that has frequent insert operations. Which two recommendations may reduce this problem?
buffer busy waitssequence cachereverse key indexesextent management - Question #15Manage Global Resources
What does a high "gc current block busy" event value indicate?
gc current block busyGCS wait eventscache fusionblock contention - Question #16Administer Oracle Clusterware Management and Diagnostics
Examine the following details for a six-Instance RAC database: What is the most prominent problem indicated by the above output?
interconnect diagnosticsglobal cache waitsRAC performancefaulty interconnect - Question #17Manage Global Resources
Examine the following details from the AWR report for your three-instance RAC database: Which inferences is correct?
AWR reportglobal cache efficiencycr block requestsRAC wait events - Question #18Install and Administer Oracle RAC
You are managing a policy-managed Real Application Cluster (RAC) database, RACDB with Oracle Managed Files (OMF) enabled. Examine the following outputs: You added a new server to t...
OMFredo log threadspolicy-managed RACserver pool expansion - Question #19Administer RAC Database Services
Which three statements ate true about services and Transparent Application Failover (TAF)?
TAFservice failoverBASIC PRECONNECTservice TAF policy - Question #20Install and Administer Oracle RAC
You are managing a single-instance database and your company wants to convert the single instance database to an Oracle RAC database. You plan to use the rconfig utility to accompl...
rconfigsingle-to-RAC conversionprerequisitesOracle Clusterware installation - Question #21Administer RAC Database Services
The DBA has executed the command: srvctl add service -d PROD -s BATCH -g SP2 -c singleton -y manual What is the result of this command?
srvctl add servicesingleton serviceserver poolmanual management policy - Question #22Manage Global Resources
You are managing a policy-managed three-instance RAC database. You ran database ADDM for the database and noticed gc current block congested and gc cr block congested waits. What a...
gc current block congestedgc cr block congestedGCS delayinterconnect latency - Question #23Install and Administer Oracle RAC
Which two statements are true regarding the Average Active Sessions chart on the performance page
Average Active SessionsEnterprise Managerwait class aggregationcluster performance monitoring - Question #25Manage RAC Backups and Recovery
Your two-instance RAC database is running in ARCHVELOG. The instance running on node1., fails and this failure Is ejected by the instance running on node2,which indicates the recov...
instance recoverySMONGRD reconfigurationredo log reading - Question #26Administer Oracle Clusterware
You have two administrator-defined server pools on your eight-node cluster called OLTP and DSS. Hosts RACNODE3, RACNODE4, and RACNODE5 are currently assigned to the DSS Pool. Hosts...
rolling patchGrid Infrastructure versionactive versionserver pool patching - Question #27Administer ASM
The disk groups on the current ASM instance at version 11.2 were configured to support a version 10.2 database instance. The 10.2 instance has the COMPATIBLE parameter defined as 1...
compatible.rdbmsdisk group attributesASM compatibilitydatabase upgrade - Question #28Install Oracle Grid Infrastructure
Your network administrator informs you that the Internet service provider is being changed in a month's time in conjunction with a data center move. You are asked to plan for the c...
GNSSCAN VIPsnode VIPsoifcfg - Question #29Administer ASM
The System Global Area (SGA) for the ASM instance contains distinct memory areas. Choose three areas that are contained within the ASM SGA.
ASM SGAshared poollarge poolASM cache - Question #30Install Oracle Grid Infrastructure
During the installation of Oracle Grid Infrastructure 11.2, it is possible to incorporate failure isolation support by using Intelligent Platform Management Interface (IPMI). Which...
IPMIBMCfailure isolationGrid Infrastructure installation - Question #31Administer ASM
mounted: DATA and DATA2, but the results of the SHOW PARAMETER ASM_DISKGROUPS command show only DATA as below: What could have caused the DATA2 dlskgroup to be mounted based on the...
ASM_DISKGROUPS parametervoting filesdisk group automountV$ASM_DISKGROUP - Question #32Understand Oracle Grid Infrastructure Architecture
ETH0 is the public interface on all your RAC nodes. ETH1 is the private interface on all your RAC nodes for use with the cluster interconnect. ETH2 is used on all the RAC nodes for...
SCAN VIPsnode VIPspublic interfacenetwork configuration - Question #33Understand Oracle Grid Infrastructure Architecture
Identify the three forms of link aggregation that are supported by Oracle Ciusterware for the interconnect.
link aggregationcluster interconnecthigh availabilityactive/active - Question #34Administer ASM
Which three statements are true about ASM performance and scalability?
ASM performancedisk group designscalabilitydiskgroup best practices - Question #35Administer Oracle Clusterware
Your Apache-based application resource called MyApp has a VIP application resource definition and an application resource definition. The application is administrator managed and i...
crsctl relocateapplication resourceVIP resourceadministrator managed - Question #36Administer Oracle Clusterware
You plan to use Enterprise Manager to locate and stage patches to your Oracle Home. The software library has been configured to be downloaded to /u01/app/oracle and your "My Oracle...
provisioning daemonpafctldeployment procedure managerEnterprise Manager - Question #37Administer Oracle Clusterware
How does the Oracle Grid Infrastructure administrator determine the location of the Oracle Clusterware voting disk?
voting disk locationcrsctl query cssOracle Clusterware files - Question #38Administer Oracle Clusterware
Which three are components of Oracle HA Framework for protecting third-party applications using Oracle Clusterware?
Oracle HA Frameworkthird-party applicationsaction programsapplication VIPs - Question #39Administer ASM
What is the recommended procedure to shut down an ASM instance with a mounted ACFS file system at /u01/app/oracle/acfsmounts/vol1, where the volume name is VOL1 and the disk group...
ACFS dismountASM shutdownfile system unmountACFS administration - Question #40Understand Oracle Grid Infrastructure Architecture
Which interconnect design is NOT supported for Oracle Clusterware?
interconnect designcrossover cablecluster networkunsupported configuration - Question #41Administer Oracle Clusterware Management and Diagnostics
Which three statements are true about Clusterware resource debugging?
Clusterware debuggingcrsctl loggingresource diagnosticsdebug collection - Question #42Administer ASM
Various clients can access and manipulate ASM files. Which two statements are true?
ASMCMD cpDBMS_FILE_TRANSFERASM file accessASM file management - Question #43Administer Oracle Clusterware Management and Diagnostics
The Oracle Grid Infrastructure administrator wants to perform daily checks on the integrity of the Clusterware files. Which three steps can be performed to determine the health of...
OCR health checkvoting disk integrityocrcheckcluvfy - Question #44Administer ASM
You decide to create a snapshot of your ACFS for backup and recovery purposes. Which two tools are available to do this?
ACFS snapshotacfsutilEnterprise ManagerACFS backup - Question #45Administer ASM
Directory structure in ASM has a default of +<diskgroup>/<database>/<filetype>/<filename>. The EXAMPLE tablespace was created with: CREATE TABLESPACE EXAMPLE DATAFILE '+DATA/ORCL/o...
ASM directory structureASM aliasesASMCMD lsV$DBFILE - Question #46Administer ASM
Choose the two correct commands that will successfully create an ASM cluster file system (ACFS) and register the mount point on a Linux/UNIX system.
ACFS creationmkfs acfsacfsutil registrymount point registration - Question #47Administer Oracle Clusterware Management and Diagnostics
Which three statements are true about Oracle Clusterware component log files?
log filesunified directoryClusterware diagnosticsGrid Infrastructure - Question #48Administer Oracle Clusterware
Your cluster has Oracle Grid Infrastructure installed and working to support RAC databases and all the related resources. There is also a vendor HA software on the cluster providin...
application VIPresource definitionaction programHA framework - Question #49Install Oracle Grid Infrastructure
The original cluster on RACNODE1, RACNODE 2, RACNODE 3, and RACNODE4 had the Oracle Grid Infrastructure installed to support Grid Naming Service (GNS). What should be done to verif...
cluvfynode additionGNSpost-install verification - Question #50Administer Oracle Clusterware
Which three describe how often OCR backups are taken and how many are retained, according to the default backup schedule?
OCR backupbackup scheduleretention policyClusterware backup - Question #51Administer Oracle Clusterware
The Oracle Grid Infrastructure administrator decides to make more copies of the voting disks that are currently stored in the ASM disk group +VOTE. How can this be done?
voting diskcrsctlASM disk groupdisk redundancy - Question #52Install Oracle Grid Infrastructure
You plan to remove a node called RACNODE4 from a four-node cluster. The cluster is running Oracle Grid Infrastructure 11g Release 2 and there is also a database home with cluster d...
node deletionCSS pinningolsnodescluster node management