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 Fundamental II

 Follow QuizMoz on Twitter  Oracle OCP Practice Test - Oracle OCP Fundamental II

Welcome to the QuizMoz Oracle OCP Practice Test - Oracle OCP Fundamental 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
:
  • Configuring the Database in Archiving Mode
  • Loading Data into Database
  • RMAN Maintenace
  • User Managed Incomplete Recovery
  • User Managed Complete Recovery
  • Recovery Catalog Creation And Maintenance
  • RMAN Maintenance
  • Transporting Data Between Databases
  • RMAN Complete Recovery
  • RMAN Incomplete Recovery
  • RMAN Backup
  • Loading Data Into Database
  • 1. The following INSERT statement was issued:

    INSERT /* +APPEND */ INTO arch.curr_order_hist
    SELECT * FROM ord.curr_order;

    Which type of INSERT is performed?
    a.Conventional
    b.Direct-Load
    c.Parallel Direct-Load
    d.Serial-Conventional
     
    2. Backups that have reached the end of their assigned retention policy were removed from the Recovery Manager repository. Which option of the Recovery Manager DELETE command was used to perform this task?
    a.OBSOLETE
    b.EXPIRED
    c.UNAVAILABLE
    d.UNRECOVERABLE
     
    3. Which Recovery Manager REPORT command option should be used to display the names, locations, and sizes of database files?
    a.TARGET
    b.DATA
    c.SCHEMA
    d.CATALOG
     
    4. For which of the following scenarios could an incomplete recovery operation be performed?
    a.A table is dropped in error
    b.Multiple data files are missing or corrupt
    c.A control file and all its mirrors are lost
    d.An archived redo log is corrupt, and complete recovery is impossible
    e.An non-archived, non-mirrored online redo log and a data file are missing
    f.A mirrored control file is lost
     
    5. An ARCHIVELOG mode database has experienced a media failure and most of the data files are unusable and the control file is corrupt. A Recovery Manager is being used to perform all backup and recovery processes. Channels have already been configured.
    Which set of commands should be used to recover the database?
    a.rman> STARTUP NOMOUNT
    rman> RESTORE CONTROLFILE;
    rman> RESTORE DATABASE;
    rman> RECOVER DATABASE;
    rman> ALTER DATABASE OPEN RESETLOGS;
    b.rman> ALTER DATABASE MOUNT;
    rman> RESTORE CONTROLFILE;
    rman> RESTORE DATABASE;
    rman> RECOVER DATABASE;
    rman> ALTER DATABASE OPEN;
    c.rman> STARTUP NOMOUNT;
    rman> RESTORE CONTROLFILE;
    rman> ALTER DATABASE MOUNT;
    rman> RESTORE DATABASE;
    rman> RECOVER DATABASE;
    rman> ALTER DATABASE OPEN RESETLOGS;
    d.rman> ALTER DATABASE MOUNT;
    rman> RESTORE CONTROLFILE;
    rman> RESTORE DATABASE;
    rman> RECOVER DATABASE;
    rman> ALTER DATABASE OPEN RESETLOGS;
     
    6. Which roles or privileges are required to export tables owned by another user?
    a.CREATE USER
    b.CREATE SESSION
    c.CREATE ANY TABLE
    d.IMP_FULL_DATABASE
    e.EXP_FULL_DATABASE
     
    7. Consider this RMAN statement:

    COPY
    CURRENT CONTROLFILE TO 'd/arch/control.copy
    DATAFILE 1 TO 'd/arch/dataf1.copy
    DATAFILE 2 TO 'd/arch/dataf2.copy
    DATAFILE 3 TO 'd/arch/dataf3.copy;

    JOHN is connected to the recovery catalog and the target control file is mounted. What is the result of executing this COPY statement?
    a.Only the control file is updated with the control file and data file copy information
    b.Only the recovery catalog is updated with the control file and data file copy information
    c.The target control file is updated with the control file and data file copy information. The recovery catalog is then updated with the changed information from the control file
    d.The target control file and the recovery catalog are simultaneously updated with the control file and data file copy information.
     
    8. If an archived log is lost or corrupt when performing media recovery, which type of recover must be performed?
    a.Until SCN
    b.Until time
    c.Until cancel
    d.Recover using backup control file
     
    9. When planning a recovery catalog backup strategy, which options are viable?
    a.A whole database backup or a tablespace backup only
    b.A whole database backup only
    c.A tablespace backup only
    d.A whole database backup, a tablespace backup, and an export
     
    10. Which RMAN command should be used to display all of the backup sets that are currently available for use in a restore or recover operation?
    a.SPOOL
    b.LIST
    c.REPORT
    d.REQUEST
     
    11. The command line is being used to initiate a data export. The process completely bypasses the evaluating buffer, allowing the export to be quick. Which Export Utility parameter or parameters are being used?
    a.BUFFER=n Only
    b.DIRECT=y Only
    c.DIRECT=y only
    d.BUFFER=y and COMPRESS=n
     
    12. Which statement concerning Recovery Manager stored scripts is true?
    a.A RUN command can be executed from within a stored script
    b.When creating a script, it is NOT required for RMAN to be connected to the recovery catalog
    c.Any command that can be used within a RUN command can be used in a stored script
    d.The CREATE SCRIPT command can be issued at either the RMAN or SQL*Plus prompts
     
    13. The following command was issued:

    rman> CONFIGURE CONTROLFILE AUTOBACKUP ON;

    Which statement is true?
    a.The control file autobackup will occur only after a BACKUP command is issued
    b.The autobackup of the control file will occur even if a backup set that included a control file backup just occurred
    c.The autobackup of the control file will NOT occur if an identical control file backup currently exists on the device to be written to
    d.The 'CONFIGURE CONTROLFILE AUTOBACKUP ON;' command has NO effect because the control file autobackup feature is enabled by default
     
    14. Which utility  can be used to create logical backups which can then be used to create an historical archive, save table definitions, and reorganize tables?
    a.The RMAN Utility
    b.Media Manager
    c.The Export/Import Utilities
    d.SQL*Loader
     
    15. In which situations does the command file actually perform synchronization when the RESYNC CATALOG command is issued In RMAN?  
    a.After the COPY command
    b.After adding a data file in the target database
    c.After adding a tablespace in the target database
    d.After adding a tablespace in the catalog database
    e.After running SQL Loader to load a large amount of data
     
    16. TOM is planning to export the entire Human Resources database. During the export, he wants to include all of the data into one extent and create a read-consistent view of the database when data is being updated. Which command-line export string will he use?
    a.Exp hr/hr FULL=y DIRECT=y CONSISTENT=y COMPRESS=y
    b.Exp hr/hr FULL=y CONSISTENT=n COMPRESS=y
    c.Exp hr/hr FULL=y DIRECT=y CONSISTENT=n COMPRESS=y
    d.Exp hr/hr FULL=y DIRECT=y CONSISTENT=y INCTYPE=y COMPRESS=n
     
    17. The import process consists of the following steps:

    1.  New tables are created.
    2.  Data is imported.
    3.  Indexes and triggers are imported.
    4.  Any bitmap, functional, or domain indexes are built.

    Which step is missing?
    a.Redo history is applied
    b.User privileges are assigned
    c.New tables are set online
    d.Integrity constraints are enabled
     
    18. Which command takes precedence at the session level?
    a.rman> CONFIGURE CONTROLFILE AUTOBACKUP ON;
    b.sql> SET CONTROLFILE AUTOBACKUP = ON;
    c.sql> ALTER SESSION CONFIGURE CONTROLFILE AUTOBACKUP ON;
    d.rman> SET CONFIGURE CONTROLFILE AUTOBACKUP ON;
     
    19. Archived redo log files in a system range from sequence number 830 through 852. The following command was issued from the RMAN prompt:

    BACKUP ARCHIVELOG FROM SEQUENCE 839;

    Which statement is true?
    a.The BACKUP command fails because archived redo logs can only be identified by thread number
    b.The BACKUP command fails because the UNTIL <sequence> option was NOT included
    c.The archived redo logs, beginning with sequence number 839, are copied to a previously defined destination
    d.Only the archived redo log, identified by sequence number 839, is copied to a previously defined destination
    e.None of the above
     
    20. Which statement about an image copy is true?
    a.An image copy can be written to disk or tape
    b.An image copy CANNOT be part of an incremental backup
    c.An image copy CANNOT be part of an incremental backup
    d.An image copy can be of a data file, control file, or archived redo log file
     
    21. Which of the following statements concerning the import process are true?
    a.Triggers and procedures are imported immediately after the indexes are built
    b.Table data is imported immediately before the integrity constraints are enabled
    c.Indexes are built immediately after the new table is created and the data is imported
    d.Integrity constraints are enabled immediately after the indexes are built and triggers are imported
    e.All bitmap, functional, or domain indexes are built immediately before the integrity constraints are enabled
     
    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 Fundamental II
     Name:
    Think you know more about Oracle OCP Practice Test - Oracle OCP Fundamental 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 Fundamental II!

    Follow QuizMoz on Twitter


    What others think about Oracle OCP Practice Test - Oracle OCP Fundamental II
    By: Penny on 6/24/2017
      NICE WEBSITE, great quiz!
    By: Alice on 6/23/2017
      Its a very good Quiz. It rocks my socks!!!!!
    By: Roger on 6/22/2017
      I love Quiz Games. QuizMoz is an excellent Quiz site
    By: Tracy on 6/21/2017
      Great test. A nice way to gauge one's knowledge
    By: quiz girl on 6/20/2017
      hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge
    By: Sridhar on 6/19/2017
      Its a really good way to brush up things and informative also.
    By: Aumkar on 6/18/2017
      It was enjoyable.
    By: Teena on 6/17/2017
      I love this quiz Website. This is the best free quiz site.
    By: Kayla on 6/16/2017
      I think this is a great quiz full of knowlodge and information.
    By: Erin on 6/15/2017
      it was a fun and interseting quiz!
    By: Dave on 6/14/2017
      I really enjoyed this quiz. I will take a lot of information away with me. Great quiz
    By: Tallitha on 6/13/2017
      This quiz is amazing
    By: Lil Wayne Fan on 6/12/2017
      Give me more quiz questions about LilWayne
    By: QuizMoz Fan on 6/11/2017
      I love all the QuizMoz quizzes. The general knowledge quiz is my favorite
    By: Shannon on 6/10/2017
      I have never seen such an excellent quiz website before this.
    By: Personality Quiz Man on 6/9/2017
      I love quizzes. Personality Quizzes are my favorite.
    By: Roger on 6/8/2017
      I love Quiz Games. QuizMoz is an excellent Quiz site
    By: Haris on 6/7/2017
      These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength.
    By: Laura on 6/6/2017
      I appreciate the time and effort that the quiz maker put into the quiz
    By: Quiz Game Player on 6/5/2017
      One day I will crack all the Impossible quizzes in the world
      

    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.