Latest Oracle 1Z0-048 Actual Free Exam Questions & Community Discussion, Page 6

Question #51

View the Exhibit.
Users complain about the performance of an Oracle database-based application. You are requested to investigate. From Grid Control, you immediately infer that one of the cluster database instances and one of the cluster ASM instances are currently unavailable. You also see that the host where the instance belongs was recently rebooted due to an unknown reason.
Using Grid Control, you restart the instance and performance rapidly improves. You want to determine the cause of the instance startup failure after system boot, and you check the resource profiles on both the database and ASM instances involved.
Why was the instance not started by CRS?

A. The instance was not started by CRS because its target state was set to "offline" a while before the system was rebooted.

B. The database instance could not be started by CRS because this instance depends on an ASM instance, whose autostart attribute indicates that CRS should not start this ASM instance after system boot.

C. The instance was started by CRS but due to multiple instance failures CRS disabled the database instance, thereby preventing further restarts.

D. The instance was started by CRS after the system was rebooted, but someone stopped it from within SQL*Plus.

E. The database instance autostart attribute is set to a value, thus preventing CRS from starting it after a system reboot.

Discussion 0

Correct Answer: B Vote an answer

Question #52

You are the administrator of a Linux-based Oracle cluster. To meet your company's disaster recovery requirements, you have to make backups of the OCR to a tape device. What are your options? (Choose all that apply.)

A. Use RMAN to back up the OCR from disk to tape.

B. Use the OCRCONFIG command to have CRSD write the OCR backup to tape for you.

C. Use your favorite tape backup command to back up the OCR from disk to tape.

D. Use your favorite tape backup command to back up the physical OCR backups from disk to tape.

E. Use the Linux DD command to write the OCR directly to tape.

Discussion 0

Correct Answer: D Vote an answer

Question #53

Your storage administrator informs you about some disk corruption issues in the disk subsystem where your Oracle Cluster Registry (OCR) backups are located. Your storage administrator has resolved these corruption issues by applying a patch to the storage subsystem, but to be sure that the OCR backups are not affected by this problem the administrator wants you to check the integrity of the OCR backups. How would you do this?

A. There is no easy way to check your OCR backups for corruptions.

B. You can check whether the OCR backups are not corrupted by using the OCRCHECK command.

C. You create another physical backup of the OCR backups by using the OCRCONFIG command, and if this succeeds without errors you know that the OCR backups are not corrupted.

D. You dump the OCR backup contents into a text file by using the OCRDUMP command, and if that succeeds without errors you know that your OCR backups are not corrupted.

E. You create a logical export from the OCR backups by using the OCRCONFIG command and analyze the export file for errors.

Discussion 0

Correct Answer: D Vote an answer

Question #54

Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to make sure that another protocol address is tried if the first one fails?

A. FAILOVER

B. TYPE OF SERVICE

C. LOAD_BALANCE

D. SOURCE_ROUTE

Discussion 0

Correct Answer: A Vote an answer

Question #55

You have migrated your 10g R1 cluster to 10g R2. You wish to create multiple copies of the voting disk. What must you consider when doing this?

A. For the voting disk, it is better to rely on multipathing solutions instead of multiplexing.

B. If multiplexing, three voting disks on independent devices is ideal.

C. If multiplexing, two voting disks on independent devices is ideal.

D. Since ASM is the stated direction of Oracle, ASM is the best storage for voting disks.

Discussion 0

Correct Answer: B Vote an answer

Question #56

Your company has certain standard practices for technology and you are configuring ASM disk groups for your four-node RAC cluster. The company guidelines suggest that there is one disk group for the flash recovery area that is shared by all databases and a separate disk group for the database area of all databases. Which three exceptions exist that may require you to create additional disk groups? (Choose three.)

A. Applications using the databases have different Service-Level Agreements for response time and throughput.

B. The retention policy for backups are different for different databases.

C. Some databases operate in ARCHIVELOGMODE and others in NOARCHIVELOGMODE.

D. The disk farm has different disk models with different characteristics and ages.

E. There are large nonpartitioned tables accessed frequently using indexes.

F. Some database instances are shut down every night while others are always running.

G. There are partitioned tables where the older partitions are in read-only tablespaces and seldom accessed, but the more recent partitions are frequently accessed.

Discussion 0

Correct Answer: A,D,G Vote an answer

Question #57

After a failed cluster database creation process, you realize that the contents of the OCR does not
match the current cluster configuration anymore. Before you started the database creation
process, you created a logical backup of the OCR, and now you want to use this logical backup to
bring the OCR contents in sync with the current cluster configuration.
Which commands would you use and in which order to accomplish this task?
1 OCRCONFIG -REPAIR (on the local cluster node only)
2 OCRCONFIG -REPAIR (on all cluster nodes)
3 OCRCONFIG -RESTORE <path name>
4 OCRCONFIG -IMPORT <path name>
5 CRSCTL STOP CRS (on the local cluster node only)
6 CRSCTL STOP CRS (on all cluster nodes)
7 OCRCONFIG -SHOWBACKUP
8 CRSCTL START CRS (on the local cluster node only)
9 CRSCTL START CRS (on all cluster nodes)

A. 5,3,8.

B. 6,4,9.

C. 7,6,3,9.

D. 5,4,8.

E. 7,6,3,2,9.

F. 6,3,9.

G. 7,6,4,9.

Discussion 0

Correct Answer: B Vote an answer

Question #58

Which two statements regarding the installation of the Oracle 10g Database software are true? (Choose two.)

A. The Oracle Universal Installer (OUI) can detect the cluster hardware and allow the user to install the software on the local node or choose all nodes to install the software.

B. The directory path for the Oracle 10g Database software must not be the same as the Oracle 10g Clusterware home directory.

C. If the OUI does not display all of the available nodes in your cluster, check the viability of your cluster and its associated nodes by executing the chkcluster command from $ORA_CRS_HOME/bin directory.

D. The OUI does not support a RAC installation if the Standard Edition is chosen from the Installation Type page.

Discussion 0

Correct Answer: A,B Vote an answer

Question #59

When an ASM instance initializes, ASM discovers and examines the contents of all the disks that are in the paths designated in the ASM_DISKSTRING initialization parameter. Under which four other circumstances does disk discovery take place? (Choose four.)

A. when you run ALTER DISKGROUP...RESIZE DISK

B. when you run ALTER DISKGROUP...ADD DISK

C. when you query V$ASM_DISK

D. when you query VJASMjDPERATION

E. when you query V$ASM_DISKGROUP

Discussion 0

Correct Answer: A,B,C,E Vote an answer

Question #60

You are working with Oracle Support to resolve an issue regarding the Oracle Clusterware software. The Oracle support engineer wants you to upload all relevant CRS log and trace files.
How would you provide al the requested log and trace files?

A. Use Grid Control to collect and send all required log and trace files to Oracle Supporl.

B. Use an operating system command to create an archive with all the log and trace files stored in the ORA_CRS_HOME/log directory and upload the files to Oracle Support.

C. Collect all required log and trace files using the diagcollection.plcommand and upload them to Oracle Support.

D. Upload each and every available log and trace files to Oracle Support.

Discussion 0

Correct Answer: C Vote an answer

Oracle 1Z0-048 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z0-048 Demo