Authorized user can see question and answers. Please log in or sign up. Help Braindumps.com.ua to be introduced.
Oracle 1Z0-031: Oracle9i: Database Fundamentals I
#1. Which Oracle server component is a combination of the background processes and memory structures?
#2. Which statement about the System Global Area (SGA) is true?
#3. You need to turn off the buffer cache advisory. The memory for the advisory should still be allocated. Which statement should you use?
#4. If a user abnormally terminates a database connection, which background process will roll back the user's current transaction and release the table and row locks held by the user session?
#5. What will happen if an Oracle server process attempts to move a buffer to the dirty list and it is full?
#6. Which Oracle background process checks for consistency of the database and, if necessary, initiates instance recovery when the database is opened?
#7. The ______ is a memory area used to store all database information that is shared by database processes.
#8. Which file(s) stores all changes made to the database for recovery purposes?
#9. Which four background processes perform I/O? (Choose four.)
#10. Which would cause a user process to establish a connection with the Oracle server?