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 > Certification Oracle OCP Practice Test - Oracle OCP Performance Tuning II   Hottest Quizzes Free IQ Test  Certification Oracle OCP Practice Test - Oracle OCP Performance Tuning II Welcome to the QuizMoz Certification Oracle OCP Practice Test - Oracle OCP Performance Tuning II. 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!!  Certification Oracle OCP Practice Test - Oracle OCP Performance Tuning II Facts  Average Score for this quiz: 30.5%  No of times this quiz has been taken: 138  No of people passing this quiz: 16  No of people failing this quiz: 122  Maximum score for this quiz: 83% Coverage : Using Oracle Blocks Efficiently Monitoring and Detecting Lock Contention Diagnosing Contention for Latches Application Tuning SQL Statement Tuning Tuning the Oracle Shared Server Tuning the Operating System and Using Resource Manager Tuning Undo Segments  Certification Oracle OCP Practice Test - Oracle OCP Performance Tuning II Discussion Forum 1.  What is the purpose of the INCLUDING clause in the CREATE TABLE syntax for an Index Organized Table? a. It specifies at which column to break a row into two pieces when a row's length exceeds the size set aside in PCTTHRESHOLD b. It specifies the name of the primary key column in the index organized table c. It specifies what percentage of the entire data block to hold open in order to store the row data associated with a primary key value d. It specifies the tablespace where the second half of the row data will be stored when the row's length exceeds the size set aside in PCTTHRESHOLD Please provide appropriate updations Ques What is the purpose of the INCLUDING clause in the CREATE TABLE syntax for an Index Organized Table? a. b. c. d. Please describe the changes made by you 2.  How many database resource plans can be active at the same time at the database instance level? a. One b. All c. None d. Up to 2 e. Up to 4 Please provide appropriate updations Ques How many database resource plans can be active at the same time at the database instance level? a. b. c. d. e. Please describe the changes made by you 3.  The USERS table has thousands of rows and is accessed very often with an index (ISERID_NDX) on a primary key (USER_ID). Where should USERS and USERID_NDX be stored? a. Different tablespace on different disks b. Same tablespace c. SYSTEM tablespace d. Same tablespace on different disks Please provide appropriate updations Ques The USERS table has thousands of rows and is accessed very often with an index (ISERID_NDX) on a primary key (USER_ID). Where should USERS and USERID_NDX be stored? a. b. c. d. Please describe the changes made by you 4.  The EMPLOYEE_MASTER table was created with the NOLOGGING attribute and has the following columns: FIRST_NAME VARCHAR2(60); EMPLOYEE_ID NUMBER; Which of the following SQL statements can use NOLOGGING mode? a. DELETE FROM EMPLOYEE_MASTER; b. INSERT INTO EMPLOYEE_MASTER VALUES ('JOHN', 2000); c. CREATE TABLE EMPLOYEE AS SELECT * FROM EMPLOYEE_MASTER; d. CREATE INDEX EMPLOYEE_MASTER_PK ON EMPLOYEE_MASTER (EMPLOYEE_ID); e. UPDATE EMPLOYEE_MASTER SET FIRST_NAME = 'JOE' WHERE EMPLOYEE_ID = 1200; Please provide appropriate updations Ques The EMPLOYEE_MASTER table was created with the NOLOGGING attribute and has the following columns:<br><br>FIRST_NAME VARCHAR2(60);<br>EMPLOYEE_ID NUMBER;<br><br>Which of the following SQL statements can use NOLOGGING mode? a. b. c. d. e. Please describe the changes made by you 5.  The alert log file for a database instance indicated that the checkpoints are frequently failing to complete. Which action would be a remedy in this situation? a. Increase the number of archiver (ARCn) processes b. Increasing the number of members for all log groups c. Increasing the number of log writer (LGWR) processes d. Increasing the number of database writer (DBWn) processes Please provide appropriate updations Ques The alert log file for a database instance indicated that the checkpoints are frequently failing to complete. Which action would be a remedy in this situation? a. b. c. d. Please describe the changes made by you 6.  The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result? a. The sort-merge join b. The nested loops join c. This depends on some sort parameter values d. This depends on the number of rows in each table Please provide appropriate updations Ques The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result? a. b. c. d. Please describe the changes made by you 7.  JOHN has been taking snapshots once a week over the last two years. He will use these snapshots to outline the cost associated with the increase in database resources over the past two years. Which tool or utility would allow him to compare the snapshots? a. LOCK MANAGER b. STATSPACK c. ORACLE EXPERT d. UTLBSTAT /UTLESTAT Please provide appropriate updations Ques JOHN has been taking snapshots once a week over the last two years. He will use these snapshots to outline the cost associated with the increase in database resources over the past two years. Which tool or utility would allow him to compare the snapshots? a. b. c. d. Please describe the changes made by you 8.  Which of the following results happen when a deadlock situation is detected by Oracle? a. All database sessions hang indefinitely because of the deadlock b. An error is reported in the alert log c. All sessions involved in the deadlock are terminated d. All transactions currently in progress are terminated e. A trace file is generated Please provide appropriate updations Ques Which of the following results happen when a deadlock situation is detected by Oracle? a. b. c. d. e. Please describe the changes made by you 9.  What step can be taken to avoid row migration in the database? a. Recreate the database with smaller DB_BLOCK_SIZE b. Increase the PCTFREE setting on the tables with row migration problems c. Increase the MAXEXTENTS setting on the tables with row migration problems d. Increase the NEXT setting for the tables with row migration problems so that the size of the next extent allocated is bigger Please provide appropriate updations Ques What step can be taken to avoid row migration in the database? a. b. c. d. Please describe the changes made by you 10.  In prior version of Oracle, when updating a child table (EMP) the parent table (DEPT) implicitly received a Share Row Exclusive lock due to referential integrity. What must be done when using Oracle9i? a. The query_rewrite must be turned on for the instance b. The foreign key column must be indexed in the emp table c. A unique index must be placed on the foreign key column in the emp table d. Nothing is needed to be done, the implementation of the foreign key constraint is modified Please provide appropriate updations Ques In prior version of Oracle, when updating a child table (EMP) the parent table (DEPT) implicitly received a Share Row Exclusive lock due to referential integrity. What must be done when using Oracle9i? a. b. c. d. Please describe the changes made by you 11.  The redo log buffer is being tuned for an Oracle9i database. Which of the following situations can affect the performance? a. DB_BLOCK_CHECKSUM is set to true b. RMAN slave processes are too slow c. Your junior DBA is creating large indexes in LOGGING mode d. Checkpoints are occurring every 2 minutes Please provide appropriate updations Ques The redo log buffer is being tuned for an Oracle9i database. Which of the following situations can affect the performance? a. b. c. d. Please describe the changes made by you 12.  An OLTP database was being operated in manual undo management mode and it was noticed that the query SELECT COUNT(*) from V$TRANSACTION is always less than or equal to 160 during peak transaction hours. How many rollback segments should be configured? a. 640 b. 40 c. 160 d. 180 Please provide appropriate updations Ques An OLTP database was being operated in manual undo management mode and it was noticed that the query SELECT COUNT(*) from V$TRANSACTION is always less than or equal to 160 during peak transaction hours. How many rollback segments should be configured? 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 Certification Oracle OCP Practice Test - Oracle OCP Performance Tuning II  Name: Think you know more about Certification Oracle OCP Practice Test - Oracle OCP Performance Tuning II 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) Certification Oracle OCP Practice Test - Oracle OCP Performance Tuning II Discussion Forum Know the Latest News about Certification Oracle OCP Practice Test - Oracle OCP Performance Tuning II! What others think about Certification Oracle OCP Practice Test - Oracle OCP Performance Tuning II By: nida on Aug 13, 2009    this is very helpful site By: Ali Raza on May 18, 2009    Thank you for providing this facility. By: sri on Apr 25, 2009    this is very helpful in guiding By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great site. By: Robert on Apr 9, 2009    Great quiz, great 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.