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 10g Upgradation III   Hottest Quizzes Free IQ Test  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!!  Oracle OCP Practice Test - Oracle OCP 10g Upgradation III Facts  Average Score for this quiz: 19.5%  No of times this quiz has been taken: 82  No of people passing this quiz: 5  No of people failing this quiz: 77  Maximum score for this quiz: 93% Coverage : Backup and Recovery Enhancements Querying Database Space and Storage Management Flashback Technology Enhancements Automatic Storage Management Tablespace Virtual Private Database ADDM  Oracle OCP Practice Test - Oracle OCP 10g Upgradation III Discussion Forum 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 Please provide appropriate updations Ques Which command tells the database to slow down if it is within its allotted time for a database backup? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques What happens when you uncatalogue all the metadata about backup pieces from the RMAN catalog? a. b. c. d. Please describe the changes made by you 3.  Which view provides the names of all the data dictionary views? a. DBA_NAMES b. DBA_TABLES c. DICTIONARY d. DBA_DICTIONARY Please provide appropriate updations Ques Which view provides the names of all the data dictionary views? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques Which dynamic performance views obtain information from the control file? a. b. c. d. e. Please describe the changes made by you 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 Please provide appropriate updations Ques Which data dictionary view shows the available free space in a certain tablespace? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques Which of the following statements are true? a. b. c. d. Please describe the changes made by you 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; Please provide appropriate updations Ques How is a disk added to an existing disk group? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques What is the command to create tablespace using an ASM disk group? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques When the current database is migrated to ASM-based storage, what should be done with the redo log files? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques Which data dictionary view shows the available free space in a certain tablespace? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques Which tablespace is used as the temporary tablespace, if 'TEMPORARY TABLESPACE' is not specified for a user? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques Which of the following is true if the alter tablespace statement is used and the TEMPORARY clause is specified? a. b. c. d. Please describe the changes made by you 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 Please provide appropriate updations Ques A database currently has two temporary groups GROUP1 and <br>GROUP2. A new temporary tablespace is created with the following command:<br>create temporary tablespace temp tempfile 'tmpo1.dbf' size 300m tablespace group';<br>which group does the new temporary tablespace belong to? a. b. c. d. e. Please describe the changes made by you 14.  To which of the following does a column-level VPD policy apply? a. Materialized views b. Tables c. Synonyms d. Views e. Indexes Please provide appropriate updations Ques To which of the following does a column-level VPD policy apply? a. b. c. d. e. Please describe the changes made by you 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 Please provide appropriate updations Ques Which of the following statements are true regarding column-level VPD? 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 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) Oracle OCP Practice Test - Oracle OCP 10g Upgradation III Discussion Forum Know the Latest News about Oracle OCP Practice Test - Oracle OCP 10g Upgradation III! 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 By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test By: ravindrakumar pal on Nov 17, 2008    i am very happy abt test   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.