Question 1.
Which statistics enable you to view the impact of SQL statements on input/output (I/O) statistics?

A. file statistics in Performance Manager
B. statistics obtained from the sar and vmstat commands
C. sorts and parse calls values in Top SQL
D. buffer gets and disk reads values in Top SQL
E. CPU chart group in Performance Manager

Answer: D

Question 2.
Which Oracle Net utility or tool is integrated with Oracle Enterprise Manager?

A. Oracle Net Configuration Assistant
B. Oracle Names Control utility
C. Oracle Connection Manager Control utility
D. Oracle Net Manager
E. Listener Control utility

Answer: D

Question 3.
You have specified the configuration in the sysctl.conf file. However, when you restart the system, Linux does not start. 

Which statement describes the steps that you would take to troubleshoot the problem?

A. Use the root login to access the system in run level 6 and edit the /root/.bashrc file.
B. Use the root login to mount the file system and edit the sysctl.conf file.
C. Use the boot loader to enter the emergency mode and switch to run level 3.
D. Use the boot loader program to access the available kernels and recompile the kernel.
E. Use the single-user mode to access the /proc file system and edit the kernel parameters.
F. Use the boot loader program to boot into run level 1 and edit the sysctl.conf file.

Answer: F

Question 4.
Which operating system (OS) group normally manages the Oracle database files?

A. apache
B. oper
C. users
D. oinstall
E. root
F. dba

Answer: F

Question 5.
Which two statements are true about %user to %system ratio for Oracle server processes?
(Choose two.)

A. If the %user to %system ratio is less than 60/40, then you must look for input/output (I/O) or 
     virtual memory problems.
B. If the %user to %system ratio is less than 60/40, then you must check sar -wW for swapping 
     activity.
C. If the %user to %system ratio is greater than 60/40, then you must tune the application code.
D. If the %system to %user ratio is greater than 40/60, then you must measure the data flow 
    between disk devices.
E. If the %user to %system ratio is greater than 60/40, then you must run vmstat for switching 
     activity.
F. If the %system to %user ratio is greater than 40/60, then you must check the division of work 
    within the system.

Answer: A, C

Question 6.
You plan to start with an Oracle9i stand-alone database system and then upgrade to a Real Application Cluster (RAC) environment in the near future. 

You need to ensure that the process of migrating an Oracle instance and database to enable RAC goes well. 

Which file system would you recommend for the data files in the stand-alone database system?

A. ext3
B. ReiserFS
C. ext2
D. Oracle Cluster File System (OCFS)
E. General Parallel File System (GPFS)
F. Network File System (NFS)

Answer: D

Question 7.
Examine the following SELECT command: 

SELECT sum(pga_alloc_mem) FROM V$PROCESS; 

Which statement about this command is correct?

A. This command displays the PGA size of each process that is started up by the instance.
B. If this command displays low values, then increase the PGA_AGGREGATE_TARGET value.
C. This command displays the size of each SQL work area that is allocated to an instance.
D. This command displays the Program Global Area (PGA) size allocated to an instance.

Answer: D

Question 8.
Which three methods can you use to correlate Statspack and operating system (OS) measurements? (Choose three.)

A. Use Oracle Enterprise Manager (OEM) Outline Management to manage plan stability outlines.
B. Use the at command to schedule the OS statistics through OEM.
C. Use the cron utility to schedule a job to collect database and OS statistics.
D. Use OEM Performance Manager to view and record OS statistics.
E. Print Statspack reports from sar .
F. Run Statspack and the sar task continuously.

Answer: C, D, F

Question 9.
Which two statements are true about Oracle Clustered File System (OCFS)? (Choose two.)

A. You can use OCFS for database files as well as general files.
B. There is no limit on the number of files on OCFS.
C. Standard file system commands, such as mkdir , rmdir , and mv , are available on OCFS.
D. You can create an OCFS on Logical Volume Manager (LVM).
E. You must modify Linux kernel parameters before mounting OCFS.

Answer: B, C

Question 10.
What are the four roles of the semaphores parameters? (Choose four.)

A. The semmsl parameter sets the maximum number of semaphores per set.
B. The semopm parameter sets the maximum number of operations per semop call.
C. The semopm parameter sets the total number of semaphores in the system.
D. The semmns parameter sets the total number of semaphores in the system.
E. The semmsl parameter sets the maximum number of semaphore sets.
F. The semmni parameter sets the maximum number of operations per semop call.
G. The semmns parameter sets the maximum number of semaphores per set.
H. The semmni parameter sets the maximum number of semaphore sets.

Answer: A, B, D, H

	Web www.certsbraindumps.com