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 Practice Test - Oracle OCP Fundamental Questions   Hottest Quizzes Free IQ Test  Free Oracle OCP Practice Test - Oracle OCP Fundamental Questions Welcome to the QuizMoz Free Oracle OCP Practice Test - Oracle OCP Fundamental Questions. 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 Practice Test - Oracle OCP Fundamental Questions Facts  Average Score for this quiz: 37%  No of times this quiz has been taken: 32  No of people passing this quiz: 4  No of people failing this quiz: 28  Maximum score for this quiz: 83% 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  Free Oracle OCP Practice Test - Oracle OCP Fundamental Questions Discussion Forum 1.  If the following command is issued: rman> CONFIGURE CONTROLFILE AUTOBACKUP ON; Which statement is true? a. The autobackup of the control file will occur even if a backup set that included a control file backup just occurred b. The control file autobackup will occur only after a BACKUP command is issued 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 If the following command is 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 2.  A loss of data files was experienced in a database. The control files however, were not lost. RMAN was being used to restore and recover the database. Currently, the instance is shut down. Which sequence of commands is correct to restore and recover the database? a. RMAN> STARTUP NOMOUNT; RMAN> RESTORE DATABASE; RMAN> RECOVER DATABASE; RMAN> ALTER DATABASE OPEN; b. RMAN> STARTUP MOUNT; RMAN> RESTORE DATABASE; RMAN> RECOVER DATABASE; RMAN> ALTER DATABASE OPEN c. RMAN> STARTUP NOMOUNT; RMAN> RESTORE DATABASE; RMAN> RECOVER DATABASE; RMAN> ALTER DATABASE OPEN RESETLOGS; d. RMAN> STARTUP MOUNT; RMAN> RESTORE DATABASE; RMAN> RECOVER DATABASE; RMAN> ALTER DATABASE OPEN RESETLOGS; Please provide appropriate updations Ques A loss of data files was experienced in a database. The control files however, were not lost. RMAN was being used to restore and recover the database. Currently, the instance is shut down. Which sequence of commands is correct to restore and recover the database? a. b. c. d. Please describe the changes made by you 3.  Which phrase best describes RMAN multiplexed backup sets? a. Stripes a single backup set across multiple channels b. Identical copies of backup pieces within a backup set c. Multiple backup sets with multiple channels configured d. Simultaneous reads from multiple files and writes into the same backup piece Please provide appropriate updations Ques Which phrase best describes RMAN multiplexed backup sets? a. b. c. d. Please describe the changes made by you 4.  Consider the following RMAN script: RUN{ SET NEWNAME FOR DATAFILE '/disk1/database/db1.dbf' TO '/disk2/database/db1.dbf'; SWITCH DATAFILE ALL; RESTORE DATABASE; RECOVER DATABASE; ALTER DATABASE OPEN; } When executed, what result will occur? a. RMAN will restore the data file to disk1 b. The control file will be updated with the data file's new location, and the recovery will be successful c. All database data files will be moved to the new location and recovered d. The control file will NOT be updated with the data file's new location because the RENAME DATAFILE command is missing Please provide appropriate updations Ques Consider the following RMAN script:<br><br>RUN{<br>SET NEWNAME FOR DATAFILE '/disk1/database/db1.dbf' TO '/disk2/database/db1.dbf';<br>SWITCH DATAFILE ALL;<br>RESTORE DATABASE;<br>RECOVER DATABASE;<br>ALTER DATABASE OPEN;<br>}<br><br>When executed, what result will occur? a. b. c. d. Please describe the changes made by you 5.  Which statement concerning the Export/Import Utilities is true? a. The direct-path feature allows a user to extract database objects faster than the conventional-path b. The Export Utility can be used to make a logical backup of a table, a tablespace, or a table's associated data files c. The FULL database export mode exports all database objects regardless of the schema d. Performing an export/import of a tablespace is quicker than using the transportable tablespace method to transfer a table and its data Please provide appropriate updations Ques Which statement concerning the Export/Import Utilities is true? a. b. c. d. Please describe the changes made by you 6.  When allowing RMAN to backup archived redo log files, how does RMAN know which archived redo logs to back up from the archive log destination? a. RMAN keeps a list of archived logs in a text file b. The DBA must manually tell RMAN which archive logs to backup c. RMAN has access to target control file and/or catalog information d. RMAN looks at the ARCHIVE_LOG_DEST parameter of the target database and backs up all archive logs found Please provide appropriate updations Ques When allowing RMAN to backup archived redo log files, how does RMAN know which archived redo logs to back up from the archive log destination? a. b. c. d. Please describe the changes made by you 7.  An RMAN recover catalog is to be created which stores information about the  STUD database. The database should be named RCSTUD for the storage of the recovery catalog. The steps that should be followed to create a recover catalog are not displayed in the correct order. What is the correct order? 1. Grant the appropriate privileges (CONNECT and RESOURCE) and roles (RECOVERY CATALOG OWNER) to the user responsible for performing backup and recover operations. 2. Register the target database in the catalog. 3. Create the catalog using the RMAN command line interpreter. 4. Create a user and schema which will own the recovery catalog. 5. Create tablespace to hold the catalog in the database that has been dedicated for the RMAN recovery catalog. 6. Connect to the target database using SYSDBA privileges. a. 5, 4, 1, 3, 6, 2 b. 4, 1, 5, 6, 3, 2 c. 4, 3, 1, 5, 6, 2 d. 4, 5, 1, 3, 2, 6 5, 4, 1, 3, 2, 6 Please provide appropriate updations Ques An RMAN recover catalog is to be created which stores information about theSTUD database. The database should be named RCSTUD for the storage of the recovery catalog. The steps that should be followed to create a recover catalog are not displayed in the correct order. What is the correct order? <br><br>1. Grant the appropriate privileges (CONNECT and RESOURCE) and roles (RECOVERY CATALOG OWNER) to the user responsible for performing backup and recover operations. <br>2. Register the target database in the catalog. <br>3. Create the catalog using the RMAN command line interpreter. <br>4. Create a user and schema which will own the recovery catalog. <br>5. Create tablespace to hold the catalog in the database that has been dedicated for the RMAN recovery catalog. <br>6. Connect to the target database using SYSDBA privileges. <br> a. b. c. d. Please describe the changes made by you 8.  A tablespace was created for the recovery catalog. A user and a schema were created for the recovery catalog. Next, the appropriate privileges and roles were granted to the user that was created to enable them to maintain the recovery catalog. At the RMAN prompt, the catalog was created. What should be done next? a. Set the target database to a consistent incarnation. b. Synchronize the control file of the target database with the recovery catalog c. Register the target database in the newly created catalog d. Reset the target database to an incarnation that is synchronized with the recovery catalog Please provide appropriate updations Ques A tablespace was created for the recovery catalog. A user and a schema were created for the recovery catalog. Next, the appropriate privileges and roles were granted to the user that was created to enable them to maintain the recovery catalog. At the RMAN prompt, the catalog was created. What should be done next? a. b. c. d. Please describe the changes made by you 9.  As the DBA, JOHN is using RMAN to implement some of his company's backup policies. Every three days he creates three backups of every data file. After three days, backups are obsolete and should not be retained. Which mutually exclusive RMAN commands could be used to implement this retention policy? a. BACKUP COPIES 3 DATAFILE 3 DAYS; b. CONFIGURE RETENTION POLICY TO REDUNDANCY 3; c. BACKUP DATABASE KEEP UNTIL TIME 3 DAYS; d. CONFIGURE DATAFILE BACKUP COPIES FOR 3 DAYS; e. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS; Please provide appropriate updations Ques As the DBA, JOHN is using RMAN to implement some of his company's backup policies. Every three days he creates three backups of every data file. After three days, backups are obsolete and should not be retained. Which mutually exclusive RMAN commands could be used to implement this retention policy? a. b. c. d. e. Please describe the changes made by you 10.  Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database? a. SYSDBA b. SYSOPER c. No system privileges are required for the RMAN user d. Only SYS user can connect and execute RMAN commands on a target database Please provide appropriate updations Ques Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database? a. b. c. d. Please describe the changes made by you 11.  MARY wants to create an image copy backup that can be used in an incremental backup set. She wants to allocate the C1 channel and create image copies of two data files. She does NOT want the Oracle Server session to perform logical block corruption detection. These image copies will be used in an incremental backup set. Which RUN block set of commands should she use? a. rman> RUN 2> CHECK LOGICAL 3> ALLOCATE CHANNEL c1 TYPE DISK; 4> DATAFILE 1 TO '/backup/f1.dbf', 5> DATAFILE 2 TO '/backup/f2.dbf'; b. rman> RUN 2> ALLOCATE CHANNEL c1 TYPE DISK; 3> COPY LEVEL 0 4> DATAFILE 1 TO '/backup/f1.dbf', 5> DATAFILE 2 TO '/backup/f2.dbf'; c. rman> RUN 2> ALLOCATE CHANNEL c1 TYPE DISK; 3> DATAFILE 1 TO '/backup/f1.dbf', 4> DATAFILE 2 TO '/backup/f2.dbf'; d. rman> RUN 2> ALLOCATE CHANNEL c1 TYPE sbt_tape; 3> DATAFILE 1 TO '/backup/f1.dbf', 4> DATAFILE 2 TO '/backup/f2.dbf'; Please provide appropriate updations Ques MARY wants to create an image copy backup that can be used in an incremental backup set. She wants to allocate the C1 channel and create image copies of two data files. She does NOT want the Oracle Server session to perform logical block corruption detection. These image copies will be used in an incremental backup set. Which RUN block set of commands should she use? a. b. c. d. Please describe the changes made by you 12.  When importing a table into a database, the import process performs these tasks: 1. Triggers are imported. 2. Data is imported. 3. New tables are created. 4. Indexes are built. 5. Any bitmap, functional, and/or domain indexes are built. 6. Integrity constraints are enabled on the new tables. Which option shows the tasks in the order in which they are performed? a. 3, 2, 4, 1, 6, 5 b. 2, 3, 4, 1, 6, 5 c. 3, 2, 6, 4, 1, 5 d. 4, 2, 3, 1, 5, 6 Please provide appropriate updations Ques When importing a table into a database, the import process performs these tasks:<br><br>1. Triggers are imported. <br>2. Data is imported. <br>3. New tables are created. <br>4. Indexes are built. <br>5. Any bitmap, functional, and/or domain indexes are built. <br>6. Integrity constraints are enabled on the new tables. <br><br>Which option shows the tasks in the order in which they are performed? 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 Practice Test - Oracle OCP Fundamental Questions  Name: Think you know more about Free Oracle OCP Practice Test - Oracle OCP Fundamental Questions 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 Practice Test - Oracle OCP Fundamental Questions Discussion Forum Know the Latest News about Free Oracle OCP Practice Test - Oracle OCP Fundamental Questions! What others think about Free Oracle OCP Practice Test - Oracle OCP Fundamental Questions By: Karl on Aug 29, 2009    great tool By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great quiz By: ASanders on Jun 27, 2009    Great 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.