052(二十四）

最新推荐文章于 2025-09-11 20:53:34 发布

weixin_34245749

最新推荐文章于 2025-09-11 20:53:34 发布

阅读量106

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/huanhuanang/p/5360594.html

本文探讨了数据库管理的关键步骤及性能优化策略，包括实例启动流程、标准数据库审计的要点、共享池和缓冲缓存不可用的原因，以及解决高等待时间交易锁定问题的方法。重点介绍了如何通过调整资源限制和使用Database Resource Manager来防止长时间不活动的会话阻塞系统。

116、

116.Your database is in shutdown state. 
What will happend if you issue next command: 
SQL> startup 
A. instance will started 
B. instance started and DB is mounted 
C. instance started, DB opened and finally mounted 
D. instance started, DB mounted and finally opened

Answer: D

View Code

117、

117.Which two statements are true about standard database auditing? (Choose two.) 
A. DDL statements can be audited. 
B. Statements that refer to standalone procedure can be audited. 
C. Operations by the users logged on as SYSDBA cannot be audited. 
D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

Answer: AB

View Code

118、View Exhibit to examine the current memory allocation and parameter settings, respectively.

Why are advisors not available for the shared pool and the buffer cache? 
A. because the DB_CACHE_ADVICE parameter is set to OFF 
B. because Automatic Memory Management (AMM) is disabled for the database instance 
C. because Automatic Shared Memory Management (ASMM) is enabled for the database instance 
D. because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not set initially

Answer: C

View Code

119、

119.You receive complaints from users regarding the high waiting time for their transactions. On investigation, 
you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, 
SQL statements need to wait for rowlevel locks. 
Which two actions could you take to prevent this locking problem in the future? (Choose two.) 
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

Answer: AB

View Code

120、

120.A database user SMITH tries to query the V$SESSION view and fails to access it as follows: 
SQL> connect smith/smith
Connected.
SQL> SELECT * FROM v$session;
SELECT * FROM v$session
*
ERROR at line 1:
ORA-00942: table or view does not exist
Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Choose two.) 
A. granting SELECT privilege to SMITH on V$SESSION 
B. granting SELECT privilege to SMITH on V_$SESSION 
C. asking the user SMITH to run the catalog.sql script 
D. granting SELECT privilege to SMITH on V$FIXED_TABLES 
E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE 
F. creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created