{"id":806,"date":"2009-01-31T19:20:10","date_gmt":"2009-01-31T11:20:10","guid":{"rendered":"http:\/\/www.killtest.com.tw\/?p=806"},"modified":"2009-01-31T19:22:48","modified_gmt":"2009-01-31T11:22:48","slug":"1z0-043-3","status":"publish","type":"post","link":"https:\/\/www.killtest.com.tw\/?p=806","title":{"rendered":"1z0-043"},"content":{"rendered":"<p>10g DBA <a title=\"1z0-043\" href=\"http:\/\/www.killtest.net\/10gDBA\/1z0-043.asp\" target=\"_blank\"><strong><span style=\"color: #ff0000;\">1Z0-043<\/span><\/strong><\/a>\u8003\u8a66\u984c\u5eab\u7531KillTest\u8a8d\u8b49\u984c\u5eab\u7db2\u8cc7\u6df1IT\u8a8d\u8b49\u8b1b\u5e2b\u548c10g DBA\u7522\u54c1\u5c08\u5bb6\u7d50\u5408PROMETRIC\u6216VUE\u7684\u771f\u5be61Z0-043\u8003\u8a66\u74b0\u5883\u6700\u65b0\u539f\u984c\u50be\u5fc3\u6253\u9020\u3002\u984c\u5eab\u8986\u84cb\u4e86\u7576\u524d\u6700\u65b0\u7684\u771f\u5be6\u8003\u984c\uff0c\u4e26\u4e14\u5168\u90e8\u9644\u6709\u6b63\u78ba\u7b54\u6848\uff0c\u6211\u5011\u627f\u8afe\u984c\u5eab\u5c0d10g DBA 1Z0-043(oracle database 10g:administration ii)\u8003\u8a66\u539f\u984c\u5b8c\u6574\u8986\u84cb\u30021Z0-043\u984c\u5eab\u52a9\u60a8\u8f15\u9b06\u901a\u904e\u8a8d\u8b49\u8003\u8a66\uff0c\u4e00\u6b21\u4e0d\u904e\u5168\u984d\u9000\u6b3e\u3002<\/p>\n<p>1.Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table: ERROR at line 1: ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed? (Choose two.)<br \/>\nA.drop and re-create the index<br \/>\nB.coalesce the ORDERS_IND index<br \/>\nC.coalesce the INDEXES tablespace<br \/>\nD.drop and re-create the ORDERS table<br \/>\nE.rebuild the index online and move it to another tablespace<br \/>\nCorrect:B E<br \/>\n2.You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL&gt; RECOVER DATABASE 2 UNTIL TIME &#8216;2004-08-05:12:10:03&#8217; 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?<br \/>\nA.A user table was lost at the specified time.<br \/>\nB.A redo log file was lost at the specified time.<br \/>\nC.The backup control file is on a faster disk than the current one.<br \/>\nD.The current control file has a different path compared with the intended time of recovery.<br \/>\nE.The current control file does not match the physical structure of the database at the intended time of recovery.<br \/>\nCorrect:E<br \/>\n3.Which two statements are correct regarding the Oracle Flashback Drop feature? (Choose two.)<br \/>\nA.Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.<br \/>\nB.You can flash back a dropped table provided row movement has been enabled on the table.<br \/>\nC.If you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.<br \/>\nD.When you execute the DROP TABLESPACE INCLUDING CONTENTS command, the objects in the tablespace are placed in the recycle bin.<br \/>\nE.When a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.<br \/>\nF.If you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.<br \/>\nCorrect:A C<\/p>\n<p>10g DBA <a title=\"1z0-043\" href=\"http:\/\/www.killtest.com.tw\/index.php\/oracle\/1z0-043-3\/\" target=\"_blank\"><strong>1Z0-043<\/strong><\/a>(oracle database 10g:administration ii)\u8003\u984c\u7531\u6211\u5011\u7684\u8cc7\u6df1IT\u8a8d\u8b49\u8b1b\u5e2b\u548c10g DBA\u7522\u54c1\u5c08\u5bb6\u7cbe\u5fc3\u6253\u9020\uff0c\u5305\u62ec\u4e86\u7576\u524d\u6700\u65b0\u7684\u771f\u5be61Z0-043\u8003\u984c\uff0c\u5168\u90e8\u9644\u6709\u6b63\u78ba\u7b54\u6848\u3002\u6240\u6709\u8cfc\u8cb7KillTest 1Z0-043 \u984c\u5eab\u7684\u5ba2\u6236\u90fd\u5c07\u5f97\u523060\u5929\u7684\u514d\u8cbb\u5347\u7d1a\u670d\u52d9\uff0c\u4fdd\u8b49\u4e86\u5ba2\u6236\u7684\u4e00\u6b21\u901a\u904e\u7387\u3002KillTest IT\u8a8d\u8b49\u984c\u5eab\u7db2\u52a9\u60a8\u4e00\u6b21\u901a\u904e10g DBA 1Z0-043\u8003\u8a66\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>10g DBA 1Z0-043\u8003\u8a66\u984c\u5eab\u7531KillTest\u8a8d\u8b49\u984c\u5eab\u7db2\u8cc7\u6df1IT\u8a8d\u8b49\u8b1b\u5e2b\u548c10g DBA\u7522\u54c1\u5c08\u5bb6\u7d50\u5408PROMETRIC\u6216VUE\u7684\u771f\u5be61Z0-043\u8003\u8a66\u74b0\u5883\u6700\u65b0\u539f\u984c\u50be\u5fc3\u6253\u9020\u3002\u984c\u5eab\u8986\u84cb\u4e86\u7576\u524d\u6700\u65b0\u7684\u771f\u5be6\u8003\u984c\uff0c\u4e26\u4e14\u5168\u90e8\u9644\u6709\u6b63\u78ba\u7b54\u6848\uff0c\u6211\u5011\u627f\u8afe\u984c\u5eab\u5c0d10g DBA 1Z0-043(oracle database 10g:administration ii)\u8003\u8a66\u539f\u984c\u5b8c\u6574\u8986\u84cb\u30021Z0-043\u984c\u5eab\u52a9\u60a8\u8f15\u9b06\u901a\u904e\u8a8d\u8b49\u8003\u8a66\uff0c\u4e00\u6b21\u4e0d\u904e\u5168\u984d\u9000\u6b3e\u3002 1.Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table: ERROR at line 1: ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating, you find that the INDEXES tablespace [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[248,23,3163],"class_list":["post-806","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-1z0-043","tag-dba","tag-oracle"],"_links":{"self":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/806","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=806"}],"version-history":[{"count":2,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/806\/revisions"}],"predecessor-version":[{"id":808,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/806\/revisions\/808"}],"wp:attachment":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}