Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

Users in PROD database reported about the slow responses of the transaction. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?

  1. increase the undo retention

  2. create more undo segments

  3. create another undo tablespace

  4. increase the size of the undo tablespace.
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology databases

Your application demands frequent connection and disconnection from the database. You have three listener processes those are listening for the database PROD. While settings up connect string using Oracle Enterprise Manager 10g Database Control, which two options would you select to balance the connection load across all the listener process? (Choose two)

  1. Use only the first address.

  2. Try one address selected at random.

  3. Try each address, in order, until one succeeds.

  4. Try each address, randomly, until one succeeds.
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Full explanation
Multiple choice technology databases

You started a long transaction before committing; you executed a query on one of the tables currently being modified. You received the following error: ORA- 01555: snapshot too old. How would you prevent such an error in future? (Choose three)

  1. Guarantee undo retention

  2. Add one more redo log group.

  3. Configure an appropriate undo retention interval.

  4. Size the UNDO tablespace appropriately.

  5. Size the SYSTEM tablespace appropriately.
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Full explanation