欧美日韩精品一区二区视频,国产香蕉青春草原久久,成人精品视频在线观看不卡

1 You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）

2 You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.
Which advisory component would you refer to， in order to determine the appropriate indexes？（）

3 You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）

4 Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）

5 The user SCOTT executes the following command successfully to increase the salary values in one of his sessions：
SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20；
Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）

1Z0-042單項選擇題每日一練(2019.01.24)