Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
OCA /OCP Oracle Database 11g A ll-in-One Exam Guide- P42:There is an ever increasing demand for staff with IT industry certification. The benefits to employers are significant—they can be certain that staff have a certain level of competence—and the benefits to the individuals, in terms of demand for their services, are equally great. Many employers are now requiring technical staff to have certifications, and many IT purchasers will not buy from firms that do not have certified staff. | OCA OCP Oracle Database 11g All-in-One Exam Guide 366 9. 0 A B and D. Changes to any of these will generate redo. 0 C. Changes to temporary segments do not generate redo. 10. 0 A and B. Both DDL and access control commands include a COMMIT. 0 C and D. C is wrong because a savepoint is only a marker within a transaction. D is wrong because this is a SQL Plus command that acts locally on the user process it has no effect on an active transaction. 11. 0 C. Triggers cannot be packaged. 0 A B and D. A and B are wrong because functions and procedures can be packaged. D is wrong because neither anonymous blocks nor triggers can be packaged. 12. 0 C. This correctly describes the operation of the enqueue mechanism. 0 A B and D. A is wrong because locks are granted sequentially not randomly. B is wrong because the shared locks apply to the object row locks must be exclusive. D is wrong because this is more like a description of how deadlocks are managed. 13. 0 C. All DML occurs in the database buffer cache and changes to both data block and undo blocks are protected by redo. 0 A B and D. A is wrong because writing to disk is independent of executing the statement. B and D are incomplete redo protects changes to both data blocks and undo blocks. 14. 0 B. This is the option that would require downtime because the datafile would have to taken offline during the move and you cannot take it offline while the database is open. 0 A C and D. These are wrong because they are all operations that can be carried out during normal running without end users being aware. 15. 0 C. To calculate take the largest figure for UNDBLKS which is for a ten-minute period. Divide by 600 to get the rate of undo generation in blocks per second and multiply by the block size to get the figure in bytes. Multiply by the largest figure for MAXQUERYLEN to find the space needed if the highest rate of undo generation coincided with the longest query and divide by a billion to get the answer in gigabytes 237014
