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

Chapter 19. Practice Exam 1

1:	At what point does the CKPT process write data blocks to the datafiles? [select all that apply] A. Whenever LOG_CHECKPOINT_INTERVAL parameter tells it to. B. Whenever LOG_CHECKPOINT_TIMEOUT tells it to. C. Whenever there is a log switch. D. CKPT doesn't write anything out to files; it tells the other processes to do that.
2:	What should you not do if your database creation script fails? A. Check the SQL syntax. B. Make sure that there is sufficient space in the file system, directory, or drive. C. Rerun the script immediately. D. Delete existing files.
3:	What is the p.password in the following role creation statement? CREATE ROLE accountant IDENTIFIED USING p.password; A. The password for the role B. The procedure to authenticate ...