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 10g Upgradation II   Hottest Quizzes Free IQ Test  Oracle OCP Practice Test - Oracle OCP 10g Upgradation II Welcome to the QuizMoz Oracle OCP Practice Test - Oracle OCP 10g Upgradation II. 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 10g Upgradation II Facts  Average Score for this quiz: 19.5%  No of times this quiz has been taken: 76  No of people passing this quiz: 12  No of people failing this quiz: 64  Maximum score for this quiz: 86% Coverage : Database Tuning Redo logs Instance Configuration Oracle Architecture Indexes Data Migration Automatic Database Management Oracle Server  Oracle OCP Practice Test - Oracle OCP 10g Upgradation II Discussion Forum 1.  How can the SQL Access Advisor be managed? a. Through the DBMS_SQLTUNE package b. Through the DBMS_ADVISOR package c. Through the SQL_TUNE package d. Through the DBA_ADVISOR package Please provide appropriate updations Ques How can the SQL Access Advisor be managed? a. b. c. d. Please describe the changes made by you 2.  What is the default value for the OPTIMIZER_MODE initialization parameter? a. FIRST_ROWS b. ALL_ROWS c. CHOOSE d. COST Please provide appropriate updations Ques What is the default value for the OPTIMIZER_MODE initialization parameter? a. b. c. d. Please describe the changes made by you 3.  For which two constraints are indexes created when the constraint is added? a. Check b. Unique c. Not null d. Primary key Please provide appropriate updations Ques For which two constraints are indexes created when the constraint is added? a. b. c. d. Please describe the changes made by you 4.  Which of the following statements are true about rebuilding indexes? a. The ALTER INDEX REBUILD command is used to change the storage characteristics of an index b. Using the ALTER INDEX REBUILD is usually faster than dropping and recreating an index because it uses the fast full scan feature c. Oracle8i allows for the creation of an index or re-creation of an existing index while allowing concurrent operations on the base table d. When building an index, the NOLOGGING and UNRECOVERABLE keywords can be used concurrently to reduce the time it takes to rebuild Please provide appropriate updations Ques Which of the following statements are true about rebuilding indexes? a. b. c. d. Please describe the changes made by you 5.  For how long does Oracle, by default, retain the undo information? a. 31 days b. 15 minutes c. 30 minutes d. 7 days Please provide appropriate updations Ques For how long does Oracle, by default, retain the undo information? a. b. c. d. Please describe the changes made by you 6.  What should be done to retrieve the ADDM reports using SQL? a. Run the addmrpt.sql SQL script b. Use the DBA_ADDM view c. Use the DBA_ADVISOR view d. Use the DBMS_ADDM package Please provide appropriate updations Ques What should be done to retrieve the ADDM reports using SQL? a. b. c. d. Please describe the changes made by you 7.  What does the TRCSESS utility do? a. Help you enable a sessionwide trace b. Help to interpret end-to-end tracing output c. Consolidate information from several trace files into a single output d. Stress the system to see how much load it can handle when a new SQL statement is introduced in the database Please provide appropriate updations Ques What does the TRCSESS utility do? a. b. c. d. Please describe the changes made by you 8.  Which of the following areas does the OEM Database Control Performance page focus on when managing database performance? a. CPU and wait Classes b. Top SQL statements in the instance c. Top sessions in the instance d. Database hit ratios e. Top users in the instance Please provide appropriate updations Ques Which of the following areas does the OEM Database Control Performance page focus on when managing database performance? a. b. c. d. e. Please describe the changes made by you 9.  What do the first three-color bands on a resistor indicate? a. The resistance material b. The power rating in watts c. The value of the resistor in ohms d. The resistance tolerance in percent Please provide appropriate updations Ques What do the first three-color bands on a resistor indicate? a. b. c. d. Please describe the changes made by you 10.  Which of the following physical structures constitute the Oracle database? a. Segment b. Data file c. Log file d. Tablespace e. Control file Please provide appropriate updations Ques Which of the following physical structures constitute the Oracle database? a. b. c. d. e. Please describe the changes made by you 11.  Which graphical DBA administration tool would be used to tune an Oracle database? a. SQL*Plus b. Oracle Enterprise Manager c. Oracle Universal Installer d. Oracle Database Configuration Assistant Please provide appropriate updations Ques Which graphical DBA administration tool would be used to tune an Oracle database? a. b. c. d. Please describe the changes made by you 12.  Which of the following are considered as types of segments? a. Only LOBS b. Only nested tables c. Only index-organized tables d. Only LOBS and index-organized tables e. Nested tables, LOBS, index-organized tables, and boot straps Please provide appropriate updations Ques Which of the following are considered as types of segments? 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 Oracle OCP Practice Test - Oracle OCP 10g Upgradation II  Name: Think you know more about Oracle OCP Practice Test - Oracle OCP 10g Upgradation II 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 10g Upgradation II Discussion Forum Know the Latest News about Oracle OCP Practice Test - Oracle OCP 10g Upgradation II! What others think about Oracle OCP Practice Test - Oracle OCP 10g Upgradation II By: mukul chaudhary on Jun 19, 2009    good one By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz By: Koti Reddy on Nov 27, 2008    Able to clear my ocp exams with the help of this mock quizz   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.