Oracle 1Z0-932 Online Practice Questions and Exam Preparation

Oracle 1Z0-932 Online Questions & Answers

• Question 1:

  Which statement is true about DB Systems?

  A. Data Guard as a Service is offered between regions.
  B. You cannot manage the database as sys/sysdba.
  C. You have full control over the automatic backup schedule and retention periods.
  D. You can manage Oracle database initialization parameters at a global level.
  A. Data Guard as a Service is offered between regions.
  C. You have full control over the automatic backup schedule and retention periods.

• Question 2:

  You are running your warehouse using Autonomous Data Warehouse (ADW) service and you noticed that a newly configured batch job is always running in serial even through nothing else is running in the database. All your jobs are configured to run with parallelism enabled.

  What could be the reason for this batch job to run in serial?

  A. The batch job depends on only one table and parallelism cannot be enabled on single-table queries.
  B. The parallelism of batch job depends on the number of ADW databases involved in the query.
  C. The new batch job is connected to LOW consumer group.
  D. The new batch job runs on database tables that are not enable for parallel execution.
  E. Parallelism on the database is controlled by the application, not the database.
  C. The new batch job is connected to LOW consumer group.

• Question 3:

  Which two statements are true about data guard service on DB Systems in Oracle Cloud Infrastructure (OCI)?

  A. Data guard implementation requires two DB Systems, one running the primary database on a virtual machine and the standby database running on bare metal.
  B. Data guard implementation requires two DB Systems, one containing the primary database and one containing the standby database.
  C. Data guard configuration on the OCI is limited to a virtual machine only.
  D. Both DB Systems must use the same VCN, and port 1521 must be open.
  B. Data guard implementation requires two DB Systems, one containing the primary database and one containing the standby database.
  D. Both DB Systems must use the same VCN, and port 1521 must be open.

  ---

  explanation:

  Reference: https://docs.cloud.oracle.com/iaas/Content/Database/Tasks/usingdataguard.htm

• Question 4:

  You have been notified of an application failure indicating that one or more of the Oracle Cloud Infrastructure (OCI) resources have become unavailable. After scanning the Compute and Database consoles, you notice that one of the DB Systems is missing.

  What would you do to identify the reason for this missing resource?

  A. Navigate to the Audit console and search the previous 24 hours for all Delete actions to get a list of any resource that was deleted in the past 24 hours.
  B. Create a serial console connection to the DB System that does not appear in the management console. Connect to the serial console connection, and then review the system logs under /var/log/messages.
  C. View the service limits associated with your account to ensure that you have not exceeded the available number of DB system in your tenancy.
  D. Navigate to the Audit console and search the previous 24 hours for all List actions to get a list of every event that occurred in the past 24 hours.
  D. Navigate to the Audit console and search the previous 24 hours for all List actions to get a list of every event that occurred in the past 24 hours.

• Question 5:

  Which two options are available when configuring DNS resolution for your virtual cloud network? (Choose two.)

  A. Internet and custom resolver
  B. Google DNS servers
  C. custom resolver
  D. Internet and virtual cloud network (VCN) resolver
  C. custom resolver
  D. Internet and virtual cloud network (VCN) resolver

  ---

  explanation:

  Reference: https://docs.cloud.oracle.com/iaas/Content/Network/Concepts/dns.htm

• Question 6:

  Which statement is true about cloning a volume?

  A. You can clone a volume in another region.
  B. You need to detach a volume before cloning it.
  C. A cloned volume is the same as a snapshot that has a dependency on the source volume.
  D. You can change the block volume size when cloning a volume.
  C. A cloned volume is the same as a snapshot that has a dependency on the source volume.

• Question 7:

  You are tasked with creating a highly available clustered application on Oracle Cloud Infrastructure consisting of three nodes. The round-trip latency between nodes must be less than 500ps (micro-seconds) and your cluster should be

  resilient to hardware failure.

  What is the recommended deployment strategy?

  A. Deploy the cluster nodes in a single region and deploy each node into a different AD. Select the same fault domain in each AD to ensure consistency.
  B. Deploy the cluster nodes in two separate regions and take advantage of multiple availability domains (ADs) in each region.
  C. Deploy the cluster nodes in a single region and deploy each node into a different AD.
  D. Deploy the cluster nodes in a single region and deploy each node in different fault domains within a single AD.
  D. Deploy the cluster nodes in a single region and deploy each node in different fault domains within a single AD.

• Question 8:

  You have provisioned an Autonomous Transaction Processing (ATP) database and logged into the ATP service console. What are three abilities that can be performed from this service console? (Choose three.)

  A. scale up/down the CPUs
  B. create ATP database users
  C. reset the admin password
  D. set resource management rules
  E. monitor database activity and SQL queries
  A. scale up/down the CPUs
  D. set resource management rules
  E. monitor database activity and SQL queries

• Question 9:

  You have five different company locations spread across the US. For a proof-of-concept (POC) you need to setup secure and encrypted connectivity to your workloads running in a single virtual cloud network (VCN) in the Oracle Cloud

  Infrastructure Ashburn region from all company locations.

  What would meet this requirement?

  A. Create five internet gateways in your VCN and have separate route table for each internet gateway.
  B. Create five virtual circuits using FastConnect for each company location and terminate those connections on a single dynamic routing gateway (DRG). Attach that DRG to your VCN.
  C. Create five IPsec connections with each company location and terminate those connections on a single DRG. Attach that DRG to your VCN.
  D. Create five IPsec VPN connections with each company location and terminate those connections on five separate DRGs. Attach those DRGs to your VCN.
  C. Create five IPsec connections with each company location and terminate those connections on a single DRG. Attach that DRG to your VCN.

• Question 10:

  You must implement a backup solution for your Autonomous Data Warehouse (ADW) that will enable you to restore data as old as one year with a recovery point objective (RPO) of 10 days. Which database backup strategy would you select?

  A. Take weekly manual backups to supplement the automated backups and preserve them for 12 months.
  B. Use the automated backups.
  C. Take monthly manual backups to supplement the automated backups and preserve them for 12 months.
  D. Take quarterly manual backups to supplement the automated backups and preserve them for 12 months.
  A. Take weekly manual backups to supplement the automated backups and preserve them for 12 months.