Prep and try our 1Z0-048 valid and latest training questions & answers

Oracle 1Z0-048 Exam Overview:

Oracle 1Z0-048 Exam Syllabus Topics:

Oracle Database 10g R2: Administering RAC Sample Questions:

Question 1

View the Exhibit and examine an installation step of Oracle Enterprise Manager Grid Control 10gR2 to manage your RAC installation. You entered the host name but you are not sure about the port number. Thefollowing is the list of port numbers from the host ed-otraclin17b.us.oracle.com:

A. 3938
B. 5561
C. 1158
D. 4889
E. 1521

Question 2

When do you get the first notification after you execute the following command on instance
RDBA1?
execDBMS_SERVER_ALERT.SET_THRESHOLD(-
METRICSJD => dbms_server_alert.elapsed_time_per_call,
WARNINGJDPERATOR => dbms_server_alert.operator_ge,
WARNING_VALUE => 500000',
CRITICAL_OPERATOR => dbms_server_alert.operator_ge,
CRITICAL_VALUE => 750000',
OBSERVATION_PERIOD => 15,
CONSECUTIVEJDCCURRENCES => 3,
INSTANCE_NAME => 'RDBA1',
OBJECT_TYPE => dbms_server_alert.object_type_service,
OBJECT_NAME =>'ERP");

A. when the average elapsed time per call for the ERP service over a 15-minute period exceeds
0.5 seconds three consecutive times
B. when the average elapsed time per call for the ERP service over a 45-minute period exceeds
0.75 seconds
C. when the average elapsed time per call for the ERP service over a 45-minute period exceeds
0.5 seconds
D. when the average elapsed time per call for the ERP service over a 15-minute period exceeds
0.75 seconds three consecutive times

Question 3

You are running a two-instance database with six redo log groups defined and decide to add a third thread to support a third database instance on the third node of the cluster. Which three commands would you issue to achieve this using command line administration? (Choose three.)

A. ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 7;
B. ALTER SYSTEM ENABLE THREAD 3;
C. ALTER DATABASE ENABLE THREAD 3;
D. ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 8;
E. ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 7;
F. ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 8;

Question 4

You want check whether the group services node application is running on all the nodes in your cluster before you create a cluster database. Which utility can you use to make sure the node application is running on all nodes in the cluster?

A. crs_stat
B. addnode.sh
C. Isnrctl
D. crsctl
E. onsctl

Question 5

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. There are partitioned tables where the older partitions are in read-only tablespaces and seldom accessed, but the more recent partitions are frequently accessed.
B. Applications using the databases have different Service-Level Agreements for response time and throughput.
C. Some database instances are shut down every night while others are always running.
D. The retention policy for backups are different for different databases.
E. The disk farm has different disk models with different characteristics and ages.
F. There are large nonpartitioned tables accessed frequently using indexes.
G. Some databases operate in ARCHIVELOGMODE and others in NOARCHIVELOGMODE.

Solutions: