Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Chapter 21. Practice Exam 2

1:	You are the new DBA onsite, and you need to find the name and location of your control files. Which of the following is not a location in which you can find that information? A. V$PARAMETER B. V$CONTROLFILE C. V$CONTROLFILE_RECORD_SECTION D. spfil<sid>.ora file
2:	User Michael has INSERT privileges on the GL_RECORDS table. What will Michael notice first when you revoke this privilege? A. All the records inserted by the user will be removed from the database. B. The user will be removed from the database. C. The user will no longer be able to create tables. D. The user will not be able insert any more information into the GL_RECORDS table.
3:	The location and size of all the indexes in your database can be found in which data ...