We guarantee your success in the first attempt. If you do not pass the 1z0-031 exam (orcacle9i database:fundamentals i) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free. TestPassport will help you to pass the 1z0-031 exam. TestPassport 1z0-031 contains 169 questions, multiple choice answers.
1. While updating the rows in a table you realize that one of the rows violates a constraint on the table, thereby causing the update to fail. Which statement is true in this scenario?
A.The undo data is moved to a temporary segment.
B.The undo data is retained and marked as obsolete.
C.The undo data is retained and reused when the update is executed again.
D.The space used by undo data is freed up to be reused by another transaction.
Answer: D
2. Which two statements are true for a bitmap index? (Choose two.)
A.It is recommended for the columns that have unique values.
B.It stores a string of bits that represent the key column values.
C.It can be converted to a B-Tree index by using the ALTER INDEX command.
D.The updating to the key column locks the whole bitmap segment that contains the bit for the key value to be updated.
Answer: BD
3. You want the Oracle server to force all the users of the administration department to change their passwords at regular intervals. What would you use to implement this?
A.role
B.profile
C.system privilege
D.database trigger
E.Database Resource Manager
Answer: B
Tags:
Post comment:
◎welcome to give out your point。