PDT attempts to identify performance problems automatically by collecting and integrating a wide range of performance, configuration and availability data.
PDT consists of three components, the collection component comprises a set of programs that periodically collect and record data, the retention component periodically reviews the collected data and discards data that is obsolete, and the reporting component periodically produces a diagnostic report from the current set of historical data.
PDT contains motif-based, AIX licensed programs that can easily access tools for system and network performance tuning, monitoring, and analysis.
PDT assesses the current state of a system and tracks changes in workload and performance. It attempts to identify incipient problems and suggest solutions before the problems become critical.
第1题:
A. Change in the Oracle Database version
B. Change in your network infrastructure
C. Change in the hardware configuration of the database server
D. Migration of database storage from non-ASM to ASM storage
E. Database and operating system upgrade
第2题:
When planning for a logically partitioned system,which of the following should be used as part of a review to ensure that each partition has the required resources? ()
第3题:
All of the following comprise the Performance Toolbox EXCEPT:()
第4题:
The bos.perf package is part of the base operating system. Performance Diagnostic tool, PDT, is a part of bos.perf. All of the following statements are true EXCEPT?()
第5题:
Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?() The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn’t set
第6题:
Use the Workload Estimator capacity planning tool.
Use prtconf output from legacy systems.
Use the LPAR Validation Tool.
Use Performance Management Services.
第7题:
CREATE UNIQUE INDEX idx_partno ON parts(part_no)
CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)
CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)
CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
第8题:
perfmgr
perfagent.server
perfagent.tools
perfagent.client
第9题:
improving your appetite
eliminating bad memories
making better business decisions
boosting exam performance
第10题:
Advertisements form part of a nation’s culture.
Advertising is legalized lying.
Promise, large promise, is the soul of all advertisement.
Advertising has put an end to the power of the most powerful adjective.
第11题:
Change in the Oracle Database version
Change in your network infrastructure
Change in the hardware configuration of the database server
Migration of database storage from non-ASM to ASM storage
Database and operating system upgrade
第12题:
rmss is a part of performance toolbox and stands for Reduced Memory System Simulator
rmss is a part of perfpmr and stands for Real Memory System Simulator
rmss is part of the standard bos.perf filesets and stands for Redundant Memory System Simulator
rmss is part of WLM and stands for Real Memory System Simulator
第13题:
Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?()
A.CREATE UNIQUE INDEX idx_partno ON parts(part_no)
B.CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)
C.CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)
D.CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
第14题:
Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?()
第15题:
Which of the following is true about rmss?()
第16题:
You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting?()
第17题:
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()
第18题:
PDT attempts to identify performance problems automatically by collecting and integrating a wide range of performance, configuration and availability data.
PDT consists of three components, the collection component comprises a set of programs that periodically collect and record data, the retention component periodically reviews the collected data and discards data that is obsolete, and the reporting component periodically produces a diagnostic report from the current set of historical data.
PDT contains motif-based, AIX licensed programs that can easily access tools for system and network performance tuning, monitoring, and analysis.
PDT assesses the current state of a system and tracks changes in workload and performance. It attempts to identify incipient problems and suggest solutions before the problems become critical.
第19题:
ping
trace
ifconfig
lsattr
第20题:
fuel
oxygen
heat
electricity
第21题:
then the default is set to $ORACLE_BASE The default value is the value of the environment variable $ORACLE_BASE; if $ORACLE_BASE isn’t set,
then it is set to $ORACLE_HOME
DIAGNOSTIC_DEST is always equal to $ORACLE_HOME
DIAGNOSTIC_DEST is always equal to $ORACLE_BASE
第22题:
The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.
The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.
The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.
The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
第23题:
instigating corrective action
indicating values of controlled variables
warning of off-limit conditions
providing record of performance
第24题:
hydrography
aids to navigation
tidal currents
regulatory boundaries