black

1Z0-042

单项选择题

You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead， you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective？（）

A.AFTER CREATE
B.AFTER SUSPEND
C.BEFORE CREATE
D.AFTER TRUNCATE
E.BEFORE SUSPEND
F.AFTER INSERT OR DELETE OR DELETE
G.BEFORE INSERT OR DELETE OR DELETE

相关考题

单项选择题 YouworkasadatabaseadministratorforCertkiller.com.YouwanttobenotifiedwhenthenumberofdiskI/Oincreasesby10%ofwhatitwasyesterday.Youcreateabaselinemetricforyesterday’sdiskI/Operformance.Howdoyouusethebaselinemetricstoachieveyourobjective？（）

多项选择题 YouworkasadatabaseadministratorforCertkiller.com.Inyourtransactionapplication，youhavescheduledajobtoupdatetheoptimizerstatisticsat05：00pmeveryFriday.Thejobhassuccessfullycompleted.Whichthreepiecesofinformationwouldyouchecktoconfirmthatthestatisticshavebeencollected？（）

单项选择题 You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）

All Rights Reserved 版权所有©建筑考试题库(jzkao.com)

备案号：湘ICP备2020024380号-3