black

1Z0-042

登录

多项选择题

You work as a database administrator for Certkiller .com. In your transaction application, you have scheduled a job to update the optimizer statistics at05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected?()

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?()

多项选择题 YourbossatCertkiller.comwantsyoutoclarifyOracle10g.WhichtwostatementsregardingtheLOGGINGclauseoftheCREATETABLESPACE...statementarecorrecte?()

多项选择题 You work as a database administrator for Certkiller .com. In your development environmentenvironment, the developers are responsible for modifying the table structure according to the application requirements. However, you want to keep track of the ALTER TABLE commands being executed by developers, so you enable auditing to achieve this objective.  Which two views would you refer to find out the audit information?()

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

备案号:湘ICP备2020024380号-3