{"id":2160,"date":"2010-05-25T14:21:58","date_gmt":"2010-05-25T06:21:58","guid":{"rendered":"http:\/\/www.killtest.com.tw\/?p=2160"},"modified":"2010-05-27T14:44:21","modified_gmt":"2010-05-27T06:44:21","slug":"oracle-1z0-042","status":"publish","type":"post","link":"https:\/\/www.killtest.com.tw\/?p=2160","title":{"rendered":"Oracle 1Z0-042\u8003\u984c\u66f4\u65b0\u5206\u4eab"},"content":{"rendered":"<p>Killtest\u984c\u5eab\u7db21Z0-042\u8003\u984c\u767c\u751f\u66f4\u65b0\uff0c\u8003\u984c\u7531\u539f\u4f86\u7684136\u984c\u8b8a\u70ba148\u984c\uff0c\u8003\u8a66\u7248\u672c\u70baV9.02\u3002<br \/>\nKilltest \u984c\u5eab\u7db2\u4fdd\u8b49\u4f60\u4e00\u6b21\u6027\u901a\u904e1Z0-042\u8003\u8a66\uff0c\u5426\u5247\u5168\u984d\u9000\u6b3e\u3002<br \/>\n\u6211\u5011\u9084\u514d\u8cbb\u63d0\u4f9b<a href=\"http:\/\/www.killtest.net\/10gDBA\/1Z0-042.asp\" target=\"_blank\">1Z0-042<\/a>\u7684DEMO\u4e0b\u8f09\uff1a<\/p>\n<p><a href=\"http:\/\/pdf.KillTest.net\/1Z0-042.pdf\" target=\"blank\">PDF \u96fb\u5b50\u6a94\u6848DEMO\u7248\u672c<\/a><\/p>\n<p><a href=\"http:\/\/demo.KillTest.net\/1Z0-042.zip\" target=\"blank\">Testing Engine \u6a21\u64ec\u8edf\u9ad4DEMO\u7248\u672c<\/a><\/p>\n<p>\u90e8\u4efd1Z0-042\u8003\u984c\u5982\u4e0b\uff1a<br \/>\n1. In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05: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? (Choose three.)<br \/>\nA. average row size<br \/>\nB. last analyzed date<br \/>\nC. size of table in bytes<br \/>\nD. size of table in database blocks<br \/>\nE. number of free blocks in the free list<br \/>\nF. number of extents present in the table<br \/>\nAnswer: ABD<br \/>\n2. You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true? (Choose two.)<br \/>\nA. On startup, SMON coordinates instance recovery.<br \/>\nB. On startup, CKPT coordinates instance recovery.<br \/>\nC. On startup, use RMAN to perform instance recovery.<br \/>\nD. Uncommitted changes will be rolled back after the database is opened.<br \/>\nE. On startup, perform media recovery and then instance recovery.<br \/>\nF. On startup, all the files will be synchronized and you get both committed and uncommitted data.<br \/>\nAnswer: AD<br \/>\n3. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of yourdatabase. Which type of script does the backup scheduler generate?<br \/>\nA. SQL script<br \/>\nB. PL\/SQL script<br \/>\nC. Operating System (OS) script<br \/>\nD. Enterprise Manager (EM) script<br \/>\nE. Recovery Manager (RMAN) script<br \/>\nAnswer: E<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Killtest\u984c\u5eab\u7db21Z0-042\u8003\u984c\u767c\u751f\u66f4\u65b0\uff0c\u8003\u984c\u7531\u539f\u4f86\u7684136\u984c\u8b8a\u70ba148\u984c\uff0c\u8003\u8a66\u7248\u672c\u70baV9.02\u3002 Killtest \u984c\u5eab\u7db2\u4fdd\u8b49\u4f60\u4e00\u6b21\u6027\u901a\u904e1Z0-042\u8003\u8a66\uff0c\u5426\u5247\u5168\u984d\u9000\u6b3e\u3002 \u6211\u5011\u9084\u514d\u8cbb\u63d0\u4f9b1Z0-042\u7684DEMO\u4e0b\u8f09\uff1a PDF \u96fb\u5b50\u6a94\u6848DEMO\u7248\u672c Testing Engine \u6a21\u64ec\u8edf\u9ad4DEMO\u7248\u672c \u90e8\u4efd1Z0-042\u8003\u984c\u5982\u4e0b\uff1a 1. In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05: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? (Choose three.) [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[376,594,593],"class_list":["post-2160","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-1z0-042","tag-1z0-042-"],"_links":{"self":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/2160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2160"}],"version-history":[{"count":4,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/2160\/revisions"}],"predecessor-version":[{"id":2171,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/2160\/revisions\/2171"}],"wp:attachment":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}