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 OCP Test Practice Questions - Oracle OCP 10g Upgradation   Hottest Quizzes Free IQ Test  Free Oracle OCP Test Practice Questions - Oracle OCP 10g Upgradation Welcome to the QuizMoz Free Oracle OCP Test Practice Questions - Oracle OCP 10g Upgradation. 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 OCP Test Practice Questions - Oracle OCP 10g Upgradation Facts  Average Score for this quiz: 22%  No of times this quiz has been taken: 11  No of people passing this quiz: 2  No of people failing this quiz: 9  Maximum score for this quiz: 67% Coverage : Flash Recovery Area Backups Managing Schedular Managing Database Application Tuning Analytical SQL Data Pump Architecture  Free Oracle OCP Test Practice Questions - Oracle OCP 10g Upgradation Discussion Forum 1.  What will the command EXECUTE DBMS_SCHEDULER.PURGE_LOG(); do? a. Purge only the window logs b. Purge only the job logs c. Purge all window and job logs d. Purge only yesterday's job logs Please provide appropriate updations Ques What will the command EXECUTE DBMS_SCHEDULER.PURGE_LOG(); do? a. b. c. d. Please describe the changes made by you 2.  Which rows will the DELETE clause in a MERGE statement delete? a. Rows neither updated nor inserted by the MERGE statement b. Rows selected by the WHERE clause embedded inside the INSERT clause c. Rows modified by the UPDATE clause d. Rows inserted by the INSERT clause Please provide appropriate updations Ques Which rows will the DELETE clause in a MERGE statement delete? a. b. c. d. Please describe the changes made by you 3.  What will the PARTITION BY clause in a partitioned outer join statement do? a. Partition the output rows into equal segments b. Partition the table into equal subpartitions c. Partition the rows in the output based on the expression provided within the clause d. Partition the underlying table, using Oracle's partitioning option Please provide appropriate updations Ques What will the PARTITION BY clause in a partitioned outer join statement do? a. b. c. d. Please describe the changes made by you 4.  Which command would revoke the ROLE_DATA role from all users? a. REVOKE role_data FROM ALL; b. REVOKE role_data FROM PUBLIC; c. REVOKE role_data FROM default; d. REVOKE role_data FROM ALL_USERS; Please provide appropriate updations Ques Which command would revoke the ROLE_DATA role from all users? a. b. c. d. Please describe the changes made by you 5.  Where is the trace file generated, when a deadlock shutdown is detected by Oracle? a. SQL_TRACE b. TRACE_DEST c. USER_DUMP_DEST d. CORE_DUMP_DEST Please provide appropriate updations Ques Where is the trace file generated, when a deadlock shutdown is detected by Oracle? a. b. c. d. Please describe the changes made by you 6.  Where can you find the non default parameters when the instance is started? a. Alert log b. Online redo log c. Archiver redo log d. SYSTEM user's trace file Please provide appropriate updations Ques Where can you find the non default parameters when the instance is started? a. b. c. d. Please describe the changes made by you 7.  Which initialization parameter specifies the location of the alert log file? a. UTL_FILE_DIR b. USER_DUMP_DEST c. LOG_ARCHIVE_DEST d. BACKGROUND_DUMP_DEST Please provide appropriate updations Ques Which initialization parameter specifies the location of the alert log file? a. b. c. d. Please describe the changes made by you 8.  The DBA is using the SQL Access Advisor to get recommendations for improving object access. Which of the following types of objects may the SQL Access Advisor recommend? a. Table b. Views c. Indexes d. Materialized views e. Tablespaces Please provide appropriate updations Ques The DBA is using the SQL Access Advisor to get recommendations for improving object access. Which of the following types of objects may the SQL Access Advisor recommend? a. b. c. d. e. Please describe the changes made by you 9.  When is a SQL profile used? a. In the tuning mode of the optimizer only b. In the normal mode of the optimizer c. In neither the tuning nor the normal mode of the optimizer d. Along with existing statistics, to get better SQL execution plans Please provide appropriate updations Ques When is a SQL profile used? a. b. c. d. Please describe the changes made by you 10.  Which of the following is true about the SQL Tuning Advisor? a. It automatically collects statistics if they are missing b. It only makes recommendations to collect statistics c. It ignores optimizer statistics completely d. It uses only the available statistics Please provide appropriate updations Ques Which of the following is true about the SQL Tuning Advisor? a. b. c. d. Please describe the changes made by you 11.  Which of the following parameters enables users to perform a data-only unloading of data? a. EXCLUDE b. INCLUDE c. CONTENT d. DATA_ONLY Please provide appropriate updations Ques Which of the following parameters enables users to perform a data-only unloading of data? a. b. c. d. Please describe the changes made by you 12.  What does unloading of data refer to? How can the ownership of all of a user's objects change during a data pump import? a. The reading of data from external datafiles into external tables REMAP_SCHEMA=source_schema:targer_schema b. The writing of data from Oracle tables to external datafiles REMAP_TABLESPACE=source_tablespace:target_tablespace c. The writing of data from external datafiles into external tables FROMUSER TOUSER d. The reading of data from Oracle tables into external datafiles REMAP_TABLESPACE=source_tablespace:source_tablespace Please provide appropriate updations Ques What does unloading of data refer to?<br>How can the ownership of all of a user's objects change during a data pump import? 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 Free Oracle OCP Test Practice Questions - Oracle OCP 10g Upgradation  Name: Think you know more about Free Oracle OCP Test Practice Questions - Oracle OCP 10g Upgradation 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 OCP Test Practice Questions - Oracle OCP 10g Upgradation Discussion Forum Know the Latest News about Free Oracle OCP Test Practice Questions - Oracle OCP 10g Upgradation! What others think about Free Oracle OCP Test Practice Questions - Oracle OCP 10g Upgradation By: Haris on 11/21/2009    These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength. By: Kayla on 11/20/2009    I think this is a great quiz full of knowlodge and information. By: Dave on 11/19/2009    I really enjoyed this quiz. I will take a lot of information away with me. Great quiz By: Laura on 11/18/2009    I appreciate the time and effort that the quiz maker put into the quiz By: Quiz Game Player on 11/17/2009    One day I will crack all the Impossible quizzes in the world By: Aumkar on 11/16/2009    It was enjoyable. By: Lil Wayne Fan on 11/15/2009    Give me more quiz questions about LilWayne By: QuizMoz Fan on 11/14/2009    I love all the QuizMoz quizzes. The general knowledge quiz is my favorite By: Free quiz seeker on 11/13/2009    I am searching for an impossible quiz By: quiz girl on 11/12/2009    hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge By: Tommy on 11/11/2009    Great site. Good learning and fun. By: Tom on 11/10/2009    I want more quiz questions By: Teresa on 11/9/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: Kath on 11/8/2009    It's a really good quiz. By: Alice on 11/7/2009    Its a very good Quiz. It rocks my socks!!!!! By: Penny on 11/6/2009    NICE WEBSITE, great quiz! By: Samantha on 11/5/2009    This is so cool. Even though I really did not know some of the questions, it was still fun! By: Hannah on 11/4/2009    Enjoyed it, and learned a lot about general knowledge By: Personality Quiz Man on 11/3/2009    I love quizzes. Personality Quizzes are my favorite. By: Erin on 11/2/2009    it was a fun and interseting quiz!   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.