| 1. | About which major tuning areas does Database Control provide information? |
| a. | | Most-used objects |
| b. | | Top SQL statements |
| c. | | Memory usage |
| d. | | Top sessions affecting the instance |
| e. | | CPU and wait classes
|
|
|
|
|
|
|
| 2. | The initialization parameter, UNDO_RETENTION specifies the length of time for which Oracle retains data in the: |
| a. | | Undo tablespace |
| b. | | Flash recovery area |
| c. | | Data files |
| d. | | Flashback database logs
|
|
|
|
|
|
|
| 3. | When is the SGA created in an Oracle database environment? |
| a. | | When the database is created |
| b. | | When the instance is started |
| c. | | When the database is mounted |
| d. | | When a user process is started
|
|
|
|
|
|
|
| 4. | What must be confirmed before changing the CURSOR_SPACE_FOR_TIME parameter in the initialization file to TRUE? |
| a. | | The TIMED_STATISTICS parameter is set to TRUE |
| b. | | The hit percentage in the buffer cache is at least 95% |
| c. | | The OPEN_CURSOR parameter is set to at least twice the default value |
| d. | | The value in the RELOADS column of V$LIBRARYCACHE is consistently zero
|
|
|
|
|
|
|
| 5. | User Smith created indexes on some tables owned by user John. The following items have to be displayed:
Index names
Index types
Which data dictionary view(s) would be needed to query? |
| a. | | DBA_INDEXES only |
| b. | | DBA_IND_COLUMNS only |
| c. | | DBA_INDEXES and DBA_USERS |
| d. | | DBA_IND COLUMNS and DBA_USERS
|
|
|
|
|
|
|
| 6. | Which statement is valid regarding index clusters? |
| a. | | Index clusters can only be used for tables with low cardinality columns |
| b. | | Index clusters are generally well suited for tables that have many full table scans |
| c. | | Normal B-Tree indexes do not store null key values, whereas cluster indexes store null keys |
| d. | | A cluster index always takes up much more storage space than a normal index for the same set of key values
|
|
|
|
|
|
|
| 7. | Which of the following statements are true about rebuilding an index? |
| a. | | The resulting index may contain deleted entries |
| b. | | A new index is built using an existing index as the data source |
| c. | | Queries cannot use the existing index while the new index is being built |
| d. | | During a rebuild, sufficient space is needed to accommodate both the old and the new index in their respective tablespaces
|
|
|
|
|
|
|
| 8. | The DBA wants to transport a tablespace from database X and Y, which is located on a different operating system using a different endian format for its datafiles. Therefore, the DBA needs to convert the endian format before transporting the tablespace. Which commands can the DBA use to change the endian formats? |
| a. | | Convert Tablespace...To Platform..in SQL*PLUS |
| b. | | Convert Tablespace...From Platform..in RMAN |
| c. | | Convert Tablespace...To Platform..in RMAN |
| d. | | Convert Datafile...From Platform..in RMAN |
| e. | | Convert Datafile...From Platform..in SQL*PLUS
|
|
|
|
|
|
|
| 9. | What is the key goal of the ADDM? |
| a. | | To reduce DB time |
| b. | | To reduce DB idle time |
| c. | | To reduce DB active time |
| d. | | To reduce throughput
|
|
|
|
|
|
|
| 10. | Which of the following are examples of an Oracle database high-water mark statistic? |
| a. | | SGA size |
| b. | | Number of named users |
| c. | | Size of the largest data segment |
| d. | | Maximum number of concurrent sessions
|
|
|
|
|
|
|
| 11. | Which memory structure contains the information used by the server process to validate the user privileges? |
| a. | | Buffer cache |
| b. | | Library cache |
| c. | | Data dictionary cache |
| d. | | Redo log buffer cache
|
|
|
|
|
|
|
| 12. | Which option lists the correct hierarchy of storage structures, from largest to the smallest? |
| a. | | Segment, extent, tablespace, data block |
| b. | | Data block, extent, segment, tablespace |
| c. | | Tablespace, extent, data block, segment |
| d. | | Tablespace, segment, extent, data block
|
|
|
|
|
|
|
What others think about Free Oracle Test OCP Practice Test - Oracle OCP 10g Upgradation |
| By: Tallitha on 11/21/2009 |
|
 |
| By: Laura on 11/20/2009 |
| | I appreciate the time and effort that the quiz maker put into the quiz |
|
|
| By: Teena on 11/19/2009 |
| | I love this quiz Website. This is the best free quiz site. |
|
|
| By: quiz girl on 11/18/2009 |
| | hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge
|
|
|
| By: Free quiz seeker on 11/17/2009 |
| | I am searching for an impossible quiz |
|
| By: Erin on 11/16/2009 |
| | it was a fun and interseting quiz! |
|
|
| By: Lil Wayne Fan on 11/15/2009 |
| | Give me more quiz questions about LilWayne |
|
|
| By: Teresa on 11/14/2009 |
| | I took the quiz. It let me know that I failed. But I wasn't able to see what the correct answers. It would be great to see what the answers are so I can learn. |
|
|
| By: Samantha on 11/13/2009 |
| | This is so cool. Even though I really did not know some of the questions, it was still fun! |
|
|
| By: Shannon on 11/12/2009 |
| | I have never seen such an excellent quiz website before this. |
|
|
| By: Tom on 11/11/2009 |
| | I want more quiz questions |
|
|
| By: Hot girl on 11/10/2009 |
| | I love answering Quiz Questions |
|
|
| By: Tommy on 11/9/2009 |
| | Great site. Good learning and fun. |
|
|
| By: Reema on 11/8/2009 |
| | Great Quiz! The quizmaster laid out this quiz so that even beginners could learn more |
|
|
| By: Kath on 11/7/2009 |
|
|
| By: Haris on 11/6/2009 |
| | These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength. |
|
|
| By: Dave on 11/5/2009 |
| | I really enjoyed this quiz. I will take a lot of information away with me. Great quiz |
|
|
| By: Roger on 11/4/2009 |
| | I love Quiz Games. QuizMoz is an excellent Quiz site |
|
|
| By: Nancy on 11/3/2009 |
| | I would like to see a complete page of horror movie quizzes for the horror genre fans! |
|
|
| By: Bobby Kalsi on 11/2/2009 |
| | Try to make it easier to search for a QUIZ Category.. (It should be easier to seach for a quiz category...) |
|
|
