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 Quiz   Hottest Quizzes Free IQ Test  Oracle OCP Practice Test - Oracle OCP 10g Upgradation Quiz Welcome to the QuizMoz Oracle OCP Practice Test - Oracle OCP 10g Upgradation Quiz. 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 Quiz Facts  Average Score for this quiz: 41%  No of times this quiz has been taken: 13  No of people passing this quiz: 5  No of people failing this quiz: 8  Maximum score for this quiz: 92% Coverage : Database Tuning Redo logs Instance Configuration Oracle Architecture Indexes Data Migration Automatic Database Management Oracle Server  Oracle OCP Practice Test - Oracle OCP 10g Upgradation Discussion Forum 1.  Which DBMS_LOGMNR feature facilitates the automatic adding of redo log files for mining? a. REMOVE_LOGFILE b. CONTINUOUS_MINE c. NO_ROWID_IN_STMT d. AUTOMATIC_LOGFILE Please provide appropriate updations Ques Which DBMS_LOGMNR feature facilitates the automatic adding of redo log files for mining? a. b. c. d. Please describe the changes made by you 2.  Which of the following initialization parameters would belong to the basic group of parameters? a. SHARED_POOL b. CURSOR_SPACE_FOR_TIME c. DB_NAME d. CURSOR_SHARING Please provide appropriate updations Ques Which of the following initialization parameters would belong to the basic group of parameters? a. b. c. d. Please describe the changes made by you 3.  Which of the following is a new initialization parameter for Oracle Database 10g? a. UNDO_SUPPRESS_ERRORS b. PARALLEL_AUTOMATIC_TUNING c. RESUMABLE_TIMEOUT d. SHARED_SERVER Please provide appropriate updations Ques Which of the following is a new initialization parameter for Oracle Database 10g? a. b. c. d. Please describe the changes made by you 4.  When is the creation of the new flash recovery area mandatory while using the DBCA to create a new database? a. Always b. Only when configuring automatic backup using the OEM c. Only when configuring user-managed backups d. Only when running the database in the archive log mode Please provide appropriate updations Ques When is the creation of the new flash recovery area mandatory while using the DBCA to create a new database? a. b. c. d. Please describe the changes made by you 5.  What happens when the value of the SGA_TARGET parameter is set higher than the value of the SGA_MAX_SIZE parameter at instance startup? a. The instance will not start b. SGA_TARGET will become equal to the SGA_MAX_SIZE value c. The database will ignore the SGA_TARGET parameter d. SGA_MAX_SIZE is automatically raised, so it equals the SGA_TARGET value Please provide appropriate updations Ques What happens when the value of the SGA_TARGET parameter is set higher than the value of the SGA_MAX_SIZE parameter at instance startup? a. b. c. d. Please describe the changes made by you 6.  Which statement is true about the LOG_BUFFER initialization parameter? a. The LOG_BUFFER parameter can be changed dynamically b. The minimum value for the LOG_FILE parameter is 512KB c. The LOG_BUFFER parameter value must be a multiple of the database block size d. The LOG_BUFFER parameter value must be a multiple of the operating system block size Please provide appropriate updations Ques Which statement is true about the LOG_BUFFER initialization parameter? a. b. c. d. Please describe the changes made by you 7.  Which of the following is true for a monotonically increasing sequence number as an indexed column? a. Hash-partitioned global indexes are useful b. Range-partitioned global indexes are better c. Hash-partitioned local indexes are better d. Range-partitioned local indexes are better Please provide appropriate updations Ques Which of the following is true for a monotonically increasing sequence number as an indexed column? a. b. c. d. Please describe the changes made by you 8.  Which type of index will be created on the PASSPORT_RECORDS table if it contains 10 million rows of data and the key columns have low cardinality. (The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator)? a. Bitmap b. Unique c. Partitioned d. Reverse key Please provide appropriate updations Ques Which type of index will be created on the PASSPORT_RECORDS table if it contains 10 million rows of data and the key columns have low cardinality. (The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator)? a. b. c. d. Please describe the changes made by you 9.  What are the main advantages of using bitmap indexes? a. Bitmap indexes use less storage space b. Bitmap indexes are easy to maintain when DML statements are issued c. Bitmap segments are updated upon COMMIT, at the end of the transaction d. Bitmap indexes work very fast with multiple predicates that are combined with AND, OR, and NOT operators Please provide appropriate updations Ques What are the main advantages of using bitmap indexes? a. b. c. d. Please describe the changes made by you 10.  What does the UPDATA INDEXES clause in the following statement helps to do in Oracle Database 10g? alter table parts move partitions part1 tablespace newtbs update indexes parts_idx (partition part1 tablespace mytbs); a. Allows to specify storage attributes of the corresponding local index segments b. Create an index for the new partition part1 c. Automatically rebuild the corresponding local index segments d. Move the index partition for the new partition part1 Please provide appropriate updations Ques What does the UPDATA INDEXES clause in the following statement helps to do in Oracle Database 10g?<br>alter table parts <br>move partitions part1 tablespace newtbs<br>update indexes parts_idx<br>(partition part1 tablespace mytbs);<br> a. b. c. d. Please describe the changes made by you 11.  Which background process performs a checkpoint in the database by writing modified blocks from the database buffer cache in the SGA to the data files? a. LGWR b. SMON c. DBWn d. CKPT Please provide appropriate updations Ques Which background process performs a checkpoint in the database by writing modified blocks from the database buffer cache in the SGA to the data files? a. b. c. d. Please describe the changes made by you 12.  For which two 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 your data is NOT being inserted from a flat file Please provide appropriate updations Ques For which two tasks would it be best NOT to use the utility SQL*Loader? 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  Name: Think you know more about 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) Oracle OCP Practice Test - Oracle OCP 10g Upgradation Discussion Forum Know the Latest News about Oracle OCP Practice Test - Oracle OCP 10g Upgradation! What others think about Oracle OCP Practice Test - Oracle OCP 10g Upgradation By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions By: PP on Jul 30, 2009    Very nice questions   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.