Home      Tests New!      Polls      Take a Quiz     Make a Quiz     Login     Contact QuizMoz Go to Home Page  
   
  Find a quiz.
  Example: Harry Potter Quiz


Create a Test
Make a Trivia Quiz
Make a Quiz about Yourself
Make Free Personality Test
Create a Survey


Now you can Read Books Online Free at ReadCentral.com









 

Featured Quizzes
 Love Compatibility Test
 English Language Test
 Does He Love You Quiz
 Business Phone Etiquette Quiz
 Impossible Quiz
 Personality Quiz
 CAT Preparation Mock Test
 Harry Potter Quizzes
 Keira Knightley Quiz
 Rage Against The Machines Quiz
 FIFA World Cup
 Are you in Love Quiz
 Skeletal System Quiz
 Love Personality Quiz
 Harry Potter Personality Quizzes



 



      Home > Quizzes and Fun Tests > Oracle OCP Practice Tests > Oracle OCP Practice Test - Oracle OCP 10g Upgradation II

 Follow QuizMoz on Twitter  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!!

Coverage
:
  • Database Tuning
  • Redo logs
  • Instance Configuration
  • Oracle Architecture
  • Indexes
  • Data Migration
  • Automatic Database Management
  • Oracle Server
  • 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

     
    2. What is the default value for the OPTIMIZER_MODE initialization parameter?
    a.FIRST_ROWS
    b.ALL_ROWS
    c.CHOOSE
    d.COST

     
    3. For which two constraints are indexes created when the constraint is added?
    a.Check
    b.Unique
    c.Not null
    d.Primary key

     
    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

     
    5. For how long does Oracle, by default, retain the undo information?
    a.31 days
    b.15 minutes
    c.30 minutes
    d.7 days

     
    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

     
    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

     
    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

     
    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

     
    10. Which of the following physical structures constitute the Oracle database?
    a.Segment
    b.Data file
    c.Log file
    d.Tablespace
    e.Control file

     
    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

     
    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

     
    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)


    Know the Latest News about Oracle OCP Practice Test - Oracle OCP 10g Upgradation II!

    Follow QuizMoz on Twitter


    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
      

    Quizzes for this month are sponsored by www.ExpertRating.com


     

    Most Popular Quizzes
     Be A MakeUp Artist Course
     Big Brother
     FIFA
     Soccer WAGs Quizzes
     NBA 2010 Quiz
     Science Quiz for Kids
     Medical Terminology Quiz
     Career Quiz for Kids
     Home And Away Quiz
     Harry Potter Quiz
     Harry Potter and the Deathly Hallows
     US History 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.