Home      Tests New!      Polls      Discussion Forums     Take a Quiz     Make a Quiz     Login     Contact QuizMoz         Find a quiz.   Example: Harry Potter Quiz Create your own Poll Create a Test Make a Trivia Quiz Make a Quiz about Yourself Make Free Personality Test Recommend QuizMoz   Personal Injury Law Quizzes   Hottest Quizzes Free IQ Test   Michael Jackson Quiz   English Language Test   Does He Love You Quiz   Business Phone Etiquette Quiz   Impossible Quiz   Personality Quiz   Free Quizzes   India Quiz   ICC World Cup Quiz   Kya Mast Hai Life Quiz   General Knowledge Questions   Are you in Love Quiz   Skeletal System Quiz   Love Personality Quiz   General Knowledge Test         Home > Quizzes and Fun Tests > Oracle OCP Practice Tests > Oracle OCP Practice Test - Oracle 9i OCP Fundamentals   Hottest Quizzes Free IQ Test  Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Welcome to the QuizMoz Oracle OCP Practice Test - Oracle 9i OCP Fundamentals. QuizMoz offers one of the Internet's largest collection of quizzes for you to tease your brain and pit your wits against the experienced QuizMoz quiz masters. Go ahead and find out what you know about yourself and the world around you. Best of luck!!  Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Facts  Average Score for this quiz: 45%  No of times this quiz has been taken: 8  No of people passing this quiz: 5  No of people failing this quiz: 3  Maximum score for this quiz: 75% Coverage : Oracle Architectural Components, Oracle Enterprise Manager, Oracle Architectural Components, Storage Structure and Relationships, Maintaining Redo log Files, Managing the Control Files Managing Tablespace and Datafiles Managing Database Managing an Oracle Instance Creating a Database Getting Started with the Oracle Server Using Data Dictionary and Dynamic Performance Views  Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Discussion Forum 1.  Which tool will help a newly appointed DBA to examine the performance of a database? a. Recovery Manager b. Oracle Enterprise Manager c. Oracle Universal Installer d. Oracle Database Configuration Assistant Please provide appropriate updations Ques Which tool will help a newly appointed DBA to examine the performance of a database? a. b. c. d. Please describe the changes made by you 2.  In which situation would it be most beneficial to use OMF? a. The database's disk subsystem utilizes raw disk devices b. Many user trace files exist that are no longer needed c. A read-only database is maintained and used only to look up static information d. A test database is being created and minimum administration effort is desired for the database Please provide appropriate updations Ques In which situation would it be most beneficial to use OMF? a. b. c. d. Please describe the changes made by you 3.  Which parameters should be set to limit the number of transactions that can simultaneously make changes to data in a block, and increase the frequency with which Oracle returns a block back on the free list? a. INITRANS and PCTUSED b. MAXTRANS and PCTFREE c. INITRANS and PCTFREE d. MAXTRANS and PCTUSED Please provide appropriate updations Ques Which parameters should be set to limit the number of transactions that can simultaneously make changes to data in a block, and increase the frequency with which Oracle returns a block back on the free list? a. b. c. d. Please describe the changes made by you 4.  In which situations does the Log Writer (LGWR) process write the redo entries from the redo log buffer to the current online redo log group? a. When a transaction commits b. When a rollback is executed c. When the redo log buffer is about to become completely full (90%) d. Before the DBWn writes modified blocks in the database buffer cache to the data files Please provide appropriate updations Ques In which situations does the Log Writer (LGWR) process write the redo entries from the redo log buffer to the current online redo log group? a. b. c. d. Please describe the changes made by you 5.  Which of the following statements are true? a. MOUNT mounts the database for certain DBA activities but does not provide user access to the database b. The NOMOUNT command creates only the Data Buffer but does not provide access to the database c. The OPEN command enables users to access the database d. The STARTUP command starts an instance Please provide appropriate updations Ques Which of the following statements are true? a. b. c. d. Please describe the changes made by you 6.  A DBA has issued the following SQL statement: SELECT max_blocks FROM dba_ts_quotas WHERE tablespace_name='USER_TBS' AND username='MARY'; User Mary has unlimited quota on the USER_TBS tablespace. Which value will the query return? a. 0 b. 1 c. -1 d. NULL Please provide appropriate updations Ques A DBA has issued the following SQL statement:<br>SELECT max_blocks<br>FROM dba_ts_quotas<br>WHERE tablespace_name='USER_TBS'<br>AND username='MARY';<br>User Mary has unlimited quota on the USER_TBS tablespace. Which value will the query return? a. b. c. d. Please describe the changes made by you 7.  Consider the SQL statement: UPDATE employee SET first_name='KING' WHERE emp_id = 1007; COMMIT; What happens when a user issues the COMMIT in the above SQL statement? a. Dirty buffers in the database buffer cache are flushed b. The server process places the commit record in the redo log buffer c. Log Writer (LGWR) writes the redo log buffer entries to the redo log files and data files d. The user process notifies the server process that the transaction is complete e. The user process notifies the server process that the resource locks can be released Please provide appropriate updations Ques Consider the SQL statement:<br>UPDATE employee SET first_name='KING'<br>WHERE emp_id = 1007;<br>COMMIT;<br>What happens when a user issues the COMMIT in the above SQL statement? a. b. c. d. e. Please describe the changes made by you 8.  The STARTUP command has just been issued. Which file is checked to determine the state of the database? a. The control file b. The first member of redo log file group 1 c. The data file belonging to the SYSTEM tablespace d. The most recently created archived redo log file Please provide appropriate updations Ques The STARTUP command has just been issued. Which file is checked to determine the state of the database? a. b. c. d. Please describe the changes made by you 9.  What steps should be taken to gather information about checkpoints? a. Set the LOG_CHECKPOINTS_TO_ALERT initialization parameter to TRUE Monitor the alert log file b. Set the LOG_CHECKPOINT_TIMEOUT parameter Force a checkpoint by using the FAST_START_MTTR_TARGET parameter Monitor the alert log file c. Set the LOG_CHECKPOINT_TIMEOUT parameter Force a log switch by using the command ALTER SYSTEM FORCE LOGSWITCH Force a checkpoint by using the command ALTER SYSTEM FORCE CHECKPOINT Monitor the alert log file d. Set the FAST_START_MTTR_TARGET parameter to TRUE Force a checkpoint by using the command ALTER SYSTEM FORCE CHECKPOINT Monitor the alert log file Please provide appropriate updations Ques What steps should be taken to gather information about checkpoints? a. b. c. d. Please describe the changes made by you 10.  A network error unexpectedly terminated a user's database session. What will happen in this scenario? a. A fast commit occurs b. RECO performs the session recovery c. PMON rolls back the user's current transaction d. SMON rolls back the user's current transaction e. SMON frees the system resources reserved for the user session f. PMON releases the table and row locks held by the user session Please provide appropriate updations Ques A network error unexpectedly terminated a user's database session. What will happen in this scenario? a. b. c. d. e. f. Please describe the changes made by you 11.  how to create a table space a. with alter database command b. with alter system command c. using create command d. none of the abovw Please provide appropriate updations Ques how to create a table space a. b. c. d. Please describe the changes made by you 12.  What is the size of Granuales?If SGA size is greater than 128 MB a. 2 b. 4 c. 16 d. 64 Please provide appropriate updations Ques What is the size of Granuales?If SGA size is greater than 128 MB a. b. c. d. Please describe the changes made by you Think you know more about this quiz!   Please enter your Name and what you would like to tell everyone about Oracle OCP Practice Test - Oracle 9i OCP Fundamentals  Name: Think you know more about Oracle OCP Practice Test - Oracle 9i OCP Fundamentals and would like others to know too? Whether its a great fact, a joke, a personal experience or an interesting anecdote, please share it with all the human beings on planet earth. Your contribution will help keep QuizMoz a free site for all.    (Optional)  (average submission size - 5 to 10 lines) Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Discussion Forum Know the Latest News about Oracle OCP Practice Test - Oracle 9i OCP Fundamentals! What others think about Oracle OCP Practice Test - Oracle 9i OCP Fundamentals By: quiz girl on 11/21/2009    hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge By: Shannon on 11/20/2009    I have never seen such an excellent quiz website before this. By: Hannah on 11/19/2009    Enjoyed it, and learned a lot about general knowledge By: Lil Wayne Fan on 11/18/2009    Give me more quiz questions about LilWayne By: Samantha on 11/17/2009    This is so cool. Even though I really did not know some of the questions, it was still fun! By: Tommy on 11/16/2009    Great site. Good learning and fun. By: Penny on 11/15/2009    NICE WEBSITE, great quiz! By: Reema on 11/14/2009    Great Quiz! The quizmaster laid out this quiz so that even beginners could learn more By: Erin on 11/13/2009    it was a fun and interseting quiz! By: Kayla on 11/12/2009    I think this is a great quiz full of knowlodge and information. By: Sridhar on 11/11/2009    Its a really good way to brush up things and informative also. By: Tracy on 11/10/2009    Great test. A nice way to gauge one's knowledge By: Roger on 11/9/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Haris on 11/8/2009    These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength. By: Personality Quiz Man on 11/7/2009    I love quizzes. Personality Quizzes are my favorite. By: Free quiz seeker on 11/6/2009    I am searching for an impossible quiz By: Tallitha on 11/5/2009    This quiz is amazing By: Kath on 11/4/2009    It's a really good quiz. By: Nancy on 11/3/2009    I would like to see a complete page of horror movie quizzes for the horror genre fans! By: Hot girl on 11/2/2009    I love answering Quiz Questions   Hottest Quizzes Free IQ Test   Christmas Quiz   Christmas Quizzes   Kids General Knowledge Quiz   2009 General Knowledge Quiz   2010 General Knowledge Test   Science Quiz for Kids   Medical Terminology Quiz   Career Quiz for Kids   General Knowledge Science Test   Harry Potter Quiz   IQ Tests   Cricket Quiz   Am I Pregnant Quiz   Dating Etiquette Quiz   Email Etiquette Quiz   Home     About Us      Advertise     Terms of Service     Privacy Policy     Contact QuizMoz    FAQ     SiteMap Copyright © 2007.www.quizmoz.com. All rights are reserved.