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 Test Questions   Hottest Quizzes Free IQ Test  Oracle OCP Practice Test - Oracle OCP Fundamental Test Questions Welcome to the QuizMoz Oracle OCP Practice Test - Oracle OCP Fundamental Test 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!!  Oracle OCP Practice Test - Oracle OCP Fundamental Test Questions Facts  Average Score for this quiz: 24%  No of times this quiz has been taken: 11  No of people passing this quiz: 2  No of people failing this quiz: 9  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  Oracle OCP Practice Test - Oracle OCP Fundamental Test Questions Discussion Forum 1.  Examine the following statement: CREATE TABLESPACE rman_1 DATAFILE SIZE 20M DEFAULT STORAGE (INITIAL 100K NEXT 100K PCTINCREASE 0); What is the next step in the process of creating a recovery catalog? a. Create the recovery catalog b. Register the target database c. Create a recovery catalog user d. Connect to the target database Please provide appropriate updations Ques Examine the following statement:<br><br>CREATE TABLESPACE rman_1 DATAFILE<br>SIZE 20M DEFAULT STORAGE<br>(INITIAL 100K NEXT 100K PCTINCREASE 0);<br><br>What is the next step in the process of creating a recovery catalog? a. b. c. d. Please describe the changes made by you 2.  An ALTER DATABASE statement was used on the database to perform an online control file backup. In which mode is the database operating? a. FAILOVER b. FASTBACK c. ARCHIVELOG d. NOARCHIVELOG Please provide appropriate updations Ques An ALTER DATABASE statement was used on the database to perform an online control file backup. In which mode is the database operating? a. b. c. d. Please describe the changes made by you 3.  For which tasks would it be best NOT to use the utility SQL*Loader?   a. When loading selected rows into each table b. When loading data from an export dump file c. When loading data from disk, tape, or named pipes d. When the data is NOT being inserted from a flat file e. When using a record management system to access data files Please provide appropriate updations Ques For which tasks would it be best NOT to use the utility SQL*Loader? a. b. c. d. e. Please describe the changes made by you 4.  The MASTER table was accidentally truncated at 10:00 a.m. To perform an incomplete recovery, the database was mounted and multiple channels were allocated to enable parallelization. All of the data files were restored. Which additional steps are required? a. Back up the entire database b. Open the database with the RESETLOGS option c. Recover the database by using the UNTIL TIME method d. Synchronize the control file by issuing the SWITCH command e. Recover all data files by issuing the RECOVER TABLESPACE command Please provide appropriate updations Ques The MASTER table was accidentally truncated at 10:00 a.m. To perform an incomplete recovery, the database was mounted and multiple channels were allocated to enable parallelization. All of the data files were restored. Which additional steps are required? a. b. c. d. e. Please describe the changes made by you 5.  The EMPLOYEES table is stored in the USER1 tablespace. The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in the INDX1 tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the USER1 tablespace. Which objects will be exported by this command? exp system/manager tablespaces=USER1 a. Only the EMPLOYEES table and its corresponding primary key index b. The EMPLOYEES table and partition P1 c. Only the EMPLOYEES table d. The EMPLOYEES table, IPK_EMP index, and the SALES table Please provide appropriate updations Ques The EMPLOYEES table is stored in the USER1 tablespace. The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in the INDX1 tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the USER1 tablespace. Which objects will be exported by this command? <br><br>exp system/manager tablespaces=USER1<br> a. b. c. d. Please describe the changes made by you 6.  The USERS01.DBF data file should not be available while some routine maintenance is performed. Which RMAN command should be used? a. CHANGE DATAFILEBACKUP '/User/backup/users.dbf UNCATALOG; b. CHANGE DATAFILECOPY '/User/backup/users01.dbf UNCATALOG; c. CHANGE DATAFILECOPY '/User/backup/users01.dbf UNAVAILABLE; d. CHANGE DATAFILEBACKUP '/User/backup/users01.dbf UNAVAILABLE; Please provide appropriate updations Ques The USERS01.DBF data file should not be available while some routine maintenance is performed. Which RMAN command should be used? a. b. c. d. Please describe the changes made by you 7.  When using RMAN, which SGA memory structure is used for backup and restore operations? a. Large Pool b. Shared Pool c. Redo Log Buffer d. Database Buffer Cache Please provide appropriate updations Ques When using RMAN, which SGA memory structure is used for backup and restore operations? a. b. c. d. Please describe the changes made by you 8.  The following BACKUP command was issued to create a data file backup set: BACKUP FORMAT '/BACKUP/df_%d_%s_%p.buK' DATABASE filesperset = 3; The command executes successfully. Which statement is true? a. A channel was automatically allocated b. The control file was NOT backed up c. Each data file was copied three times d. The online redo log files were backed up Please provide appropriate updations Ques The following BACKUP command was issued to create a data file backup set:<br><br>BACKUP<br>FORMAT '/BACKUP/df_%d_%s_%p.buK'<br>DATABASE filesperset = 3;<br><br>The command executes successfully. Which statement is true? a. b. c. d. Please describe the changes made by you 9.  Which statement is true regarding RMAN components? a. Each target database requires its own recovery catalog b. RMAN scripts can be stored in the recovery catalog or the target control file c. A channel is a stream of data to a device type and corresponds to one server session d. The RMAN executable interprets sever session commands and establishes connections to the target database Please provide appropriate updations Ques Which statement is true regarding RMAN components? a. b. c. d. Please describe the changes made by you 10.  Examine the following RMAN script: RMAN> RUN{ 2> ALLOCATE CHANNEL d1 TYPE DISK; 3> ALLOCATE CHANNEL d2 TYPE DISK; 4> COPY #2 files copied in parallel 5> DATAFILE 1 TO '/backup/file1.dbf', 6> DATAFILE 2 TO '/backup/file2.dbf';} Which statement about this RMAN RUN block is true? a. Two data files will be copied simultaneously b. This block fails because only one data file at a time can be backed up using the COPY command c. Two channels are created, but only one will be used d. This block fails because the 'CONFIGURE DEVICE TYPE DISK PARALLELISM 2' command is NOT used Please provide appropriate updations Ques Examine the following RMAN script:<br><br>RMAN> RUN{<br>2> ALLOCATE CHANNEL d1 TYPE DISK;<br>3> ALLOCATE CHANNEL d2 TYPE DISK;<br>4> COPY #2 files copied in parallel<br>5> DATAFILE 1 TO '/backup/file1.dbf',<br>6> DATAFILE 2 TO '/backup/file2.dbf';}<br><br>Which statement about this RMAN RUN block is true? a. b. c. d. Please describe the changes made by you 11.  Which script provides the correct sequence of commands for recovery, when performing an incomplete recovery and are restoring archived redo log files? a. rman> RUN{ 2>  SET UNTIL SEQUENCE; 3>  ALTER DATABASE MOUNT; 4>  RESTORE DATABASE; 5>  RECOVER DATABASE; 6>  SQL "ALTER DATABASE OPEN RESETLOGS"; 7>  } b. rman> RUN{   2>  ALTER DATABASE MOUNT; 3>  RESTORE DATABASE; 4>  RECOVER DATABASE UNTIL SEQUENCE 89 THREAD 1; 5>  SQL "ALTER DATABASE OPEN RESETLOGS"; 6>  } c. rman> RUN { 2>  ALTER DATABASE NOMOUNT; 3>  RECOVER DATABASE; 4>  RESTORE DATABASE UNTIL SEQUENCE 89 THREAD 1; 5>  SQL "ALTER DATABASE OPEN RESETLOGS"; 6>  } d. rman> RUN{ 2>  SET UNTIL SEQUENCE 89 THREAD 1; 3>  ALTER DATABASE MOUNT; 4>  RESTORE DATABASE; 5>  RECOVER DATABASE; 6>  SQL "ALTER DATABASE OPEN RESETLOGS"; 7>  } Please provide appropriate updations Ques Which script provides the correct sequence of commands for recovery, when performing an incomplete recovery and are restoring archived redo log files? a. 7>}" /> 7>}" /> b. 6>}" /> 6>}" /> c. 6>}" /> 6>}" /> d. 7>} " /> 7>} " /> Please describe the changes made by you 12.  JOHN wants to create a copy of the SALES table. When that is complete, he wants to truncate the new SALES table, then restore the data with a direct load insert from the old SALES table. Which CREATE statement should he use? a. CREATE TABLE sales2 AS SELECT * FROM sales; TRUNCATE TABLE sales2; INSERT /*+ APPEND */ INTO sales2 NOLOGGING SELECT * FROM sales; COMMIT; b. CREATE TABLE sales2 AS SELECT * FROM sales; TRUNCATE TABLE sales2; INSERT INTO sales2 SELECT * FROM sales; COMMIT; c. CREATE TABLE sales2; SELECT * FROM sales; TRUNCATE TABLE sales2; INSERT /*+ APPEND */ INTO sales2 NOLOGGING SELECT * FROM sales; COMMIT; d. CREATE TABLE sales2 AS SELECT * FROM sales; TRUNCATE TABLE sales2; INSERT /*+ APPEND */ INTO sales2 NOLOGGING; SELECT * FROM sales; COMMIT; Please provide appropriate updations Ques JOHN wants to create a copy of the SALES table. When that is complete, he wants to truncate the new SALES table, then restore the data with a direct load insert from the old SALES table. Which CREATE statement should he use? 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 Oracle OCP Practice Test - Oracle OCP Fundamental Test Questions  Name: Think you know more about Oracle OCP Practice Test - Oracle OCP Fundamental Test 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) Oracle OCP Practice Test - Oracle OCP Fundamental Test Questions Discussion Forum Know the Latest News about Oracle OCP Practice Test - Oracle OCP Fundamental Test Questions! What others think about Oracle OCP Practice Test - Oracle OCP Fundamental Test Questions By: Personality Quiz Man on 11/21/2009    I love quizzes. Personality Quizzes are my favorite. By: Aumkar on 11/20/2009    It was enjoyable. By: Laura on 11/19/2009    I appreciate the time and effort that the quiz maker put into the quiz By: Tom on 11/18/2009    I want more quiz questions By: Teresa on 11/17/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: Hot girl on 11/16/2009    I love answering Quiz Questions By: Hannah on 11/15/2009    Enjoyed it, and learned a lot about general knowledge By: Nancy on 11/14/2009    I would like to see a complete page of horror movie quizzes for the horror genre fans! By: Sridhar on 11/13/2009    Its a really good way to brush up things and informative also. By: general knowledge seeker on 11/12/2009    i love to take tests and quizzes. quizzes are my life. general knowledge questions are good for everyone By: Shannon on 11/11/2009    I have never seen such an excellent quiz website before this. By: Roger on 11/10/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Roger on 11/9/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Bobby Kalsi on 11/8/2009    Try to make it easier to search for a QUIZ Category.. (It should be easier to seach for a quiz category...) By: Kath on 11/7/2009    It's a really good quiz. By: QuizMoz Fan on 11/6/2009    I love all the QuizMoz quizzes. The general knowledge quiz is my favorite By: Tracy on 11/5/2009    Great test. A nice way to gauge one's knowledge By: Tommy on 11/4/2009    Great site. Good learning and fun. By: Teena on 11/3/2009    I love this quiz Website. This is the best free quiz site. By: Quiz Game Player on 11/2/2009    One day I will crack all the Impossible quizzes in the world   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.