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 Test - Oracle OCP 10g Upgradation   Hottest Quizzes Free IQ Test  Free Oracle OCP Test - Oracle OCP 10g Upgradation Welcome to the QuizMoz Free Oracle OCP Test - Oracle OCP 10g Upgradation. 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 Test - Oracle OCP 10g Upgradation Facts  Average Score for this quiz: 18%  No of times this quiz has been taken: 28  No of people passing this quiz: 0  No of people failing this quiz: 28  Maximum score for this quiz: 42% Coverage : Flash Recovery Area Backups Managing Schedular Managing Database Application Tuning Analytical SQL Data Pump Architecture  Free Oracle OCP Test - Oracle OCP 10g Upgradation Discussion Forum 1.  Which of the following items are stored in the flash recovery area? a. Datafiles b. Undo segments c. Datafile copies d. Archived redo log files Please provide appropriate updations Ques Which of the following items are stored in the flash recovery area? a. b. c. d. Please describe the changes made by you 2.  What happens once the DBA disables the flash recovery area? a. The RMAN will still be able to access the files in the flash recovery area b. The RMAN will be unable to access the files in the flash recovery area c. The RMAN will be unable to access the automatic space management features of the flash recovery area d. The RMAN will be able to use only the automatic space management features of the flash recovery area Please provide appropriate updations Ques What happens once the DBA disables the flash recovery area? a. b. c. d. Please describe the changes made by you 3.  Which of the following commands are used to apply incremental backups? a. RECOVER BACKUP OF DATABASE b. RECOVER DATAFILE c. RECOVER COPY OF DATAFILE d. RECOVER COPY OF DATABASE Please provide appropriate updations Ques Which of the following commands are used to apply incremental backups? a. b. c. d. Please describe the changes made by you 4.  Which of the following is true about using the RESETLOGS option? a. It is not required to back up the database b. The database must be backed up right away c. Archive redo logs can be used from an older incarnation of the database d. Archive redo logs cannot be used from an older incarnation of the database Please provide appropriate updations Ques Which of the following is true about using the RESETLOGS option? a. b. c. d. Please describe the changes made by you 5.  Who will be the owner of the job, if a job is created in user SCOTT's schema? a. SYS b. SCOTT c. PUBLIC d. None of the above Please provide appropriate updations Ques Who will be the owner of the job, if a job is created in user SCOTT's schema? a. b. c. d. Please describe the changes made by you 6.  Which of the following is true when the sparse data is densified using partitioned outer joins? a. The missing data must be filled in by zeros b. The IGNORE NULLS clause can be used with the LAST_VALUE function to replace the missing values with the most recent non-NULL value in that column c. The missing data must be filled in by NULLs d. The missing data must be provided by updating the column with the missing values Please provide appropriate updations Ques Which of the following is true when the sparse data is densified using partitioned outer joins? a. b. c. d. Please describe the changes made by you 7.  In Oracle Database 10g, which of the following is true regarding the partition change tracking feature? a. It has been extended to rule partitioning b. It has been extended to hash partitioning c. It has been extended to Oracle partitions d. It has been extended to list partitioning Please provide appropriate updations Ques In Oracle Database 10g, which of the following is true regarding the partition change tracking feature? a. b. c. d. Please describe the changes made by you 8.  To grant a system privilege with the GRANT statement, the user must have been granted the: a. GRANT ROLE PRIVILEGE system privilege b. System privilege with the ADMIN OPTION c. GRANT ANY PRIVILEGE system privilege d. System privilege with the GRANT OPTION Please provide appropriate updations Ques To grant a system privilege with the GRANT statement, the user must have been granted the: a. b. c. d. Please describe the changes made by you 9.  What statistics will Oracle collect when using LIST subpartitioning and the value of the GRANULARITY argument is specified as AUTO? a. Global statistics only b. Global and partition statistics only c. Global, partition, and subpartition statistics d. No partitioned table statistics Please provide appropriate updations Ques What statistics will Oracle collect when using LIST subpartitioning and the value of the GRANULARITY argument is specified as AUTO? a. b. c. d. Please describe the changes made by you 10.  Which of the following is true when a monotonically increasing sequence number is an indexed column? a. Hash-partitioned global indexes are useful b. Hash-partitioned local indexes are better c. Range-partitioned local indexes are better d. Range-partitioned global indexes are better Please provide appropriate updations Ques Which of the following is true when a monotonically increasing sequence number is an indexed column? a. b. c. d. Please describe the changes made by you 11.  Which of the following would stop the execution of a query if the query failed to rewrite? a. select /*+ REWRITE_ON_ERROR*/... b. select /*+ REWRITE_OR_ERROR*/... c. select /*+ REWRITE_IN_ERROR*/... d. select /*+ REWRITE_ERROR*/... e. select /*+ REWRITE_If_ERROR*/... Please provide appropriate updations Ques Which of the following would stop the execution of a query if the query failed to rewrite? a. b. c. d. e. Please describe the changes made by you 12.  Which data dictionary view should be used, when finding out whether two databases are cross-transportable compliant or not? a. V$TRANSPORTABLE_PLATFORM b. V$ENDIAN FORMAT c. V$PLATFORM d. V$COMPATIBILITY_LEVEL Please provide appropriate updations Ques Which data dictionary view should be used, when finding out whether two databases are cross-transportable compliant or not? 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 Test - Oracle OCP 10g Upgradation  Name: Think you know more about Free Oracle OCP Test - Oracle OCP 10g Upgradation 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 Test - Oracle OCP 10g Upgradation Discussion Forum Know the Latest News about Free Oracle OCP Test - Oracle OCP 10g Upgradation! What others think about Free Oracle OCP Test - Oracle OCP 10g Upgradation By: Alice on 11/21/2009    Its a very good Quiz. It rocks my socks!!!!! By: Quiz Game Player on 11/20/2009    One day I will crack all the Impossible quizzes in the world By: Tom on 11/19/2009    I want more quiz questions By: general knowledge seeker on 11/18/2009    i love to take tests and quizzes. quizzes are my life. general knowledge questions are good for everyone By: Kath on 11/17/2009    It's a really good quiz. By: Lil Wayne Fan on 11/16/2009    Give me more quiz questions about LilWayne By: Roger on 11/15/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Reema on 11/14/2009    Great Quiz! The quizmaster laid out this quiz so that even beginners could learn more By: Kayla on 11/13/2009    I think this is a great quiz full of knowlodge and information. By: Aumkar on 11/12/2009    It was enjoyable. By: Shannon on 11/11/2009    I have never seen such an excellent quiz website before this. By: Personality Quiz Man on 11/10/2009    I love quizzes. Personality Quizzes are my favorite. By: Bobby Kalsi on 11/9/2009    Try to make it easier to search for a QUIZ Category.. (It should be easier to seach for a quiz category...) By: Erin on 11/8/2009    it was a fun and interseting quiz! By: Penny on 11/7/2009    NICE WEBSITE, great quiz! By: Tommy on 11/6/2009    Great site. Good learning and fun. By: Haris on 11/5/2009    These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength. By: Laura on 11/4/2009    I appreciate the time and effort that the quiz maker put into the quiz By: QuizMoz Fan on 11/3/2009    I love all the QuizMoz quizzes. The general knowledge quiz is my favorite By: Roger on 11/2/2009    I love Quiz Games. QuizMoz is an excellent Quiz site   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.