|
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
Question 11.
Which information about your system will help you to determine if CPU is a bottleneck?
(Choose three.)
A. bigpages
B. pages in
C. average load
D. load factor
E. number of CPUs
Answer: C, D, E
Question 12.
Which three statements about the root.sh script are correct? (Choose three.)
A. It updates the contents of the /etc/oraInst.loc file.
B. It must be executed as user oracle .
C. It changes the permissions on the dbsnmp executable.
D. It places the oraenv , coraenv , and dbhome scripts in the local bin directory.
E. It creates and populates the oratab file.
F. It must be run before running the Oracle Universal Installer (OUI).
Answer: C, D, E
Question 13.
Which two statements are true about Oracle Clustered File System (OCFS)? (Choose two.)
A. You can use OCFS partitions for archive logs.
B. OCFS is a file system designed specifically for Oracle on Linux operating system.
C. OCFS can be automatically mounted at startup.
D. You must modify Linux kernel parameters before mounting OCFS.
E. Linux developers cannot access OCFS source code.
Answer: A, C
Question 14.
All your sessions are using shared servers. Examine the following SQL command:
SELECT sum(value) FROM v$sesstat, v$statname
WHERE name = 'session uga memory'
AND v$sesstat.statistic# = v$statname.statistic#;
Which statement best describes this SQL command?
A. This SQL command enables you to monitor the PGA memory allocated from the shared pool.
B. This SQL command enables you to monitor memory usage by each user process.
C. This SQL command enables you to monitor system memory usage.
D. This SQL command enables you to monitor the Program Global Area (PGA) memory allocated
from the SGA memory.
E. This SQL command enables you to monitor overall memory usage.
Answer: D
Question 15.
You have successfully installed the Intelligent Agent (IA) on Oracle 9.2. You executed the following command to start the I A:
lsnrctl dbsnmp_start
You received the following error message:
NL-00853: undefined command "dbsnmp_start".
What would you do to rectify the problem and start IA ?
A. Set the TNS_ADMIN environment variable to point to the location of listener.ora and then
execute the lsnrctl dbsnmp_start command.
B. Execute the agentctl start agent command.
C. Start the HTTP Server and then execute the lsnrctl dbsnmp_start command.
D. Configure Oracle Simple Network Management Protocol (SNMP) and then execute the lsnrctl
dbsnmp_start command.
E. Run the root.sh script and then execute the lsnrctl dbsnmp_start command.
F. Create the snmp.ora file in Oracle home directory for the agent and then execute the lsnrctl
dbsnmp_start command.
Answer: B
|
Question 1.
Which service component within the design phase does the following describe? Consider the customer's defined business requirements and the associated performance, availability, resiliency, maintainability, resource capacity, and security criteria used to measure and assure the delivery of the required services.
A. Staging Plan
B. Implementation Plan
C. Business Plan
D. Detailed Design Validation
E. Project Kick-off
Answer: B
Question 2.
Which service component within the prepare phase validates the features and functionality documented in the high-level design of a solution?
A. Proof of Concept
B. High-level Design Development
C. Business Case Development
D. Business Requirements Development
E. Operations Technology Strategy Development
F. Technology Strategy Development
Answer: A
Question 3.
In the implement phase, project close-out involves which of the following tasks?
A. deliver education based on Staff Planning Development reports
B. conduct Engagement Profitability Assessment
C. execute network migration plan
D. customize ongoing support hand-off kit
Answer: B
Question 4.
In the implement phase, project close-out involves which of the following tasks?
A. deliver education based on Staff Planning Development reports
B. customize ongoing support hand-off kit
C. conduct Engagement Profitability Assessment
D. execute network migration plan
Answer: C
Question 5.
In the design phase, performing a needs analysis to identify the resource requirements and skills needed to deliver and support a network infrastructure is an activity of which service component?
A. Implementation Kick-off Meeting
B. Implementation Plan
C. Project Kick-off
D. Staging Plan
E. Migration Plan
F. Staff Plan Development
Answer: F
Question 6.
In the implement phase, solution implementation involves which of the following task?
A. Execute test cases
B. Configure core products
C. Perform preliminary Site Assessment
D. Analyze high-level design and technology requirements of the customer
Answer: B
Question 7.
Which one of the following describes the task for completing an operations readiness assessment in the plan phase?
A. determining network elements that will be tested
B. reviewing hardware and software configuration staging plan
C. entering documentation into knowledge management system
D. developing backup/recovery plan
E. creating an escalation plan
F. obtaining and reviewing operation procedures and policies
Answer: F
Question 8.
In the implement phase, solution implementation involves which of the following task?
A. perform preliminary Site Assessment
B. configure core products
C. execute test cases
D. analyze high-level design and technology requirements of the customer
Answer: B
Question 9.
Which of the following definitions best describes services stack within the Cisco Lifecycle Services approach?
A. the minimum set of services that a customer needs to successfully deploy and operate a Cisco
technology or solution
B. the required set of services needed to successfully deploy and support Cisco Advanced
Technologies
C. the identification of Advanced Technologies to best support business requirements and
objectives
D. the minimum set of services required to operate and optimize Cisco Advanced Technologies
Answer: A
Question 10.
Which of the following definitions best describes business requirements development within the prepare phase?
A. a set of service component activities that assesses and documents the business requirements
of a customer
B. part of the systems design activity that identifies and documents business requirements to help
deploy network technologies
C. part of the high-level design activity that addresses business and technical requirements of the
customer
D. a service component activity that analyzes business requirements and recommends the
appropriate technology strategy
Answer: A
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.