|
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. A classification model (in PMML format) was created by a third party vendor tool such as SPSS. After importing the model into DB2, where is it stored? A. In a user-specified table. under an automatically generated name, e.g. SPSS_017. B. In the table IDMMX.CLASSIFMODELS under a user-specified MODELNAME. The default is the value of the attribute "modelname" in the PMML TreeModel. C. In the table .CLASSIFMODELS under a user-specified MODELNAME. The default is the value of the attribute "modelname" in the PMML TreeModel. D. In a user-specified table . under a user-specified MODELNAME. The default is the value of the attribute "modelname" in the PMML TreeModel. Answer: B Question 2. Which of the following must be fulfilled to execute a mining flow that creates a classification model in the database? A. All input and output ports of all operators must be connected. B. The flow must contain a Predictor operator whose properties define a Cost Matrix. C. The flow must contain a Predictor operator whose output port must be connected to a Visualizer. D. The flow must contain a Predictor operator whose properties (Mining Settings) define a categorical target column. Answer: D Question 3. Application data changes over time and differs from that used to train a classification model M. Assume that a mining flow with a Tester operator with M and the application data as input and a test model T as output has been defined. What must be done to check if M can still safely be applied? A. Open T in a visualizer and check the tree depth. If the tree depth is greater than 10, the model is OK. B. Open T in a visualizer and check the model quality figures. If the quality is greater than 0.5, the model is OK. C. Open M and T in a visualizer and check the tree depth. If the tree depth of T is greater than the tree depth of M, the model is OK. D. Open M and T in a visualizer and check the model quality figures. If the quality is about the same as the quality of M, the model is OK. Answer: D Question 4. As part of a market basket analysis effort, a retail company needs to analyze sales transaction data to understand which products tend to be bought together by the same customer during each visit to the store. Which data mining function is most appropriate for this business problem? A. Clustering B. Regression C. Associations D. Classification Answer: C Question 5. A group of Alphablox users needs a report which contains rule heads and bodies of an Association model in a tabular format. Which of the following describes a complete Mining Flow that loads the model output of an Associations operator into a table? A. Table Source ---> Associations --> Table Target B. Table Source ---> Associations --> Associations Extractor C. Table Source ---> Associations --> Visualizer --> Table Target D. Table Source ---> Associations --> Associations Extractor --> Table Target Answer: D Question 6. An investment banking company wants to use data mining to predict customer lapsing behavior. The cost of losing existing customers is very high, and the company wants to keep all customers happy. Based on a recent customer survey with a small subset of existing customers, 2% of customers indicated they were not satisfied. To predict whether or not a customer is satisfied, Predictor and Tester operators in DWE Design Studio were used to analyze the survey results. Which of the following should be done in this situation? A. Increase the Maximum tolerated systematic error (RSquared). B. Decrease the Maximum tolerated systematic error (RSquared). C. Increase the weight of "Satisfied (Actual) & Dissatisfied (Predicted)" in the Cost Matrix parameter option. D. Increase the weight of "Dissatisfied (Actual) & Satisfied (Predicted)" in the Cost Matrix parameter option. Answer: D Question 7. An insurance company wants to use data mining to predict fraudulent claims. Based on historical data, 1% of claim transactions were classified as fraud. To work on this problem, the Predictor and Tester mining operators in DWE Design Studio were used to analyze a small subset of claim history data. Which preprocessing function operator is the most efficient mechanism to feed data into the Predictor mining operator? A. Sampler B. Select List C. Random Splitter D. Field Extractor Answer: C Question 8. Which mining model needs to be processed through training and testing phase before being applied into the Scoring function? A. Sequential B. Clustering C. Association D. Classification Answer: D Question 9. Given the following association rule: [Tomato][Carrot]=>[Orange Juice] Support = 10 Confidence = 80 Lift = 4 Which of the following can be deduced from this information? A. The number of orange juice sales is made up of 20% of all sales transactions. B. Customers buy the combination of tomato, carrot and orange juice 80% more than expected. C. There is a 10% chance that customers also buy orange juice when they buy tomato with carrot. D. Out of 2 million sales transactions, approximately 1,600,000 show that tomato, carrot and orange juice are bought together. Answer: A Question 10. Which of the following mining operator provides a model output that can be directed into the Visualizer operator in the DWE Mining Flow. A. Associations B. Cluster Table C. Predict Column D. Find Deviations Answer: A
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.