Oracle Oracle Database 1Z0-432 Questions & Answers

• Question 1:

  Which two components are required to set up a SCAN listener for your customer's 12cR1 RAC environment?

  A. 3 virtual IP addresses on the same subnet DB

  B. 3 private IP addresses on the same subnet

  C. 3 private IP addresses on different subnets

  D. One single name that resolves to 3 1Pv4 or 1Pv2 addresses

  E. One single name that resolves to 3 1Pv6 or 1Pv4 addresses

  Correct Answer: AE

• Question 2:

  Which statement about Oracle ASM Cluster File Systems is incorrect?

  A. Oracle ACFS is a multiplatform, scalable file management system.

  B. Oracle ACFS can be used to extend ASM support to all customer files.

  C. Database files and application files are supported by Oracle ACFS.

  D. Oracle ACFS conforms to POSIX standards on Linux and UNIX platforms as well as Windows standards.

  E. Video, images, audio, and other general-purpose files are not supported by Oracle ACFS.

  Correct Answer: E

• Question 3:

  Under which condition can Oracle Automated Storage Management (ASM) be considered to be a component of the Oracle Clusterware technology stack?

  A. Oracle Cluster Registry (OCR) is stored on Oracle ASM

  B. Oracle Local Registry (OLR) is stored on a clustered file system (OCFS/ACFS/DBFS)

  C. Both Oracle Cluster Registry and Oracle Local Registry are stored on Oracle ASM

  D. Oracle ASM can never be considered a component of Oracle Clusterware

  E. Oracle ASM can be considered a component of Oracle Clusterware technology stack only when deployed on engineered systems such as Exadata or Oracle Database Appliance

  Correct Answer: A

• Question 4:

  What is the correct syntax to put a DATA1 disk offline for a failure group FG1, and drop it after five minutes?

  A. ALTER DISKGROUP data OFFLINE DISK DATA1 IN FAILGROUP FG2 DROP AFTER 5m;

  B. It is not possible to drop it after five minutes.

  C. It is not possible to specify a disk In a FAILGROUP.

  D. ALTER DISKGROUP data OFFLINE DISKS IN FAILGROUP FG2 DROP AFTER 5m;

  E. ALTER DISKGROUP data OFFLINE DISK DATA1 IN FAILGROUP FG2 DROP AFTER 5 minutes;

  Correct Answer: A

• Question 5:

  You are upgrading from an earlier version of Oracle Clusterware to Oracle Clusterware 12cR1 and want to store the OCR in an Oracle ASM disk group. What are the correct steps required to accomplish this task?

  A. Set the ASM Compatibility attribute to 10.2.0.1 or later. Verify you are running the correct version of Oracle Clusterware 12cR1 by issuing $crsctl query crsactiveversion Using srvctl create a disk group appropriately sized for the OCR you are migrating to ASM. As root, issue #ocrcheck -add +DG_OCR As root, issue # ocrcheck --delete old_ocr_location

  B. Set the ASM Compatibility attribute to 10.2.0.2 or later. Verify you are running the correct version of Oracle Clusterware 12cR1 by issuing $crsctl query crsactiveversion Using acmca configure and start Oracle ASM on all cluster nodes. Using asmca create a disk group appropriately sized for the OCR you are migrating to ASM. As root, issue #ocrcheck -add +DG_OCR As root, issue # ocrcheck -delete old_ocr_location

  C. Set the ASM Compatibility attribute to 10.2.0.2 or later. Verify you are running the correct version of Oracle Clusterware 12cR1 by issuing $crsctl query crsactiveversion Using crsctl, configure and start Oracle ASM on all cluster nodes. Using crsctl create a disk group appropriately sized for the OCR you are migrating to ASM. As grid infrastructure owner, issue # ocrconfig -add +DG_OCR As grid infrastructure owner, issue # ocrconfig -delete old ocr location

  D. Set the ASM Compatibility attribute to 10.2.0.2 or later. Verify you are running the correct version of Oracle Clusterware 12cR1 by issuing $crsctl query crsactiveversion Using acmca configure and start Oracle ASM on all cluster nodes. Using asmca create a disk group appropriately sized for the OCR you are migrating to ASM. As root, issue #ocrdump -add +DG_OCR As root, issue # ocrdump -delete old_ocr_location

  Correct Answer: C

• Question 6:

  You want to convert an Oracle Clusterware Standard Cluster to an Oracle Flex Cluster. Which commands will you execute?

  A. crsct1 config gnscrsct1 add gns -vip myvip | IP addresssrvct1 stop cluster -node mynodesrvct1 modify cluster node flex

  B. srvct1 get cluster mode status# if GNS not configured then must be configured with a fixed VIP - find GNSstatus srvct1 set config gns

  srvct convert cluster mode flex

  C. crsct1 get cluster mode status# if GNS not configured then must be configured with a fixed VIP - find GNSstatus srvct1 config gnscrsct1 set clustermode flex crsct1 stop crscrsct1 start crs -wait

  D. crsct1 set clusterware hub crsct1 set clustermode flex srvct1 show cluster mode status

  Correct Answer: C

• Question 7:

  Identify three characteristics of a RAC 12cR1 service.

  A. Service Time Service name

  B. Instance Preference

  C. Server Pool Assignment

  D. Database Edition

  E. Cloud Policy

  Correct Answer: BCD

• Question 8:

  After creating a volume and file system for a new Oracle ASM Cluster File system, you must associate the ASM volume name with a mount point. Which command creates this registration?

  A. acfsutil -r /dev/asm/volumel-123 /mnt/acfs1

  B. acfsutil-r -a /dev/asm/volumel-123 -ro /mnt/acfs1

  C. acfsutil register -v /dev/asm/volumel-123 /mnl/acfs1

  D. acfsutil registry -a /dev/asra/volumel-123 /mnt/acfs1

  Correct Answer: D

• Question 9:

  Which statement best describes the interaction between an Oracle ASM instance and the Oracle Database?

  A. Oracle ASM provides an access path between a database instance and storage.

  B. A database instance uses an extent map provided by Oracle ASM to access data files

  C. Oracle ASM provides storage services only and does not interact with the database.

  D. An Oracle Database must use Oracle ASM in a high availability configuration.

  Correct Answer: B

• Question 10:

  Which three options can be used for storing database files in an Oracle Real Application Clusters database?

  A. Shared disk partitions as raw devices

  B. Shared disks managed by Oracle Automatic Storage Manager (ASM)

  C. Local file system

  D. Shared disk partitions as block devices

  E. Network file system (NFS) on a certified network-attached storage (NAS) filer

  F. Oracle Automatic Storage Management Cluster File System (ACFS)

  Correct Answer: BEF