（多选题）
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 as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old In which situation would you receive such an error？（）
（单选题）
Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received en error regarding DISK 3 on your server. This is the location of your data file for the SYSTEM tablespace. Which option is open to you？（）
（单选题）
You receive the following error： ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit Identify the reason for receiving the above error message？（）
（单选题）
You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error： ERROR： ORA-12541：TNS：no_listener You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener. lsnrctl>START What statement is true？（）
（单选题）
You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace. How would you perform this？（）
（单选题）
When you try to open your database， you receive the following error： ORA-00205： error in identifying controlfile Where would you find the details required to resolve this error？（）
（单选题）
When you try to open your database， you receive the following error： ORA-00205： error in identifying control file Where would you find the details required to resolve this error？（）
（单选题）
You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）
（单选题）
View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）
（单选题）
You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this？ （）
