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 10g Upgradation   Hottest Quizzes Free IQ Test  Free Oracle OCP- Practice Test - Oracle OCP 10g Upgradation Welcome to the QuizMoz Free Oracle OCP- Practice 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- Practice Test - Oracle OCP 10g Upgradation Facts  Average Score for this quiz: 8%  No of times this quiz has been taken: 11  No of people passing this quiz: 0  No of people failing this quiz: 11  Maximum score for this quiz: 33% Coverage : Backup and Recovery Enhancements Querying Database Space and Storage Management Flashback Technology Enhancements Automatic Storage Management Tablespace Virtual Private Database ADDM  Free Oracle OCP- Practice Test - Oracle OCP 10g Upgradation Discussion Forum 1.  What is the DBA's best choice if it needs to recover the production database in the shortest time possible? a. Use the RECOVER DATABASE command b. Use the SWITCH BACKUP command c. Use the RESTORE DATABASE command d. Use the SWITCH DATABASE command Please provide appropriate updations Ques What is the DBA's best choice if it needs to recover the production database in the shortest time possible? a. b. c. d. Please describe the changes made by you 2.  What are the features of compressed backups? a. A Compressed backup sets cannot be used with database prior to Oracle database 10g b. The COMPATIBLE initialization parameter must be set to 10.0.0 c. Only image copies can be compressed d. Only backup sets can be compressed e. By default, compression is enabled f. By default, compression is disabled Please provide appropriate updations Ques What are the features of compressed backups? a. b. c. d. e. f. Please describe the changes made by you 3.  What happens on using an ORDER BY clause on a suffix of the sort key columns? a. No sorting is required if an ORDER BY clause is used b. Additional sorting is required when using an ORDER BY clause c. An ORDER BY clause cannot be used on a suffix of the sort key column d. The same amount of sorting is required as when there is no suffix on the sort key columns Please provide appropriate updations Ques What happens on using an ORDER BY clause on a suffix of the sort key columns? a. b. c. d. Please describe the changes made by you 4.  What are the functions of an ASM instance? a. Managing disk groups and communicating file metadata to the Oracle database using ASM files b. Managing database files and communicating file metadata to the ASM instance using ASM files c. Managing disk groups and communicating file metadata to the RMAN d. Protecting disk groups Please provide appropriate updations Ques What are the functions of an ASM instance? a. b. c. d. Please describe the changes made by you 5.  What does the ARBn background process do in an ASM instance? a. Coordinates disk activity b. Performs disk rebalance work c. Coordinates disk rebalance work d. Manages the RBAL process Please provide appropriate updations Ques What does the ARBn background process do in an ASM instance? a. b. c. d. Please describe the changes made by you 6.  What is the only initialization parameter that absolutely must be set to create an ASM instance? a. ASM_POWER_LIMIT b. DB_UNIQUE_NAME c. INSTANCE_TYPE d. ASM_DISKSTRING Please provide appropriate updations Ques What is the only initialization parameter that absolutely must be set to create an ASM instance? a. b. c. d. Please describe the changes made by you 7.  Which set of tablespaces is mandatory for any Oracle 10g database? a. SYSTEM, SYSAUX, and UNDOTBS b. SYSTEM and UNDOTBS c. SYSAUX and UNDOTBS d. SYSTEM and SYSAUX Please provide appropriate updations Ques Which set of tablespaces is mandatory for any Oracle 10g database? a. b. c. d. Please describe the changes made by you 8.  Examine the SQL statement: CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB? a. Extent b. Segment c. Oracle block d. Operating system block Please provide appropriate updations Ques Examine the SQL statement:<br><br>CREATE TABLESPACE user_data<br>DATAFILE '/u01/oradata/user_data_0l.dbf' SIZE 100M<br>LOCALLY MANAGED UNIFORM SIZE 1M<br>AUTOMATIC SEGMENT SPACE MANAGEMENT;<br><br>Which part of the tablespace will be of a uniform size of 1 MB? a. b. c. d. Please describe the changes made by you 9.  Where is free space managed, for a tablespace created with automatic segment-space management? a. In the extent b. In the control file c. In the data dictionary d. In the undo tablespace Please provide appropriate updations Ques Where is free space managed, for a tablespace created with automatic segment-space management? a. b. c. d. Please describe the changes made by you 10.  Examine the SQL statement: CREATE TABLESPACE userdata DATAFILE '/oracle/oradata/userdata_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB? a. Extent b. Segment c. Oracle block d. Operating system block Please provide appropriate updations Ques Examine the SQL statement:<br>CREATE TABLESPACE userdata<br>DATAFILE '/oracle/oradata/userdata_0l.dbf' SIZE 100M<br>LOCALLY MANAGED UNIFORM SIZE 1M<br>AUTOMATIC SEGMENT SPACE MANAGEMENT;<br><br>Which part of the tablespace will be of a uniform size of 1 MB?<br> a. b. c. d. Please describe the changes made by you 11.  A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent? a. BLOCKS b. PCT_FREE c. NEXT_EXTENT d. PCT_INCREASE Please provide appropriate updations Ques A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent? a. b. c. d. Please describe the changes made by you 12.  Which of the following statements are true when using the following command? drop tablespace user1; a. The objects in the user1 tablespace are not placed in the Recycle Bin b. The objects in the user1 tablespace are placed in the Recycle Bin c. The user1 tablespace must be empty d. The user1 tablespace must not be empty e. Any object from the user1 tablespace that is currently in Recycle Bin will be automatically purged f. Any object from the user1 tablespace that is currently in Recycle Bin will not  be automatically purged Please provide appropriate updations Ques Which of the following statements are true when using the following command?<br>drop tablespace user1; a. b. c. d. e. f. 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 10g Upgradation  Name: Think you know more about Free Oracle OCP- Practice 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- Practice Test - Oracle OCP 10g Upgradation Discussion Forum Know the Latest News about Free Oracle OCP- Practice Test - Oracle OCP 10g Upgradation! What others think about Free Oracle OCP- Practice Test - Oracle OCP 10g Upgradation By: Erin on 11/21/2009    it was a fun and interseting quiz! By: Lil Wayne Fan on 11/20/2009    Give me more quiz questions about LilWayne By: Bobby Kalsi on 11/19/2009    Try to make it easier to search for a QUIZ Category.. (It should be easier to seach for a quiz category...) By: QuizMoz Fan on 11/18/2009    I love all the QuizMoz quizzes. The general knowledge quiz is my favorite By: Kath on 11/17/2009    It's a really good quiz. By: Laura on 11/16/2009    I appreciate the time and effort that the quiz maker put into the quiz By: Tracy on 11/15/2009    Great test. A nice way to gauge one's knowledge By: Kayla on 11/14/2009    I think this is a great quiz full of knowlodge and information. By: Tom on 11/13/2009    I want more quiz questions By: Nancy on 11/12/2009    I would like to see a complete page of horror movie quizzes for the horror genre fans! By: Alice on 11/11/2009    Its a very good Quiz. It rocks my socks!!!!! By: Reema on 11/10/2009    Great Quiz! The quizmaster laid out this quiz so that even beginners could learn more By: Teena on 11/9/2009    I love this quiz Website. This is the best free quiz site. By: Personality Quiz Man on 11/8/2009    I love quizzes. Personality Quizzes are my favorite. By: Penny on 11/7/2009    NICE WEBSITE, great quiz! By: Hot girl on 11/6/2009    I love answering Quiz Questions By: Quiz Game Player on 11/5/2009    One day I will crack all the Impossible quizzes in the world By: quiz girl on 11/4/2009    hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge By: Roger on 11/3/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Free quiz seeker on 11/2/2009    I am searching for an impossible 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.