|
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.
Some of the computers in your company run Microsoft Office 2003. Other computers run Microsoft Office 2007. Users report that when they save documents on computers that run Office 2007, users on computers that run Microsoft Office 2003 are unable to edit those documents. You need to ensure that users on computers that run Office 2003 are able to edit Office 2007 documents.
What should you do?
A - Add the Office Compatibility Pack to the computers that run Office 2007.
B - Add the Office Compatibility Pack to the computers that run Office 2003.
C - Install Office 2003 Service Pack 2 on the computers that run Office 2003.
D - Install MSXML 6.0 on computers that run Microsoft Office 2003.
Answer: B
Question 2.
You are planning to upgrade to Microsoft Office 2007. You need to identify documents that are not compatible with Office 2007.
What should you do?
A - Run the OMPM File Scanner tool.
B - Run the Application Compatibility Analyzer.
C - Run the Office File Converter.
D - Run the Office Customization Tool.
Answer: A
Question 3.
You need to install Microsoft Office 2007 on computers in the Sales department and computers in the Accounting department. The Sales department requires only Microsoft Word and Microsoft Excel. The Accounting department requires only Microsoft Excel and Microsoft InfoPath. You need to deploy Office 2007 to computers in the Sales department and the Accounting department. You create a shared folder named \\Server1\Office.
What should you do next?
A - Copy the Microsoft Office 2007 installation files to the \\Server1\Office folder. Create an .MSP
file for each department. Create a script for each department that uses the appropriate .MSP
file.
B - Copy the Microsoft Office 2007 installation files to the \\Server1\Office folder. Create an .MST
file for each department. Create a script for each department that uses the appropriate .MST
file.
C - In the \\Server1\Office folder, create a folder for each department. Copy the Microsoft Office
2007 installation files to each folder. Create a CUSTOM.MSP file in each folder. Instruct users
to run setup from the appropriate folder.
D - In the \\Server1\Office folder, create a folder for each department. Copy the Microsoft Office
2007 installation files to each folder. Create a CUSTOM.MST file in each folder. Instruct users
to run setup from the appropriate folder.
Answer: A
Question 4.
Your company is deploying Windows Vista. You create a reference computer and capture an image of that computer by using the ImageX utility. You need to modify the reference computer image to meet the following requirements:
Set the Internet Explorer home page to your companys home page.
Remove Games from the image.
Add a new network card device driver.
You must accomplish this task by using the least administrative effort.
What should you do?
A - Use the ImageX utility to mount the image. Copy an unattended setup answer file to the
\Windows folder in the image.
B - Use the ImageX utility to mount the image. Apply an unattended setup answer file to the
image.
C - Restore the image of the reference computer. Modify the configuration of the reference
computer. Recapture an image of the reference computer.
D - Restore the image of the reference computer. Copy an unattended setup answer file to the
\Windows folder on the reference computer. Recapture an image of the reference computer.
Answer: B
Question 5.
You are deploying Microsoft Office 2007 to computers that run Windows Vista. The computers are configured to support the English, Spanish, and French languages. Users report that only the English language is displayed in Office 2007 applications. You need to ensure that Office 2007 displays the English, Spanish and French languages.
What should you do?
A - Add the Microsoft Office 2007 Single Language Packs to the root of the Office 2007
installation share. Instruct users to run the Office 2007 Setup program.
B - Create a subdirectory for each language on the Office 2007 installation share. Add the Office
2007 Single Language Packs to the appropriate subdirectory. Edit the config.xml file on the
installation share. Instruct users to run the Office 2007 Setup program.
C - Use the PKGMGR command to add the Windows Vista language packs to the client
computers. Edit config.xml file on the installation share. Instruct users to run the Office 2007
Setup program.
D - Use the PKGMGR command to add the Windows Vista language packs to the installation
source for Windows Vista. Edit the unattend.xml file in the Windows Vista installation source.
Instruct users to run the Office 2007 Setup program.
Answer: B
Question 6.
You are installing Microsoft Office 2007. You configure two distribution points. One distribution point is named \\Server1\Office2007. The other distribution point is named \\Server2\Office 2007. You need to ensure that if one distribution point becomes unavailable, Microsoft Office 2007 will use the other distribution point.
What should you do? (Each correct answer presents a complete solution. Choose two.)
A - On each distribution server, create an administrative installation point.
B - On the root of each distribution point, create a shortcut which points to the additional
distribution point.
C - Create a Custom.MSP file.
D - Configure the Config.XML file.
Answer: C, D
Question 7.
You plan to deploy Microsoft Office 2007 using a script. You need to create a distribution share for Microsoft Office 2007. You create a shared folder on a server.
What should you do next?
A - Run the Microsoft Office 2007 installation program with the /config switch.
B - Run the Microsoft Office 2007 installation program with the /admin switch
C - Install Microsoft Office 2007 on a reference computer. Copy the MSOCache folder to the root
of the installation share.
D - Copy the installation files from the source media to the root of the shared folder.
Answer: D
Question 8.
You use the Application Compatibility Toolkit (ACT) to analyze computers before deploying Windows Vista. You create a data collection package which contains the Internet Explorer Compatibility Evaluator and the Inventory Collector. Company policy requires that all software package installation be done during non-peak hours. You need to ensure the data collection package is deployed to computers.
What should you do?
A - Create a user logon script. Add the data collection package to the logon script.
B - Create a computer software installation policy in a Group Policy object.
C - Create an SMS Package which contains the data collection package. Advertise the package
to install at a specified time.
D - Create a user software installation policy in a Group Policy object.
Answer: C
Question 9.
You deploy Windows Vista on 500 computers in your network. You discover that one of your applications does not function correctly in Windows Vista. You also discover that the application requires Windows XP Service Pack 2. You need to ensure that the application functions correctly in Windows Vista. You must accomplish this task with the least administrative effort.
What should you do?
A - Disable the User Account Control: Virtualize file and registry write failures to per-user
locations security option.
B - Set the Compatibility mode to Windows XP (Service Pack 2) on the properties of the
application properties
C - Use the Compatibility Administrator to create a new application fix that sets the Operating
System Mode to Microsoft Windows XP (SP2).
D - Use the Compatibility Administrator to create a new application fix that sets the
WinXPSP2VersionLie compatibility mode.
Answer: C
Question 10.
You plan to upgrade computers to Windows Vista. One of the applications uses a custom Windows logon dialog box. You use the Application Compatibility Toolkit (ACT) to collect compatibility information on the computers in your network. You need to ensure that there are no known compatibility issues with the application.
What should you do?
A - Examine the Vista Compatibility Evaluation Report
B - Examine the Update Compatibility Evaluation Report
C - Examine the Impact Analyzer Reports
D - Examine the Impact Application Reports
Answer: A
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.