网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance?()
A
Java pool
B
Large pool
C
Shared pool
D
Streams pool
E
Library cache
F
Redo log buffer
G
Data dictionary cache
H
Database buffer cache
参考答案
参考解析
解析:
暂无解析
更多 “单选题Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance?()A Java poolB Large poolC Shared poolD Streams poolE Library cacheF Redo log bufferG Data dictionary cacheH Database buffer cache” 相关考题
考题
In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?()A. It collects data from SGA and compares it with a preserved snapshot.B. It collects data from SGA, analyzes it, and provides a report.C. It collects data from SGA and compares it with the latest snapshot.D. It collects data from both SGA and PGA, analyzes it, and provides a report
考题
You are the network administrator of a Layer 3 switched network. Users in one VLAN are complaining thataccess to the server VLAN is very slow from time to time. Traffic in the local VLAN works without any issue,and users in other VLANs do not have any complaint to reach the server VLAN. What is most likely thecause of this issue?()A、routing issueB、denial-of-service attackC、MAC floodingD、spanning-tree recalculationE、Layer 2 loopF、ARP spoofing attack
考题
A 4-way x445 server with 2GB of memory running Windows 2003 Server with Exchange 2003 is performing poorly. Users are complaining of slow response times when accessing their email. Which subsystem should be checked first as a potential bottleneck?()A、ProcessorsB、Memory subsystemC、Storage subsystemD、Network connectivity
考题
A system has users doing interactive work while background jobs are running. Interactive users are requesting that system response time be improved for foreground processes. Which tuning parameters should be changed to accomplish this?()A、 schedtune -hB、 schedtune -rC、 vmtune -fD、 schedtune -w
考题
Companycom has just installed a p5 595 with four uncapped LPARs in a shared processor pool. The system and profile settings are still in their default states. One of the LPARs has an application that is consuming all of the available shared processor resources. Users of this application are complaining about response time. Which of the following changes to the slow LPAR would improve response time?()A、Enable SMTB、Reduce the weightC、Renice the processD、Increase the weight
考题
Users complain an AIX server is running slow. Which of the following commands can be run to determine what is consuming systems resources?()A、 tprofB、 lpstatC、 ps auxD、 entstat
考题
Companycom is using shared processor LPARs exclusively, including the Virtual IO Server. The users are complaining about response time. The application LPARs can be heavy processor users. The Virtual IO Server has been measured to be processor constrained. How should the Virtual IO Server's shared processor LPAR be configured?()A、Capped and with a lower shareB、Uncapped and with a lower shareC、Uncapped and with a higher shareD、Capped and with no change in share
考题
You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()A、The trace fileB、The fixed viewsC、The data dictionary viewsD、The operating system log fieldsE、The dynamic performance views.
考题
单选题Users complain an AIX server is running slow. Which of the following commands can be run to determine what is consuming systems resources?()A
tprofB
lpstatC
ps auxD
entstat
考题
单选题A system has users doing interactive work while background jobs are running. Interactive users are requesting that system response time be improved for foreground processes. Which tuning parameters should be changed to accomplish this?()A
schedtune -hB
schedtune -rC
vmtune -fD
schedtune -w
考题
单选题You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()A
Increase the undo returnB
Create more undo segmentsC
Create another undotablespaceD
Increase the size of the undotablespace
考题
单选题Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()A
increase the undo retentionB
create more undo segmentsC
create another undo tablespaceD
increase the size of the undo tablespace
考题
单选题Due to slow response times, a customer purchased additional memory. After the memory was installed,response time was not improved. They complained to the pSeries technical specialist. Which of the following questions should be asked of this customer?()A
Who recommended the memory purchase?B
Have more users been added since the memory purchase?C
Why were additional CPUs not ordered at the same time as the memory?D
Did a performance analysis of peak periods show a memory bottleneck?
考题
单选题A system administrator periodically receives calls from users who complain about poor performance with their application. Use the following sar command output to answer the question: Which of the following system resources need more investigation?()A
CPUsB
DiskC
MemoryD
NetworkX
考题
单选题You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()A
Increase the undo returnB
Create more undo segmentsC
Create another undotablespaceD
Increase the size of the undo tablespace
考题
单选题In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?()A
It collects data from SGA and compares it with a preserved snapshot.B
It collects data from SGA, analyzes it, and provides a report.C
It collects data from SGA and compares it with the latest snapshot.D
It collects data from both SGA and PGA, analyzes it, and provides a report
考题
单选题Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance?()A
Java poolB
Large poolC
Shared poolD
Streams poolE
Library cacheF
Redo log bufferG
Data dictionary cacheH
Database buffer cache
考题
多选题You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting: Configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks, and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance?()AIncrease the size of redo log filesBIncrease the size of redo log bufferCIncrease the number of redo log filesDPlace the redo log files on a separate diskEDecrease the number of redo log groups to twoFIncreate the number Log Writer (LGWR) process
考题
单选题You have created an Oracle 10g database named SALES, which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option?()A
The index can be changed from NOLOGGING to LOGGINGB
The index cannot be recovered even in the ARCHIVELOG mode.C
The index can only be created if the base table is created with the NOLOGGING option.D
The index can be recovered if you perform a backup after the CREATE INDEX statement.
考题
单选题For the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?()A
Set the CPU time per call in the users profile.B
Set the CPU time per session in the users profile.C
Set the CPU levels for the user’s group using Resource Manager.D
Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
考题
单选题You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()A
The trace fileB
The fixed viewsC
The data dictionary viewsD
The operating system log fieldsE
The dynamic performance views.
考题
单选题From the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?()A
set the CPU time per call in the users profileB
set the CPU time per session in the users profilesC
set the CPU levels for the users’ group using Resource ManagerD
set the TIMED_STATISTICS parameter to TRUE in the parameter file
考题
单选题The main idea of Paragraph Three is that ______.A
most people feel life is easyB
the writer feels life is easyC
the writer likes to complain about his problemsD
most people complain about how hard their lives are
考题
填空题My mother did nothing but (complain) ____ about it all the time when she was here.
热门标签
最新试卷