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 Fundamental II   Hottest Quizzes Free IQ Test  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!!  Oracle OCP Practice Test - Oracle OCP Fundamental II Facts  Average Score for this quiz: 22%  No of times this quiz has been taken: 60  No of people passing this quiz: 9  No of people failing this quiz: 51  Maximum score for this quiz: 76% 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  Oracle OCP Practice Test - Oracle OCP Fundamental II Discussion Forum 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 Please provide appropriate updations Ques The following INSERT statement was issued:<br><br>INSERT /* +APPEND */ INTO arch.curr_order_hist<br>SELECT * FROM ord.curr_order;<br><br>Which type of INSERT is performed? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques 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. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques Which Recovery Manager REPORT command option should be used to display the names, locations, and sizes of database files? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques For which of the following scenarios could an incomplete recovery operation be performed? a. b. c. d. e. f. Please describe the changes made by you 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; Please provide appropriate updations Ques 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.<br> Which set of commands should be used to recover the database? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques Which roles or privileges are required to export tables owned by another user? a. b. c. d. e. Please describe the changes made by you 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. Please provide appropriate updations Ques Consider this RMAN statement:<br><br>COPY <br>CURRENT CONTROLFILE TO 'd/arch/control.copy<br>DATAFILE 1 TO 'd/arch/dataf1.copy<br>DATAFILE 2 TO 'd/arch/dataf2.copy<br>DATAFILE 3 TO 'd/arch/dataf3.copy;<br><br>JOHN is connected to the recovery catalog and the target control file is mounted. What is the result of executing this COPY statement? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques If an archived log is lost or corrupt when performing media recovery, which type of recover must be performed? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques When planning a recovery catalog backup strategy, which options are viable? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques 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. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques 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. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques Which statement concerning Recovery Manager stored scripts is true? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques The following command was issued:<br><br>rman> CONFIGURE CONTROLFILE AUTOBACKUP ON;<br> <br>Which statement is true? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques Which utilitycan be used to create logical backups which can then be used to create an historical archive, save table definitions, and reorganize tables? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques In which situations does the command file actually perform synchronization when the RESYNC CATALOG command is issued In RMAN? a. b. c. d. e. Please describe the changes made by you 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 Please provide appropriate updations Ques 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. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques The import process consists of the following steps: <br><br>1.New tables are created.<br>2.Data is imported.<br>3.Indexes and triggers are imported.<br>4.Any bitmap, functional, or domain indexes are built. <br><br>Which step is missing? a. b. c. d. Please describe the changes made by you 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; Please provide appropriate updations Ques Which command takes precedence at the session level? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques Archived redo log files in a system range from sequence number 830 through 852. The following command was issued from the RMAN prompt:<br><br>BACKUP ARCHIVELOG FROM SEQUENCE 839;<br><br>Which statement is true? a. b. c. d. e. Please describe the changes made by you 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 Please provide appropriate updations Ques Which statement about an image copy is true? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques Which of the following statements concerning the import process are true? 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 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) Oracle OCP Practice Test - Oracle OCP Fundamental II Discussion Forum Know the Latest News about Oracle OCP Practice Test - Oracle OCP Fundamental II! What others think about Oracle OCP Practice Test - Oracle OCP Fundamental II By: Teresa on 11/21/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: Laura on 11/20/2009    I appreciate the time and effort that the quiz maker put into the quiz By: Tommy on 11/19/2009    Great site. Good learning and fun. By: Lil Wayne Fan on 11/18/2009    Give me more quiz questions about LilWayne By: Penny on 11/17/2009    NICE WEBSITE, great quiz! By: Bobby Kalsi on 11/16/2009    Try to make it easier to search for a QUIZ Category.. (It should be easier to seach for a quiz category...) By: Tom on 11/15/2009    I want more quiz questions By: Erin on 11/14/2009    it was a fun and interseting quiz! By: Kath on 11/13/2009    It's a really good quiz. By: Hannah on 11/12/2009    Enjoyed it, and learned a lot about general knowledge By: quiz girl on 11/11/2009    hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge By: Roger on 11/10/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: general knowledge seeker on 11/9/2009    i love to take tests and quizzes. quizzes are my life. general knowledge questions are good for everyone By: Dave on 11/8/2009    I really enjoyed this quiz. I will take a lot of information away with me. Great quiz By: Samantha on 11/7/2009    This is so cool. Even though I really did not know some of the questions, it was still fun! By: Tallitha on 11/6/2009    This quiz is amazing By: Tracy on 11/5/2009    Great test. A nice way to gauge one's knowledge By: Roger on 11/4/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Quiz Game Player on 11/3/2009    One day I will crack all the Impossible quizzes in the world By: Alice on 11/2/2009    Its a very good Quiz. It rocks my socks!!!!!   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.