{"id":1263,"date":"2010-05-21T22:32:21","date_gmt":"2010-05-22T02:32:21","guid":{"rendered":"http:\/\/www.killtest.hk\/?p=1263"},"modified":"2010-07-22T05:06:06","modified_gmt":"2010-07-22T09:06:06","slug":"oracle-1z0-042-5-20","status":"publish","type":"post","link":"https:\/\/www.killtest.hk\/index.php\/oracle\/oracle-1z0-042-5-20\/","title":{"rendered":"Oracle 1Z0-042 \u8003\u984c5.20\u767c\u751f\u66f4\u65b0"},"content":{"rendered":"<p>Killtest\u984c\u5eab\u7db2<a href=\"http:\/\/www.killtest.net\/10gDBA\/1Z0-042.asp\" target=\"_blank\">1Z0-042<\/a>\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\u4f9b1Z0-042\u7684DEMO\u4e0b\u8f09\uff1a<a href=\"http:\/\/pdf.KillTest.net\/1Z0-042.pdf\" target=\"blank\">PDF \u96fb\u5b50\u6a94\u6848DEMO\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 K [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[353,464,465],"class_list":["post-1263","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-1z0-042","tag-1z0-042-"],"_links":{"self":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/comments?post=1263"}],"version-history":[{"count":0,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1263\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/media?parent=1263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/categories?post=1263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/tags?post=1263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}