1Z0-058 Exam Questions

Assume that you want to make a connection to the ERP service associated with a newly created RAC database called PROD on a cluster called cluster01 that consists of three nodes: no...

Which two statements are true regarding the Automatic Workload Repository (AWR) In a RAC environment?

When creating an Oracle Cluster database using DBCA the "Memory size (SGA and PGA)" field is supplied on value of 2000 MB. Identify the default block Size used for the database.

Which four statements about mounting ASM cluster file systems are true?

You are allocating space from the ASM disk group for an ADVM volume. What will be the volume extent and Volume Allocation Unit (VAU) if the stripe column is 4 and AU is 1 MB? Which...

You are creating a resource definition called WEBAPP for a web-based application that requires an application called WEBVIP. Both WEBVIP and WEBAPP are normally active on a single...

The database administrator is tasked with creating an ASM disk group. Exadata is not being used. If failure groups are not specified when creating an ASM disk group containing 10 d...

The Oracle Grid Infrastructure administrator runs ocrconfig -backupioc <new_location> after completing the installation of the Grid Infrastructure. What are the two reasons for doi...

From a command line, you can create an ASM volume with the same properties by using either SQL or ASMCMD. Which two commands will create a 500 MB volume called TESTVOL in the ACFSD...

You installed the Oracle Grid Infrastructure on a four-node cluster before discussing the network requirements with the network administrator who was on holiday. You created a sing...

Examine the following output: [oracle@gr5153~]$srvctl add service -d RACDB -s erp -g pool1 -c uniform -y manual [oracle0gr5153~]$srvctl start service -d RACDB -s ERP [oracle@gr5153...

Identify the three valid storage options for Grid Infrastructure voting disk and Install.

Which two conditions are required by the ASM fast mirror resynchronization to track block changes for a set period of time before dropping the disk from the disk group?

I he ASM instance in your environment can support databases from version 10.2.0.4 through 11.2.0.1 You want to use all ASM functionality possible for each database, including OCR a...

A third party application has provided files containing the command syntax required to register and manage the application for high availability with Oracle Grid Infrastructure. Th...

Which command will set full debugging for the communications and resource management components; of the CRS module on nodes host01 and host03?

You have an ASM cluster and you want to terminate all the ASM instances. Assume that the database Instances supported by the ASM are already shut down. What must you know to select...

Which are the key factors that you should consider before converting a single-Instance database Oracle Real Application Cluster (RAC) database to guarantee a successful media recov...

You are managing a three-instance policy-managed RAC database PROD. You created a service called GL for the PROD database by using the following command: oracle@gr7597~]$srvctl add...

Which two statements are true regarding the Active Session History (ASH) reports for RAC?

Which two statements are true about instance recovery in a RAC environment?

You have created four top-level server pools called OLTP, BATCH, DSS, and support for a policy-managed, eight-node cluster. The OLTP pool has two child pools called OLTP_CHILD1 and...

In an ASM instance, there are several parameters that have meanings specific to the ASM. Which parameter is mandatory?

Which three fragments will complete this statement correctly? In a cluster environment, an ACFS volume___________.

Which three actions are required to create a general purpose ASM cluster file system (ACFS) to be automatically mounted by Oracle Clusterware?

Which three statements are true about cluster (OCR) and local registries (OLR)?

In your two-instance RAC database, you find that FAST_START_MTTR_TARGET is set to 300 on both the nodes. The ESTD_CLUSTER_AVAILABLE_TIME column in the V$INSTANCE_RECOVERY view show...

The Global Cache Block Access Latency chart shows high elapsed times. What are two possible causes for this?

orcl1, orcl2, and orcl3 are tnsnames that connect to predefined instances of a three-instance RAC database which uses ASM for shared storage. The database is in archivelog mode. Ex...

Which three steps must be completed to configure Fast Connection Failover for the CRM service with an Oracle Call Interface client?

Assuming a RAC database called ORCL, select three statements that correctly demonstrate management actions for the AP service.

Which two actions in a warehousing RAC database may cause concurrent cross-instance calls leading to I/O contention?

Which three actions would be helpful in determining the cause of a node reboot?

After Oracle Grid Infrastructure has been installed, you should take a few moments to verify the installation. Which two actions would be useful in verifying the installation?

The Instance Initialization parameters are set to: DB_CREATE_FILE_DEST = +DATA DB_CREATE_ONLlNE_LOG_DEST_l = +LOGS DB_CREATE_ONLlNE_LOG_DEST_2 = + FRA The SQL* Plus command "ALTER...

Under which account(s) can the Oracle Clusterware processes run for the Linux platform?