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 test Practice - Oracle OCP Performance Tuning Test Questions   Hottest Quizzes Free IQ Test  Oracle OCP test Practice - Oracle OCP Performance Tuning Test Questions Welcome to the QuizMoz Oracle OCP test Practice - Oracle OCP Performance Tuning Test Questions. 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 test Practice - Oracle OCP Performance Tuning Test Questions Facts  Average Score for this quiz: 33.5%  No of times this quiz has been taken: 13  No of people passing this quiz: 2  No of people failing this quiz: 11  Maximum score for this quiz: 50% Coverage : Using Oracle Blocks Efficiently Monitoring and Detecting Lock Contention Diagnosing Contention for Latches Application Tuning SQL Statement Tuning Tuning the Oracle Shared Server Tuning the Operating System and Using Resource Manager Tuning Undo Segments  Oracle OCP test Practice - Oracle OCP Performance Tuning Test Questions Discussion Forum 1.  The optimizer rewrites a query so that the query can access a materialized view instead of the base tables. Although query rewrite activity is transparent to the applications, there are certain prerequisites that need to be satisfied for the optimizer to rewrite queries. Which statement correctly describes one of the prerequisites? a. OPTIMIZER_MODE must be set with cost-based optimization b. QUERY_REWRITE_ENABLED must be specified in the parameter file c. A user who owns the materialized view must also own PLAN_TABLE d. A user must be granted QUERY REWRITE system privilege to enable materialized views in any schema Please provide appropriate updations Ques The optimizer rewrites a query so that the query can access a materialized view instead of the base tables. Although query rewrite activity is transparent to the applications, there are certain prerequisites that need to be satisfied for the optimizer to rewrite queries. Which statement correctly describes one of the prerequisites? a. b. c. d. Please describe the changes made by you 2.  How are deadlocks resolved within Oracle? a. The DBA must terminate the waiting session b. The DBA must terminate the blocking session c. Oracle detects deadlocks automatically and rolls back the statement which detects the deadlock d. TopSessions monitors long running transactions and terminates any session which holds a lock longer than the limit specified by LOCK_THRESHOLD Please provide appropriate updations Ques How are deadlocks resolved within Oracle? a. b. c. d. Please describe the changes made by you 3.  Which statement is true when connecting to the Oracle instance using the multithreaded server configuration? a. The User Global Area (UGA) may only contain sort areas b. The UGA may be accessible to dedicated servers c. The UGA components may reside in the large pool d. The UGA components may reside in the buffer cache Please provide appropriate updations Ques Which statement is true when connecting to the Oracle instance using the multithreaded server configuration? a. b. c. d. Please describe the changes made by you 4.  What are free lists used to identify? a. Blocks available for inserts b. Free extents in a tablespace c. Blocks beyond the high water mark in a segment d. Segments belonging to a Parallel Server instance Please provide appropriate updations Ques What are free lists used to identify? a. b. c. d. Please describe the changes made by you 5.  Which procedure for the DBMS_RESOURCE_MANAGER package should be performed first when creating a new resource object? a. CREATE_PENDING_AREA b. CREATE_PLAN c. CREATE_CONSUMER_GROUP d. CREATE_PLAN_DIRECTIVE Please provide appropriate updations Ques Which procedure for the DBMS_RESOURCE_MANAGER package should be performed first when creating a new resource object? a. b. c. d. Please describe the changes made by you 6.  What are the benefits of using locally managed tablespaces with segment space management set to auto? a. It eliminates the need to set PCTFREE b. It eliminates any need to set PCTFREE or FREELISTS c. It eliminates any need to set PCTUSED or FREELISTS d. It improves the speed of space allocation and deallocation Please provide appropriate updations Ques What are the benefits of using locally managed tablespaces with segment space management set to auto? a. b. c. d. Please describe the changes made by you 7.  Which statement is true regarding partitioned tables and indexes? a. A table which is part of a cluster can be partitioned b. A global bitmap index can be created for a partitioned table c. A table containing LONG or LONG RAW datatypes can be partitioned d. A partitioned table can have partitioned and/or non-partitioned indexes Please provide appropriate updations Ques Which statement is true regarding partitioned tables and indexes? a. b. c. d. Please describe the changes made by you 8.  Which package should be used to grant resource groups to users? a. DBMS_REPCAT_AUTH b. DBMS_REPCAT_ADMIN c. DBMS_RESOURCE_MANAGER d. DBMS_RESOURCE_MANAGER_PRIVS Please provide appropriate updations Ques Which package should be used to grant resource groups to users? a. b. c. d. Please describe the changes made by you 9.  An application that uses a database keeps cursors open. What should be confirmed before changing the CURSOR_SPACE_FOR_TIME parameter in the database initialization file to TRUE? a. The TIMED_STATISTICS parameter is set to TRUE b. The hit percentage in the buffer cache is at least 95% c. The OPEN_CURSOR parameter is set to at least twice the default value d. The value in the RELOADS column of V$LIBRARYCACHE is consistently zero or close to zero Please provide appropriate updations Ques An application that uses a database keeps cursors open. What should be confirmed before changing the CURSOR_SPACE_FOR_TIME parameter in the database initialization file to TRUE? a. b. c. d. Please describe the changes made by you 10.  A table is being imported and it must be ensured that the table is put into a single contiguous area. There is not a single contiguous area large enough for the entire space allocated to the table. What should be done to achieve this? a. Use the cascade option b. Use the constraint option c. Use the primary key option d. Coalesce the tablespace the table is using Please provide appropriate updations Ques A table is being imported and it must be ensured that the table is put into a single contiguous area. There is not a single contiguous area large enough for the entire space allocated to the table. What should be done to achieve this? a. b. c. d. Please describe the changes made by you 11.  What should be done to import data and to avoid migration? a. Use the CASCADE option during import b. Use the COMPRESS option during export c. Use the RECORDLENGTH option during export d. Coalesce free space Please provide appropriate updations Ques What should be done to import data and to avoid migration? a. b. c. d. Please describe the changes made by you 12.  In a DSS application, the sales summary report queries data from seven different tables and groups the data by region and period. Which one of the following storage structures is a good design choice to improve query performance? a. IOT b. Cluster c. Materialized View d. Partion Table Please provide appropriate updations Ques In a DSS application, the sales summary report queries data from seven different tables and groups the data by region and period. Which one of the following storage structures is a good design choice to improve query performance? 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 test Practice - Oracle OCP Performance Tuning Test Questions  Name: Think you know more about Oracle OCP test Practice - Oracle OCP Performance Tuning Test Questions 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 test Practice - Oracle OCP Performance Tuning Test Questions Discussion Forum Know the Latest News about Oracle OCP test Practice - Oracle OCP Performance Tuning Test Questions! What others think about Oracle OCP test Practice - Oracle OCP Performance Tuning Test Questions By: Teena on 11/21/2009    I love this quiz Website. This is the best free quiz site. By: Penny on 11/20/2009    NICE WEBSITE, great quiz! By: Haris on 11/19/2009    These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength. By: Alice on 11/18/2009    Its a very good Quiz. It rocks my socks!!!!! By: quiz girl on 11/17/2009    hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge By: QuizMoz Fan on 11/16/2009    I love all the QuizMoz quizzes. The general knowledge quiz is my favorite By: Quiz Game Player on 11/15/2009    One day I will crack all the Impossible quizzes in the world By: Teresa on 11/14/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: Reema on 11/13/2009    Great Quiz! The quizmaster laid out this quiz so that even beginners could learn more By: Hannah on 11/12/2009    Enjoyed it, and learned a lot about general knowledge By: Roger on 11/11/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Laura on 11/10/2009    I appreciate the time and effort that the quiz maker put into the quiz By: Tom on 11/9/2009    I want more quiz questions By: Nancy on 11/8/2009    I would like to see a complete page of horror movie quizzes for the horror genre fans! By: Personality Quiz Man on 11/7/2009    I love quizzes. Personality Quizzes are my favorite. By: Tallitha on 11/6/2009    This quiz is amazing By: Tracy on 11/5/2009    Great test. A nice way to gauge one's knowledge By: Shannon on 11/4/2009    I have never seen such an excellent quiz website before this. By: Hot girl on 11/3/2009    I love answering Quiz Questions By: Kayla on 11/2/2009    I think this is a great quiz full of knowlodge and information.   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.