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 Online Oracle OCP Practice Test - Oracle OCP 10g Upgradation   Hottest Quizzes Free IQ Test  Free Online Oracle OCP Practice Test - Oracle OCP 10g Upgradation Welcome to the QuizMoz Free Online 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 Online Oracle OCP Practice Test - Oracle OCP 10g Upgradation Facts  Average Score for this quiz: 23.5%  No of times this quiz has been taken: 82  No of people passing this quiz: 14  No of people failing this quiz: 68  Maximum score for this quiz: 92% Coverage : Backup and Recovery Enhancements Querying Database Space and Storage Management Flashback Technology Enhancements Automatic Storage Management Tablespace Virtual Private Database ADDM  Free Online Oracle OCP Practice Test - Oracle OCP 10g Upgradation Discussion Forum 1.  Which data dictionary view should be used to get a list of object privileges for all database users? a. DBA_TAB_PRIVS b. ALL_TAB_PRIVS c. USER_TAB_PRIVS d. ALL_TAB_PRIVS_MADE Please provide appropriate updations Ques Which data dictionary view should be used to get a list of object privileges for all database users? a. b. c. d. Please describe the changes made by you 2.  Which data dictionary view(s) do are needed to query to find the following information about a user? - Whether the user's account has expired - The user's default tablespace name - The user's profile name a. DBA_USERS only b. DBA_USERS and DBA_PROFILES c. DBA_USERS and DBA_TABLESPACES d. DBA_USERS, DBA_TS_QUOTAS, and DBA_PROFILES Please provide appropriate updations Ques Which data dictionary view(s) do are needed to query to find the following information about a user?<br>- Whether the user's account has expired<br>- The user's default tablespace name<br>- The user's profile name<br> a. b. c. d. Please describe the changes made by you 3.  Which of the following is true about alerts? a. A maximum of one undo alert is received per every 12-hour period. b. A maximum of one undo alert is received during a 24-hour period. c. A maximum of one tablespace alert is received during a 124-hour period. d. A maximum of one tablespace alert is received during a 24-hour period. Please provide appropriate updations Ques Which of the following is true about alerts? a. b. c. d. Please describe the changes made by you 4.  The DBA issues the following command: SQL< alter table ORDER SHRINK SPACE What be the result of this statement? a. There would be only a compacting of the data, not a release of data b. There would be no impact on DML operations in the database c. There would be immediate release of the free space d. There would be an impact on the DML operations in the database Please provide appropriate updations Ques The DBA issues the following command:<br>SQL< alter table ORDER SHRINK SPACE<br>What be the result of this statement? a. b. c. d. Please describe the changes made by you 5.  What does the initialization parameter FAST_START_MTTR_TARGET determine? a. The instance recovery time b. The undo retention period c. The database restore time d. The number of redo log groups Please provide appropriate updations Ques What does the initialization parameter FAST_START_MTTR_TARGET determine? a. b. c. d. Please describe the changes made by you 6.  To avoid a large number of extents for big file tablespaces in very large databases, what does Oracle recommend? a. Use the AUTOALLOCATE clause for allocating new extents and set a very high extent size b. Use the UNIFORM clause and simply let Oracle take care of the extent sizing c. Use the UNIFORM clause for allocating new extents and set a very high extent size d. Use the AUTOALLOCATE clause and simply let Oracle take care of the extent sizing Please provide appropriate updations Ques To avoid a large number of extents for big file tablespaces in very large databases, what does Oracle recommend? a. b. c. d. Please describe the changes made by you 7.  What is the equivalent of the old DROP TABLE command in Oracle Database 10g? a. DROP TABLE NO PURGE b. DROP TABLE works exactly the way it did in previous versions. c. DROP TABLE … PURGE d. DROP TABLE … TO BEFORE DROP Please provide appropriate updations Ques What is the equivalent of the old DROP TABLE command in Oracle Database 10g? a. b. c. d. Please describe the changes made by you 8.  Which type of commands are used to copy ASM files? a. RMAN commands b. OMF commands c. Operating system commands d. Logical Volume Manager commands Please provide appropriate updations Ques Which type of commands are used to copy ASM files? a. b. c. d. Please describe the changes made by you 9.  What do ASM disk groups provide? a. Redundancy through striping b. Performance through mirroring. c. Redundancy through mirroring d. Performance through striping Please provide appropriate updations Ques What do ASM disk groups provide? a. b. c. d. Please describe the changes made by you 10.  For which types of tablespaces can proactive tablespace alerts be set? a. Locally managed b. Dictionary-managed c. Read-only d. Online Please provide appropriate updations Ques For which types of tablespaces can proactive tablespace alerts be set? a. b. c. d. Please describe the changes made by you 11.  Which of the following conditions must be met, if tablespace is to be made read only? a. The tablespace must contain an active rollback segments b. The tablespace must be online c. The tablespace must not contain any active rollback segments d. The tablespace must not be involved in an open backup e. The tablespace must be involved in an open backup Please provide appropriate updations Ques Which of the following conditions must be met, if tablespace is to be made read only? a. b. c. d. e. Please describe the changes made by you 12.  What are the three ways in which an addm report can be obtained? a. Use the DBA_ADVISOR.GET_TASK_REPORT procedure b. Use the DBMS_ADVISOR.REPORT_TASK PROCEDURE c. Use the DBMS_ADVISOR.GET_TASK_REPORT Procedure d. Use the addmrpt.sql script e. Use the awrrpt.sql script f. Use the OEM Database Control Please provide appropriate updations Ques What are the three ways in which an addm report can be obtained? 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 Online Oracle OCP Practice Test - Oracle OCP 10g Upgradation  Name: Think you know more about Free Online 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 Online Oracle OCP Practice Test - Oracle OCP 10g Upgradation Discussion Forum Know the Latest News about Free Online Oracle OCP Practice Test - Oracle OCP 10g Upgradation! What others think about Free Online Oracle OCP Practice Test - Oracle OCP 10g Upgradation By: raghu on Oct 6, 2009    this has been really helpful By: santosh on Sep 13, 2009    dvgdgdgd By: Shankar on Sep 8, 2009    oracle test By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice By: aL. on Aug 12, 2009    great practice   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.