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

After adding two new high-performance nodes to your existing eight-node Oracle Database cluster, you decide to remove the two oldest nodes from your cluster. You start by removing the instances from the nodes you are about to remove by using the Database Configuration Assistant (DBCA). During the execution, a problem arises and the DBCA terminates with a fatal exception. Before you contact Oracle Support, you want to create a Java-based tool trace file so that Oracle Support can assist you in resolving this issue as quickly as possible. How would you create this trace file?

You decide to change the redo thread of one of your database instances.
Now you have only two threads: thread 1 is currently being used by instance RAC01, and thread 2 is currently being used by instance RAC02.
In which three orders could you perform the following commands to add thread 3 to your
database, and ensure that instance RAC01 is using thread 3? (Choose three acceptable orders.
1 srvctl stop instance -d RACDB -i RAC01
2 ALTER DATABASE ENABLE THREAD 3;
3 ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 6;
4 srvctl start instance -d RACDB -i RAC01
5 ALTER SYSTEM SETthread=3 SCOPE=SPFILE SID='RAC01';
6 ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 5;

The following query shows four MEMBER disks and three CANDIDATE disks.
SQL> select name, header_status, path from v$asm_disk;
NAME HEADER STATUS PATH
CANDIDATE /dev/rdsk/diska5
CANDIDATE /dev/rdsk/diska6
CANDIDATE /dev/rdsk/diska7
DISK01 MEMBER /dev/rdsk/diska1
DISK02 MEMBER /dev/rdsk/diska2
DISK03 MEMBER /dev/rdsk/diska3
DISK04 MEMBER /dev/rdsk/diska4
7 rows selected.
Using SQLPIus you want to add /dev/rdsk/diska5 and /dev/rdsk/diska6 to diskgroup DGROUP1
DGROUP1 is currently mounted.
Pick the statement that would fail to add diska5 and diska6.

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.)

You are requested to make your Web server, which accesses a clustered Oracle database, highly available. Which solution would you propose?

Your company asked you to implement RAC to enhance the scalability and availability of the database that you manage. Your coworker suggested that you use ASM as the only storage option. However, you implemented RAC with Automatic Storage Management (ASM) as well as OCFS as storage options. What are the reasons for implementing both OCFS and ASM as storage options? (Choose all that apply.)

Which two statements about parallel recovery in a RAC environment are true? (Choose two.)

You are about to bring your Web server under control of the Oracle Clusterware to make it highly available. Which actions do you need to perform to accomplish this task? (Choose all that apply.

Which two statements regarding Oracle Clusterware are correct? (Choose two.)

Richard is a senior DBA and has prepared a plan for RAC implementation in his company. Given below are some of the tasks that he would perform as part of the plan: 1) Creating the Raw Devices Mapping file 2) Creating database services 3) Binding the partitions to raw devices 4) Creating the Voting Disk file 5) Creating an initialization parameter file 6) Creating the Oracle Cluster Registry (OCR) file 7) Creating the tnsnames.ora file 8) Creating the database control file
During the creation of the RAC database, Richard can use the Database Configuration Assistant (DBCA) to perform some of these steps but not all of them. Which steps should be completed before Richard starts creating the database by using DBCA?