单项选择题
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？（）
A.Save the baseline in the database
B.Save the baseline in the Database Control Home Page
C.Create a procedure to read and apply the baseline to disk I/O metrics
D.Apply the baseline to the disk I/O metrics in the Mange Metrics page
E.Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd -
多项选择题
YouworkasadatabaseadministratorforCertkiller.com.Inyourtransactionapplication，youhavescheduledajobtoupdatetheoptimizerstatisticsat05：00pmeveryFriday.Thejobhassuccessfullycompleted.Whichthreepiecesofinformationwouldyouchecktoconfirmthatthestatisticshavebeencollected？（）
A.Average row size
B.Last analyzed date
C.Size of table in bytes
D.Size of table in database blocks
E.Number of free blocks in the free list
F.Number of extents present in the table. -
单项选择题
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？（）
A.The advisory memory has been turned off.
B.The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
C.The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
D.The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
E.The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
