OCA OCP Oracle Certification Exam Braindumps

We guarantee your success in the first attempt. If you do not pass the1Z0-043 exam (oracle database 10g:administration ii) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free. Killtest will help you to pass the 1Z0-043 exam. Killtest 1Z0-043 contains 134 questions, multiple choice answers.

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