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 > Free Oracle Test OCP Practice Test - Oracle OCP Performance Tuning   Hottest Quizzes Free IQ Test  Free Oracle Test OCP Practice Test - Oracle OCP Performance Tuning Welcome to the QuizMoz Free Oracle Test OCP Practice Test - Oracle OCP Performance Tuning. 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!!  Free Oracle Test OCP Practice Test - Oracle OCP Performance Tuning Facts  Average Score for this quiz: 35%  No of times this quiz has been taken: 12  No of people passing this quiz: 3  No of people failing this quiz: 9  Maximum score for this quiz: 75% Coverage : Database Configuration and I/O Issues Sizing Other SGA Structure Optimizing Sort Operations Diagnosing Contention for Latches Overview Of Oracle 9i Performance Tuning Sizing the Buffer Cache Diagnostic and Tuning Tools Sizing the Shared Pool Overview of Oracle 9i Performance Tuning  Free Oracle Test OCP Practice Test - Oracle OCP Performance Tuning Discussion Forum 1.  When tables are stored in locally managed tablespaces, where is extent allocation information stored? a. Memory b. Within the locally managed tablespace c. Data dictionary d. Temporary tablespace Please provide appropriate updations Ques When tables are stored in locally managed tablespaces, where is extent allocation information stored? a. b. c. d. Please describe the changes made by you 2.  What is the difference between I/O slaves and DBWn processes for the DB Writer? a. In Oracle8i, I/O slaves are not available; only DBWn processes are available b. I/O slaves perform the write function only, while DBWn processes also perform date-gathering activity c. I/O slaves will work only with synchronous I/O, whereas DBWn processes are available only within asynchronous I/0 d. I/O slaves will work only with asynchronous I/O, whereas DBWn processes are available only within synchronous I/0 Please provide appropriate updations Ques What is the difference between I/O slaves and DBWn processes for the DB Writer? a. b. c. d. Please describe the changes made by you 3.  FAST_START_MTTR_TARGET is set so that instance recovery will take 5 minutes. Which view offers information regarding the systems ability to match the target? a. UNDO$ b. V$DATAFILE c. V$FILESTAT d. V$INSTANCE_RECOVERY Please provide appropriate updations Ques FAST_START_MTTR_TARGET is set so that instance recovery will take 5 minutes. Which view offers information regarding the systems ability to match the target? a. b. c. d. Please describe the changes made by you 4.  A latch is defines as: a. A mechanism used by the Oracle optimizer to run user queries in parallel b. A mechanism to prevent data files that make up the database from auto-extending d. A mechanism used by the background process PMON for cleaning up the caches and freeing up resources the user processes were using A low-level serialization mechanism to protect shared data structures in the system global area Please provide appropriate updations Ques A latch is defines as: a. b. d. Please describe the changes made by you 5.  To control fragmentation of a shared pool space, what is the best time to pin objects with the DBMS_SHARED_POOL package? a. Immediately after instance startup b. After an object has been used for the first time c. When the V$LIBRARYCACHE view contains higher values in the RELOADS column than in the PINS column d. When the sum of values in the SHARABLE_MEMORY column of the V$DB_OBJECT_CACHE view exceeds the value of the SHARED_POOL_SIZE initialization parameter Please provide appropriate updations Ques To control fragmentation of a shared pool space, what is the best time to pin objects with the DBMS_SHARED_POOL package? a. b. c. d. Please describe the changes made by you 6.  A database is used by an OLTP application. What is the recommended Library Cache GETHITRATIO percentage that should be achieved? How can the GETHITRATIO percentage be increased in the V$LIBRARYCACHE? a. 90% - 100%;improve the efficiency of the application code b. 80% - 85%; analyze the tables c. 85% - 90%; improve performance by increasing the SHARED_POOL_SIZE d. 90% - 95%; improve performance by increasing the LARGE_POOL_SIZE Please provide appropriate updations Ques A database is used by an OLTP application.<br>What is the recommended Library Cache GETHITRATIO percentage that should be achieved? How can the GETHITRATIO percentage be increased in the V$LIBRARYCACHE? a. b. c. d. Please describe the changes made by you 7.  Which types of information found in the alert log are relevant for database performance tuning? a. Checkpoint Not Complete b. Database Name c. Internal Errors ControlFile Reuse d. Core Dump Destination Please provide appropriate updations Ques Which types of information found in the alert log are relevant for database performance tuning? a. b. c. d. Please describe the changes made by you 8.  Which utility will collect detail info regarding the execution of SQL statements? a. Log Miner b. UTLBSTAT/UTLESTAT c. TKPROF d. SQL TRACE Please provide appropriate updations Ques Which utility will collect detail info regarding the execution of SQL statements? a. b. c. d. Please describe the changes made by you 9.  What should be the first step in the tuning process? a. Tune the OS b. Tune database I/O c. First monitor performance d. Tune the design Please provide appropriate updations Ques What should be the first step in the tuning process? a. b. c. d. Please describe the changes made by you 10.  Which of the following will reduce the number of disk sorts? a. Increasing SORT_AREA_SIZE b. Decreasing SORT_AREA_RETAINED_SIZE c. Increasing the SORT_MEMORY_ALLOCATED parameter d. Altering SORT_AREA_SIZE dynamically based on available memory within SGA_MAX_SIZE Please provide appropriate updations Ques Which of the following will reduce the number of disk sorts? a. b. c. d. Please describe the changes made by you 11.  What is the purpose of a checkpoint? a. Write the current redo log to the archived redo log b. Synchronize the modified data blocks in memory with the datafiles on disk c. Ensure database consistency d. Ensure that data blocks are read into memory as quickly as possible e. Keep track of redo entries Please provide appropriate updations Ques What is the purpose of a checkpoint? a. b. c. d. e. Please describe the changes made by you 12.  Which of the following SQL statements cause a sort operation? a. CREATE TABLE b. GROUP BY c. UNION d. UNION ALL e. SORT BY Please provide appropriate updations Ques Which of the following SQL statements cause a sort operation? a. b. c. d. e. 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 Free Oracle Test OCP Practice Test - Oracle OCP Performance Tuning  Name: Think you know more about Free Oracle Test OCP Practice Test - Oracle OCP Performance Tuning 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) Free Oracle Test OCP Practice Test - Oracle OCP Performance Tuning Discussion Forum Know the Latest News about Free Oracle Test OCP Practice Test - Oracle OCP Performance Tuning! What others think about Free Oracle Test OCP Practice Test - Oracle OCP Performance Tuning By: Bobby Kalsi on 11/21/2009    Try to make it easier to search for a QUIZ Category.. (It should be easier to seach for a quiz category...) By: Teresa on 11/20/2009    I took the quiz. It let me know that I failed. But I wasn't able to see what the correct answers. It would be great to see what the answers are so I can learn. By: Sridhar on 11/19/2009    Its a really good way to brush up things and informative also. By: Roger on 11/18/2009    I love Quiz Games. QuizMoz is an excellent Quiz site 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: Aumkar on 11/16/2009    It was enjoyable. By: Personality Quiz Man on 11/15/2009    I love quizzes. Personality Quizzes are my favorite. By: Alice on 11/14/2009    Its a very good Quiz. It rocks my socks!!!!! By: Teena on 11/13/2009    I love this quiz Website. This is the best free quiz site. By: Shannon on 11/12/2009    I have never seen such an excellent quiz website before this. By: Dave on 11/11/2009    I really enjoyed this quiz. I will take a lot of information away with me. Great quiz By: QuizMoz Fan on 11/10/2009    I love all the QuizMoz quizzes. The general knowledge quiz is my favorite By: Erin on 11/9/2009    it was a fun and interseting quiz! By: Tallitha on 11/8/2009    This quiz is amazing By: Hot girl on 11/7/2009    I love answering Quiz Questions By: Kayla on 11/6/2009    I think this is a great quiz full of knowlodge and information. By: Laura on 11/5/2009    I appreciate the time and effort that the quiz maker put into the quiz By: Free quiz seeker on 11/4/2009    I am searching for an impossible quiz By: Reema on 11/3/2009    Great Quiz! The quizmaster laid out this quiz so that even beginners could learn more By: Roger on 11/2/2009    I love Quiz Games. QuizMoz is an excellent Quiz site   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.