多选题You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation， you find that some users are not committing their transactions though they are notperforming any activity for a long time. As a result， SQL statements need to wait for row-level locks. Which two actions could you take to prevent this locking problem in the future（）ADecrease the IDLE_TIME resource limit in the profile assigned to the blocking users.BUse Database Resource Manager to automatically log out sessions that block others and are idle.CSet the limit in the profile of blocking users to control the number of blocks to be accessed in a session.DDecrease the maximum number of interested transaction list （ITL） slots for the segments on which the blocking user performs the transaction
多选题
You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation， you find that some users are not committing their transactions though they are notperforming any activity for a long time. As a result， SQL statements need to wait for row-level locks. Which two actions could you take to prevent this locking problem in the future（）
A
Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
B
Use Database Resource Manager to automatically log out sessions that block others and are idle.
C
Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
D
Decrease the maximum number of interested transaction list （ITL） slots for the segments on which the blocking user performs the transaction
参考解析
解析：
暂无解析
相关考题：
－Hello, David! I haven’t heard from you for a long time. How have you been recently －() A、Not bad, thank you.B、That’s ok.C、Long time no see.
Hello, David! I haven't heard from you for a long time. How have you been recently?()A. That's okB. Long time no seeC. Not bad, thank you
A:Hello, David! I haven't heard from you for a long time. How have you been recently? B:（）AThat's okBLong time no seeCNot bad, thank you
A:Hello, David! I haven't heard from you for a long time. How have you been recently? B:（）A、That's okB、Long time no seeC、Not bad, thank you
You have a print server that runs Windows Server 2003 Service Pack 2 (SP2). Users report that print jobs are not printing. Users also report that they do not receive any error messages. You notice a large number of jobs in the print queue. You attempt to delete some jobs from the queue and notice that the jobs remain in the queue. You need to ensure that users can print successfully. What should you do? （）A、Restart the Print Spooler service.B、Pause the printer, and then restart the printer.C、Take ownership of the printer, and then delete the print jobs.D、Assign the Manage Documents permission to the users connected to the printer.
我希望没有让你久等。（）A、I hope I have not kept you waiting for long.B、I hope I have not kept you waiting for a short time.C、I hope I have not kept you waiting for a while.D、I hope I have not kept you waiting for a little time.
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
You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（） A、 V$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP
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
You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）A、by using triggersB、by using external tablesC、by using anonymous PL/SQL blocksD、by auditing all DML operations on the table
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 receive complaints from users regarding the high waiting time for their transactions. Oninvestigation， you find that some users are not committing their transactions though they are notperforming any activity for a long time. As a result， SQL statements need to wait for row-level locks. Which two actions could you take to prevent this locking problem in the future（）A、Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.B、Use Database Resource Manager to automatically log out sessions that block others and are idle.C、Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.D、Decrease the maximum number of interested transaction list （ITL） slots for the segments on which the blocking user performs the transaction
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
From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users. Which method would you use to achieve this objective？（）A、create a plan directive in the SYS_GROUPB、create the pending area for the consumer groupC、activate the provided SYSTEM_PLAN in Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter fileE、set the execution time limit for all users， except SYS and SYSTEM， in their profiles
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
You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）A、run Segment AdvisorB、run SQL Tuning Advisor on top SQL statementsC、run the Automatic Workload Repository （AWR） reportD、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
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
You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）A、functionsB、packagesC、proceduresD、database triggersE、anonymous PL/SQL block
You suspect unauthorized data manipulation language （DML） operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for analysis. How would you achieve this（）A、by using triggersB、by using Data PumpC、by using external tablesD、by using anonymous PL/SQL blocks
You have a print server that runs Windows Server 2003 Service Pack 2 (SP2). Users report that print jobs are not printing. Users also report that they do not receive any error messages. Younotice a large number of jobs in the print queue. You attempt to delete some jobs from the queue and notice that the jobs remain in the queue. You need to ensure that users can print successfully. What should you do? （）A、Restart the Print Spooler service.B、Pause the printer, and then restart the printer.C、Take ownership of the printer, and then delete the print jobs.D、Assign the Manage Documents permission to the users connected to the printer.
Some users report they cannot receive messages from some external senders.You suspect that there is some anti-spam activity blocking those messages.You need to identify what is blocking the messages.You will activate and review the logs of one of the following：（）A、Protocol loggingB、Connectivity logsC、Message trackingD、Pipeline tracing
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（） A、You should configure the database for Read Committed Snapshot isolation. B、You should modify the stored procedure to use the Snapshot isolation level C、You should configure the database for Auto Update Statistics asynchronously D、You should modify the stored procedure to use the Repeatable Read isolation level
多选题You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation， you find that some users are not committing their transactions though they are notperforming any activity for a long time. As a result， SQL statements need to wait for row-level locks. Which two actions could you take to prevent this locking problem in the future（）ADecrease the IDLE_TIME resource limit in the profile assigned to the blocking users.BUse Database Resource Manager to automatically log out sessions that block others and are idle.CSet the limit in the profile of blocking users to control the number of blocks to be accessed in a session.DDecrease the maximum number of interested transaction list （ITL） slots for the segments on which the blocking user performs the transaction
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）AYou should configure the database for Read Committed Snapshot isolation. BYou should modify the stored procedure to use the Snapshot isolation level CYou should configure the database for Auto Update Statistics asynchronously DYou should modify the stored procedure to use the Repeatable Read isolation level
单选题You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）Aby using triggersBby using external tablesCby using anonymous PL/SQL blocksDby auditing all DML operations on the table
单选题You suspect unauthorized data manipulation language （DML） operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for analysis. How would you achieve this（）Aby using triggersBby using Data PumpCby using external tablesDby using anonymous PL/SQL blocks