Passing exam with 1Z0-048 latest training materials

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 started by CRS but due to multiple instance failures CRS disabled the database instance, thereby preventing further restarts.
• 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 after the system was rebooted, but someone stopped it from within SQL*Plus.
• D. The database instance autostart attribute is set to a value, thus preventing CRS from starting it after a system reboot.
• E. The instance was not started by CRS because its target state was set to "offline" a while before the system was rebooted.

Your company requires that certain database systems be made continuously available because there are revenue-earning applications using Oracle databases. You already use RAC; it is a requirement for the applications to have continuous read and write access to all schema objects in the database during routine DBA maintenance activities. Which three technologies would you recommend for minimizing planned downtime for the application caused by unavailability of data due to those activities? (Choose three.)

• A. Rolling Release Upgrades
• B. Bigfile Tablespaces
• C. Online Table Redefinition
• D. Online Index Rebuild
• E. Fast Start Fault Recovery
• F. Hardware-Assisted Resilient Data

Which CREATE SEQUENCE option is the most scalable?

• A. CACHE ORDER
• B. NOCACHE ORDER
• C. CACHE NOORDER
• D. NOCACHE NOORDER

The infrastructure team at your company requires your advice on maximizing availability using Maximum Availability Architecture and any other features that will help reduce planned downtime both for database instances and for the availability of database objects which applications depend on. You are already running a four node RAC cluster to protect against instance and node failures. Which four would you recommend if they are not already implemented? (Choose four.)

• A. use of the DBMS_REDEFINITION package
• B. use of segment shrinking to reorganize space in tables and indexes
• C. use of online index rebuild
• D. a physical standby database for rolling upgrades
• E. use of ASM
• F. use of freelists to manage space in table and index segments

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. 7,6,3,9.
• B. 5,3,8.
• C. 6,3,9.
• D. 7,6,3,2,9.
• E. 7,6,4,9.
• F. 5,4,8.
• G. 6,4,9.