10g DBA 1Z0-043考試題庫由KillTest認證題庫網資深IT認證講師和10g DBA產品專家結合PROMETRIC或VUE的真實1Z0-043考試環境最新原題傾心打造。題庫覆蓋了當前最新的真實考題，並且全部附有正確答案，我們承諾題庫對10g DBA 1Z0-043(oracle database 10g:administration ii)考試原題完整覆蓋。1Z0-043題庫助您輕鬆通過認證考試，一次不過全額退款。
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.)
A.drop and re-create the index
B.coalesce the ORDERS_IND index
C.coalesce the INDEXES tablespace
D.drop and re-create the ORDERS table
E.rebuild the index online and move it to another tablespace
Correct:B E
2.You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME ‘2004-08-05:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?
A.A user table was lost at the specified time.
B.A redo log file was lost at the specified time.
C.The backup control file is on a faster disk than the current one.
D.The current control file has a different path compared with the intended time of recovery.
E.The current control file does not match the physical structure of the database at the intended time of recovery.
Correct:E
3.Which two statements are correct regarding the Oracle Flashback Drop feature? (Choose two.)
A.Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.
B.You can flash back a dropped table provided row movement has been enabled on the table.
C.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.
D.When you execute the DROP TABLESPACE INCLUDING CONTENTS command, the objects in the tablespace are placed in the recycle bin.
E.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.
F.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.
Correct:A C
10g DBA 1Z0-043(oracle database 10g:administration ii)考題由我們的資深IT認證講師和10g DBA產品專家精心打造，包括了當前最新的真實1Z0-043考題，全部附有正確答案。所有購買KillTest 1Z0-043 題庫的客戶都將得到60天的免費升級服務，保證了客戶的一次通過率。KillTest IT認證題庫網助您一次通過10g DBA 1Z0-043考試。