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 your own Poll
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 III

 Follow QuizMoz on Twitter  Oracle OCP Practice Test - Oracle OCP 10g Upgradation III

Welcome to the QuizMoz Oracle OCP Practice Test - Oracle OCP 10g Upgradation III. 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
:
  • Backup and Recovery Enhancements
  • Querying Database
  • Space and Storage Management
  • Flashback Technology Enhancements
  • Automatic Storage Management
  • Tablespace
  • Virtual Private Database
  • ADDM
  • 1. Which command tells the database to slow down if it is within its allotted time for a database backup?
    a.MAXIMIZE LOAD
    b.MINIMIZE TIME
    c.MINIMIZE PARTIAL
    d.MINIMIZE LOAD

    2. What happens when you uncatalogue all the metadata about backup pieces from the RMAN catalog?
    a.The RMAN replaces the backup sets with image copies
    b.The RMAN removes the backup set information from the catalog as well
    c.All the backup pieces from the catalog cannot be removed
    d.The RMAN automatically removes the catalog

    3. Which view provides the names of all the data dictionary views?
    a.DBA_NAMES
    b.DBA_TABLES
    c.DICTIONARY
    d.DBA_DICTIONARY

    4. Which dynamic performance views obtain information from the control file?
    a.V$LOG
    b.V$SGA
    c.V$THREAD
    d.V$VERSION
    e.V$DATAFILE

    5. Which data dictionary view shows the available free space in a certain tablespace?
    a.DBA_EXTENTS
    b.V$FREESPACE
    c.DBA_FREE_SPACE
    d.DBA_TABLESPACFS

    6. Which of the following statements are true?
    a.The flashback transaction query relies on the FLASHBACK_TRANSACTION_QUERY view
    b.The flashback transaction query cannot be used together with the flashback versions query feature
    c.The flashback transaction query can be used together with the flashback versions query feature
    d.The flashback transaction query relies on the FLASHBACK_TRANSACTION_QUERY
    procedure

    7. How is a disk added to an existing disk group?
    a.Alter diskgroup dgroup1
      add failgroup controller1
      '/dev/rdsk/d0s2' NAME a5;
    b.Alter diskgroup
      add failgroup controller1
      '/dev/rdsk/d0s2' NAME a4;
    c.Alter diskgroup dgroup1
      add failgroup controller1
      '/dev/rdsk/d0s2' ;
    d.Alter diskgroup dgroup1
      add failgroup
      '/dev/rdsk/d0s2' NAME a1;

    8. What is the command to create tablespace using an ASM disk group?
    a.create tablespace sample_tbsp
      datafile '+dgroup1' size 500M
    b.create tablespace sample_tbsp
      datafile size 500M
    c.create tablespace sample_tbsp
      datafile '+dgroup1'
    d.create tablespace sample_tbsp
      datafile '+dgroup1' size 500M
      using asm

    9. When the current database is migrated to ASM-based storage, what should be done with the redo log files?
    a.Rename them to ASM disk groups
    b.Copy them from their present locations to the ASM disk directly
    c.Reinitialize the current online redo logs
    d.Oracle will automatically copy them after migrating to an ASM-based database

    10. Which data dictionary view shows the available free space in a certain tablespace?
    a.DBA_EXTENTS
    b.V$FREESPACE
    c.DBA_FREE_SPACE
    d.DBA_TABLESPACFS

    11. Which tablespace is used as the temporary tablespace, if 'TEMPORARY TABLESPACE' is not specified for a user?
    a.TEMP
    b.DATA
    c.SYSTEM
    d.ROLLBACK

    12. Which of the following is true if the alter tablespace statement is used and the TEMPORARY clause is specified?
    a.Oracle no longer performs any checkpoint for the online datafiles in the tablespace
    b.Oracle performs a checkpoint for all online datafiles in the tablespace
    c.Oracle does not ensure that all files are written
    d.The offline files may require media recovery before the tablespace is brought online

    13. A database currently has two temporary groups GROUP1 and
    GROUP2. A new temporary tablespace is created with the following command:
    create temporary tablespace temp tempfile 'tmpo1.dbf' size 300m tablespace group';
    which group does the new temporary tablespace belong to?
    a.GROUP1 and GROUP2
    b.GROUP1 only
    c.GROUP2 only
    d.GROUP1 or GROUP2, depending on which temporary tablespace group was created first
    e.Neither group

    14. To which of the following does a column-level VPD policy apply?
    a.Materialized views
    b.Tables
    c.Synonyms
    d.Views
    e.Indexes

    15. Which of the following statements are true regarding column-level VPD?
    a.Column-masking behavior will restrict the number of rows returned
    b.Default behavior will restrict the number of rows returned
    c.Column-masking behavior will return all rows
    d.Default behavior will return all columns

    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 III
     Name:
    Think you know more about Oracle OCP Practice Test - Oracle OCP 10g Upgradation III 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 III!

    Follow QuizMoz on Twitter


    What others think about Oracle OCP Practice Test - Oracle OCP 10g Upgradation III
    By: Koti Reddy on Nov 27, 2008
      able to clear ocp exams
    By: ravindrakumar pal on Nov 17, 2008
      i am very happy abt test
      

    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.