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 OCP Performance Tuning I   Hottest Quizzes Free IQ Test  Oracle OCP Practice Test - Oracle OCP Performance Tuning I Welcome to the QuizMoz Oracle OCP Practice Test - Oracle OCP Performance Tuning I. 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 OCP Performance Tuning I Facts  Average Score for this quiz: 25.5%  No of times this quiz has been taken: 74  No of people passing this quiz: 19  No of people failing this quiz: 55  Maximum score for this quiz: 87% 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  Oracle OCP Practice Test - Oracle OCP Performance Tuning I Discussion Forum 1.  Which of the following should be a tuning goal? a. Access the least possible number of blocks from disk b. Use as much memory as possible c. Use multiple copies of the code in memory d. Access the most possible number of blocks from disk Please provide appropriate updations Ques Which of the following should be a tuning goal? a. b. c. d. Please describe the changes made by you 2.  Which of the following statements are true regarding the effect of frequent check-pointing on a database? a. Can slow down a commit b. Can affect instance recovery time c. Can cause the CKPT process to hang d. Can be influenced by redo log file size Please provide appropriate updations Ques Which of the following statements are true regarding the effect of frequent check-pointing on a database? a. b. c. d. Please describe the changes made by you 3.  There is a 512-byte OS block size. Every time 10K of data I written from the Redo Log Buffer to the online redo log, a checkpoint event should occur. Which initialization parameter setting will achieve this? a. LOG_BUFFER=10240000 b. LOG_CHECKPOINT_BYTES=10 c. LOG_CHECKPOINT_TIMEOUT=10 d. LOG_CHECKPOINT_INTERVAL=20 Please provide appropriate updations Ques There is a 512-byte OS block size. Every time 10K of data I written from the Redo Log Buffer to the online redo log, a checkpoint event should occur. Which initialization parameter setting will achieve this? a. b. c. d. Please describe the changes made by you 4.  Which view shows the number of full table scans? a. V$SYSSTAT b. V$FILESTAT c. V$SESSION d. V$DATAFILE Please provide appropriate updations Ques Which view shows the number of full table scans? a. b. c. d. Please describe the changes made by you 5.  The KEEP buffer pool and issue ANALYZE…. ESTIMATE STATISTIC command are being sized. Which data dictionary tables should be queried to obtain the total number of blocks required for an object? a. DBA_TABLES b. DBA_INDEXES c. DBA_SEGMENTS d. DBA_CLUSTERS Please provide appropriate updations Ques The KEEP buffer pool and issue ANALYZE…. ESTIMATE STATISTIC command are being sized. Which data dictionary tables should be queried to obtain the total number of blocks required for an object? a. b. c. d. Please describe the changes made by you 6.  Summing the system statistics, (db blocks gets + consistent gets) gives the total number of requests. What is the other system that statistic required to calculate the buffer cache hit ratio? a. Physical reads b. Session logical gotten c. Table scan blocks gotten d. DBWR buffers scanned Please provide appropriate updations Ques Summing the system statistics, (db blocks gets + consistent gets) gives the total number of requests. What is the other system that statistic required to calculate the buffer cache hit ratio? a. b. c. d. Please describe the changes made by you 7.  Which tablespace is used as the temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user? a. TEMP b. SYSTEM c. DATA d. ROLLBACK Please provide appropriate updations Ques Which tablespace is used as the temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user? a. b. c. d. Please describe the changes made by you 8.  When a parallel query is used to perform a sort, what is the total amount of memory a factor to? a. SORT_AREA_SIZE * 2 b. SORT_AREA_SIZE * degree of parallelism c. SORT_AREA_SIZE * divided up equally among the parallel query servers d. SORT_AREA_SIZE *2* degree of parallelism Please provide appropriate updations Ques When a parallel query is used to perform a sort, what is the total amount of memory a factor to? a. b. c. d. Please describe the changes made by you 9.  Which types of tuning session scopes can Oracle Expert provide? a. Session b. Instance c. Structure d. Operating system Please provide appropriate updations Ques Which types of tuning session scopes can Oracle Expert provide? a. b. c. d. Please describe the changes made by you 10.  Which statement is true when evaluating the buffer cache hit ratio? a. The buffer cache hit ratio is unaffected by data or application design b. The buffer cache hit ratio will improve the use of full table scans c. The buffer cache hit ratio will always improve when the number of db block buffers in the SGA is increased d. Minimizing physical reads will improve the buffer cache hit Please provide appropriate updations Ques Which statement is true when evaluating the buffer cache hit ratio? a. b. c. d. Please describe the changes made by you 11.  Why can a value of zero be NEVER achieved in the GETMISSES column of V$ROWCACHE? a. The database buffer cache can never be empty b. Recursive SQL has to be reparsed each time it is used c. Object definition must be loaded into the shared pool following instance startup d. An object cannot be pinned in the shared pool with the DBMS_SHARED_POOL package until it has been at least once Please provide appropriate updations Ques Why can a value of zero be NEVER achieved in the GETMISSES column of V$ROWCACHE? a. b. c. d. Please describe the changes made by you 12.  When the archive process encounters an error, which parameter determines the directory where trace files are written? a. BACKGROUND_DUMP_DEST b. UTL_FILE_DIR c. CORE_DUMP_DEST d. LOG_ARCHIVE_DEST Please provide appropriate updations Ques When the archive process encounters an error, which parameter determines the directory where trace files are written? a. b. c. d. Please describe the changes made by you 13.  Which statement about the PCTFREE parameter is true? a. If zero update activity is expected on the data, the PCTFREE value should be set to 100 to maximize data block utilization b. The PCTFREE parameter sets the minimum percentage of a data block that can be used for future inserts of new rows in that block c. A smaller PCTFREE is suitable for segments that are frequently updated, and will improve update performance d. The PCTFREE parameter sets the minimum percentage of a data block to be reserved for future updates to rows that already exist in that block Please provide appropriate updations Ques Which statement about the PCTFREE parameter is true? a. b. c. d. Please describe the changes made by you 14.  Which condition causes the message "ORA - 29554: unhandled Java out of memory condition"? a. JAVA_MAX_SESSIONSPACE_SIZE is reached b. JAVA_SOFT_SESSIONSPACE_LIMIT is reached c. A user's session-duration state exceeds 1 M d. Java Pool 'memory in use' is equal to the JAVA_POOL_SIZE setting Please provide appropriate updations Ques Which condition causes the message "ORA - 29554: unhandled Java out of memory condition"? a. b. c. d. Please describe the changes made by you 15.  What is the correct syntax to ensure an object is not aged out of the shared pool? a. EXECUTE dbms_shared_pool.keep('package_name'); b. EXECUTE dbms_shared_pool.pin('package_name'); c. EXECUTE dbms_shared_pool.unkeep('package_name'); d. EXECUTE dbms_shared_pool.retain('package_name'); e. EXECUTE dbms_shared_pool.refresh('package_name'); Please provide appropriate updations Ques What is the correct syntax to ensure an object is not aged out of the shared pool? a. b. c. d. e. Please describe the changes made by you 16.  Which actions can help avoid the disadvantages of dynamic extent allocation? a. Use locally managed tablespaces b. Use Oracle default sizing c. Size the segments appropriately d. Use globally managed tablespaces e. Use recursive space management operations Please provide appropriate updations Ques Which actions can help avoid the disadvantages of dynamic extent allocation? a. b. c. d. e. Please describe the changes made by you 17.  There are several tables which are updated frequently. These updates are populating null columns with data. Which sizing would be least likely to cause migration? a. DB_BLOCK_SIZE = 8192; PCTFREE 5 b. DB_BLOCK_SIZE = 4096; PCTFREE 10 c. DB_BLOCK_SIZE = 8192; PCTFREE 0 d. DB_BLOCK_SIZE = 2048; PCTFREE 20 Please provide appropriate updations Ques There are several tables which are updated frequently. These updates are populating null columns with data. Which sizing would be least likely to cause migration? a. b. c. d. Please describe the changes made by you 18.  Which of the following commands force DBWR to write dirty buffers to disk? a. CMOOT b. ROLLBACK c. SHUTDOWN IMMEDIATE d. ALTER TABLESPACE A BEGIN BACKUP Please provide appropriate updations Ques Which of the following commands force DBWR to write dirty buffers to disk? a. b. c. d. Please describe the changes made by you 19.  Which dynamic view is most useful for determining the hit ratio for multiple buffer pools? a. V$CACHE b. V$SYSSTAT c. V$BUFFER_POOL d. V$BUFFER_POOL_STATISTICS Please provide appropriate updations Ques Which dynamic view is most useful for determining the hit ratio for multiple buffer pools? a. b. c. d. Please describe the changes made by you 20.  It is determined that the value for REQUEST_FAILURES as seen from V$SHARED_POOL_RESERVED is more than zero and always increasing. What action would be appropriate? a. Increase the value for the LARGE_POOL_SIZE parameter b. Decrease the value for the LARGE_POOL_SIZE parameter c. Increase the value for the SHARED_POOL_RESERVED_SIZE parameter d. Decrease the value for the SHARED_POOL_RESERVED_SIZE parameter Please provide appropriate updations Ques It is determined that the value for REQUEST_FAILURES as seen from V$SHARED_POOL_RESERVED is more than zero and always increasing. What action would be appropriate? a. b. c. d. Please describe the changes made by you 21.  STATSPACK report shows a buffer busy waits. Detailed analysis shows that it's related with freelists contention. What should be done to fix this issue and add freelists? a. Search for a segment header, causing contention and issue the command ALTER TABLE…FREELIST b. Search for a data block, causing contention and issue the command ALTER TABLE … FREELIST c. Search for a data block, causing contention and issue the command ALTER TABLESPACE … FREELIST d. Search for a segment header, causing contention and issue the command ALTER TABLESPACE … FREELIST Please provide appropriate updations Ques STATSPACK report shows a buffer busy waits. Detailed analysis shows that it's related with freelists contention. What should be done to fix this issue and add freelists? a. b. c. d. Please describe the changes made by you 22.  What is PGA_AGGREGATE_TARGET? a. Initialization parameter to enable automatic PGA memory management b. Initialization parameter for sort-based operators c. Initialization parameter for hash-join operations d. Initialization parameter for bitmap merge and bitmap create operations Please provide appropriate updations Ques What is PGA_AGGREGATE_TARGET? a. b. c. d. Please describe the changes made by you 23.  By setting which init.ora parameter can the DBA modify the default locking mechanism? a. ROW_LOCKING=DEFAULT b. ROW_LOCKING=INTENT c. ROW_LOCKING=ROW d. ROW_LOCKING=TABLE Please provide appropriate updations Ques By setting which init.ora parameter can the DBA modify the default locking mechanism? 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 OCP Performance Tuning I  Name: Think you know more about Oracle OCP Practice Test - Oracle OCP Performance Tuning I 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 OCP Performance Tuning I Discussion Forum Know the Latest News about Oracle OCP Practice Test - Oracle OCP Performance Tuning I! What others think about Oracle OCP Practice Test - Oracle OCP Performance Tuning I By: Samantha on 11/21/2009    This is so cool. Even though I really did not know some of the questions, it was still fun! By: general knowledge seeker on 11/20/2009    i love to take tests and quizzes. quizzes are my life. general knowledge questions are good for everyone By: Shannon on 11/19/2009    I have never seen such an excellent quiz website before this. By: Roger on 11/18/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Haris on 11/17/2009    These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength. By: Sridhar on 11/16/2009    Its a really good way to brush up things and informative also. By: Erin on 11/15/2009    it was a fun and interseting quiz! By: Quiz Game Player on 11/14/2009    One day I will crack all the Impossible quizzes in the world By: Aumkar on 11/13/2009    It was enjoyable. By: Free quiz seeker on 11/12/2009    I am searching for an impossible quiz By: Laura on 11/11/2009    I appreciate the time and effort that the quiz maker put into the quiz By: Kayla on 11/10/2009    I think this is a great quiz full of knowlodge and information. By: Kath on 11/9/2009    It's a really good quiz. By: Tallitha on 11/8/2009    This quiz is amazing By: Hot girl on 11/7/2009    I love answering Quiz Questions By: Roger on 11/6/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Personality Quiz Man on 11/5/2009    I love quizzes. Personality Quizzes are my favorite. By: QuizMoz Fan on 11/4/2009    I love all the QuizMoz quizzes. The general knowledge quiz is my favorite By: Nancy on 11/3/2009    I would like to see a complete page of horror movie quizzes for the horror genre fans! By: Teena on 11/2/2009    I love this quiz Website. This is the best free 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.