网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）
- A、Increase the value of table_definition_cache
- B、Increase the value of table_open_cache_instances
- C、Decrease the value of table_open_cache_instances
- D、Increase the value of table_open_cache
- E、Decrease the value of table_definition_cache
- F、Decrease the value of table_open_cache
参考答案
更多 “ You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）A、Increase the value of table_definition_cacheB、Increase the value of table_open_cache_instancesC、Decrease the value of table_open_cache_instancesD、Increase the value of table_open_cacheE、Decrease the value of table_definition_cacheF、Decrease the value of table_open_cache” 相关考题
考题
You are investigating routing problems on a device running the Junos OS. You receive the error shown in the exhibit when you attempt to restart the routing process.Which statement describes the problem?（）A. You have typed an invalid command.B. You must be in configuration mode to restart the routing process.C. You do not have permission to restart the routing process.D. You must wait until close of business to restart the routing process, based on user-defined policy.
考题
Due to a recent increase in administrative errors, we are writing to remind you of the process for investigating any suspected discrepancy on your service bill. Please contact the customer service department in writing within 60 days of receiving the bill. In order to avoid fate fees and possi-ble42of your service, you must still pay undisputed portions of the statement by the due date.
Proteus Sat43 every effort to resolve any claims in a timely manner, and to the mutual sat-isfaction.
阅读以上短文，回答191-192题。
第42题答案是__________A.interrupted
B.to interrupt
C.interruption
D.interruptive
考题
We are（）how an error like this could have happened.A、searchingB、researchingC、surveyingD、investigating
考题
Users at the Charleville Company began experiencing high network delays when Internet connectivity was enabled for all users. After investigating the traffic flow, you determine that peerto-peer traffic from a music download site is consuming a large amount of bandwidth. Which QoS mechanism can you implement to improve the network response time?（）A、Use CBWFQ to queue the peer-to-peer traffic into the default traffic class.B、Use class-based WRED to randomly drop the peer-to-peer traffic during network congestions.C、Use class-based policing to limit the peer-to-peer traffic rate.D、Use class-based shaping to delay any excessive peer-to-peer traffic. Answer: C
考题
单选题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
考题
单选题In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated. How do you achieve this objective？（）A
by setting the SQL_TRACE parameter to FALSE in the parameter fileB
by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user sessionC
by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user sessionD
by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
考题
单选题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 observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A
Export and import the mapping table.B
Drop and re-create the mapping table.C
Truncate the mapping table and reinsert the values.D
Use the ALTER TABLE .. REBUILD command to defragment the mapping table.
考题
单选题In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A
export and import the mapping tableB
drop and re-create the mapping tableC
truncate the mapping table and reinsert the valuesD
use the ALTER TABLE···REBUILD command to defragment the mapping table
考题
单选题You have an Exchange Server 2010 organization named contoso.com. Your company is investigating a user named User1. You need to prevent User1 from permanently deleting the items in his mailbox. What should you run（）？A
Set-Mailbox User1 -LitigationHoldEnabled $trueB
Set-Mailbox User1 -ModerationEnabled $trueC
Set-Mailbox User1 -RetainDeletedItemsUntilBackup $trueD
Set-Mailbox User1 -RetentionHoldEnabled $true
考题
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A
enable index monitoring and query the DBA_OBJECTS viewB
enable index monitoring and query the DBA_INDEXES viewC
enable index monitoring and query the V$OBJECT_USAGE viewD
enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
考题
单选题In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）A
Complete Recovery with online redo logB
Complete Recovery with archived redo logC
Tablespace Point-in-Time Recovery (TSPITR)D
Incomplete Recovery with system change number (SCN)
考题
单选题In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data？（）A
Complete Recovery with online redo logB
Complete Recovery with archived redo logC
Tablespace Point-in-Time Recovery （TSPITR）D
Incomplete Recovery with system change number （SCN）
考题
多选题Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）Adrop and re-create the indexBcoalesce the ORDERS_IND indexCcoalesce the INDEXES tablespaceDdrop and re-create the ORDERS tableErebuild the index online and move it to another tablespace
热门标签
最新试卷
