Người sử dụng thực hiện báo cáo DML phải khóa các hàng trước khi thay đổi các hàng trong một bảng. Trong Oracle 10g, một giao dịch có thể khóa một hàng duy nhất, nhiều hàng, hoặc toàn bộ một bảng. Bạn có thể khóa các hàng cả hai tay và tự động. Các hàng có thể được khóa ở các cấp độ truy cập thấp nhất có thể để đảm bảo tính toàn vẹn dữ liệu. | Oracle 1z0-043 Oracle 1z0-043 Oracle Database 10g Administration ii Practice Test Version Oracle 1z0-043 Practice Exam QUESTION NO 1 You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to A. FREQ MONTHLY BYDAY 2FRI B. FREQ MONTHLY BYDAY -2FRI C. FREQ MONTHLY BYDAY FRI2 D. FREQ MONTHLY BYDAY FRI 2 Answer A QUESTION NO 2 Please indicate your opinion of this statement br The Demo that preceded the hands-on items was easy to understand and helpful. A. Disagree. B. Agree. C. Strongly Disagree. D. Strongly Agree. E. Neither Agree nor Disagree. vO Answer D QUESTION NO 3 The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed A. The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUXtablespaces. B. The Oracle database will perform block checking for the data blocks in all usertablespaces. C. The Oracle database will perform block checking for the data blocks in the SYSTEMtablespace only. D. The Oracle database will not perform block checking for any of the data blocks. E. The Oracle database will perform block checking for the default permanenttablespace only. Answer C QUESTION NO 4 Pass Any Exam. Any Time. - 2 Oracle 1z0-043 Practice Exam On Tuesday a junior DBA dropped an important application user account whose schema has important tables. You are asked to recover all the objects in the schema. On investigation you find that the user account was dropped at 11 00 . and Sunday s backup is the most recent backup. Which flashback feature would you use A. Flashback Drop B. Flashback Table C. Flashback Transaction Query D. Flashback Version Query E. Flashback Database Answer E QUESTION NO 5 View the Exhibit and examine the Flashback Database architecture. Identify the missing component shown with a in the Flashback Database architecture. A. RVWR B. ARCH C. DBWn D. TRWR .
