Study tips 1Z0-053

What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?

Which statement about the result is true?

Which statements are true regarding the Query Result Cache?

What would happen?

Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?

which of the following memory-management options?

which of the following memory management features?

which of the following initialization parameters?

which of the following parameter changes requires an instance restart to take effect?

which of the following pools does Oracle EM offer advice to set the value appropriately?