| 1. | What are the main benefits of index-organized tables? |
| a. | | More concurrency |
| b. | | Faster full table scans |
| c. | | Fast primary key-based access |
| d. | | Less contention on the segment header |
| e. | | Less storage is required because there is no duplication of primary key values
|
|
|
|
|
|
|
| 2. | Which of the following statements are true regarding materialized views? |
| a. | | Materialized views cannot be partitioned, nor can they be defined on partitioned tables |
| b. | | Materialized views are often used in data warehouses to increase the speed of queries on very large datatables |
| c. | | Queries that benefit from the use of materialized views often involve joins between tables or aggregations such as SUM |
| d. | | A materialized view stores both the definition of a view and the rows resulting from the execution of the views |
| e. | | Materialized views can be used to replicate data, which was formerly achieved using the CREATE SNAPSHOT statement
|
|
|
|
|
|
|
| 3. | The database is set up to run Multithreaded Server. Which view would show contention for server processes? |
| a. | | V$CIRCUIT |
| b. | | V$SESSION |
| c. | | DBA_USERS |
| d. | | V$QUEUE
|
|
|
|
|
|
|
| 4. | Which guidelines for tablespace planning must be followed when planning a new Oracle9i database? |
| a. | | Use an UNDO tablespace |
| b. | | Separate applications data by tablespace |
| c. | | Place large tables in their own tablespace |
| d. | | Limit tablespaces to SYSTEM, TOOLS, UNDO, TEMPORARY, USERS and INDEXES |
| e. | | Place indexes on the same tablespace as the table for which they are created
|
|
|
|
|
|
|
| 5. | Which statistic is incremented if a willing-to-wait latch request is satisfied on the first attempt? |
| a. | | SLEEPS |
| b. | | GETS |
| c. | | MISSES |
| d. | | IMMEDIATE_GETS
|
|
|
|
|
|
|
| 6. | Which of the following statements are true regarding automatic undo segments? |
| a. | | Undo tablespaces must be created as DICTIONARY MANAGED |
| b. | | Undo tablespaces must be created as LOCALLY MANAGED |
| c. | | Any tablespace can be used for automatic undo segment management |
| d. | | An undo tablespace can only be dropped if it is NOT the active undo tablespace for the database, and all transactions using that undo tablespace have committed or rolled back
|
|
|
|
|
|
|
| 7. | What causes session waits in the log buffer? |
| a. | | The rollback tablespace extends |
| b. | | Data has not been committed to the database |
| c. | | Data is written into the log buffer faster than LGWR can write it out |
| d. | | A transaction has an exclusive lock on a row
|
|
|
|
|
|
|
| 8. | When the database was created, UNDO_MANAGEMENT was set to AUTO in the parameter file, a directory was specified for the parameter DB_CREATE_FILE_DEST. An UNDO TABLESPACE named UNDOTBS1 is being created without using a data file subclause. Which statement will hold true? |
| a. | | The creation of UNDOTBS1 fails |
| b. | | Oracle places the file in $ORACLE_HOME/oradata/ directory |
| c. | | Oracle creates a data file and placed it in $ORACLE_HOME/data directory |
| d. | | Oracle creates a data file in the directory specified in DB_CREATE_FILE_DEST
|
|
|
|
|
|
|
| 9. | What will be the result of issuing the following command?
ALTER TABLE USER_table DEALLOCATE UNUSED;
|
| a. | | All blocks below the high-water mark of USER_TABLE are deallocated |
| b. | | The high-water mark of USER_TABLE is recalculated and stored in the segment header |
| c. | | All blocks of USER_TABLE that contain no rows are de-allocated |
| d. | | All blocks above the high-water mark of USER_TABLE are deallocated, as long as the high-water mark is beyond the minimum creation size of the segment
|
|
|
|
|
|
|
| 10. | How can the amount of sorting that is performed be reduced? |
| a. | | Use UNION instead of UNION ALL |
| b. | | Use NOSORT when creating tables |
| c. | | Use NOSORT when creating indexes |
| d. | | Use COMPUTE instead of ESTIMATE when analyzing objects
|
|
|
|
|
|
|
| 11. | TKPROF is: |
| a. | | A utility that enables SQL code to run faster |
| b. | | Used to format the trace file generated by SQL_TRACE |
| c. | | A diagnostic tool used to capture operating system statistics |
| d. | | A utility used to capture the statistics of all SQL currently running in the database
|
|
|
|
|
|
|
| 12. | A database is running on a server that has 3 CPUs, and has these settings for initialization parameters:
db_cache_size= 4M
shared_pool_size= 52428800
db_block_size= 2048
large_pool_size= 614400
java_pool_size = 20971520
db_file_multiblock_read_count= 8
parallel_max_servers= 4
What is a valid statement about the above scenario? |
| a. | | Tune the number of latches by setting it to db_cache_size(50*db_block_size) |
| b. | | Tune the number of latches by setting to large_pool_size/1000 |
| c. | | Tune the number of latches by setting it to Number of CPUs *1 *2 |
| d. | | Oracle9i would automatically calculate the number of latches required, based on the environment defined by the initialization parameters for the database and the operating system level parameters
|
|
|
|
|
|
|
What others think about Free Oracle OCP Practice Test - Oracle OCP Performance Tuning Questions |
| By: Alice on 11/21/2009 |
| | Its a very good Quiz. It rocks my socks!!!!! |
|
 |
| By: Tallitha on 11/20/2009 |
|
|
| By: QuizMoz Fan on 11/19/2009 |
| | I love all the QuizMoz quizzes. The general knowledge quiz is my favorite |
|
|
| By: Tommy on 11/18/2009 |
| | Great site. Good learning and fun. |
|
|
| By: Lil Wayne Fan on 11/17/2009 |
| | Give me more quiz questions about LilWayne |
|
| By: Aumkar on 11/16/2009 |
|
|
| By: Erin on 11/15/2009 |
| | it was a fun and interseting quiz! |
|
|
| By: Bobby Kalsi on 11/14/2009 |
| | Try to make it easier to search for a QUIZ Category.. (It should be easier to seach for a quiz category...) |
|
|
| By: general knowledge seeker on 11/13/2009 |
| | i love to take tests and quizzes. quizzes are my life. general knowledge questions are good for everyone |
|
|
| By: Dave on 11/12/2009 |
| | I really enjoyed this quiz. I will take a lot of information away with me. Great quiz |
|
|
| By: Teena on 11/11/2009 |
| | I love this quiz Website. This is the best free quiz site. |
|
|
| By: Shannon on 11/10/2009 |
| | I have never seen such an excellent quiz website before this. |
|
|
| By: Haris on 11/9/2009 |
| | These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength. |
|
|
| By: Roger on 11/8/2009 |
| | I love Quiz Games. QuizMoz is an excellent Quiz site |
|
|
| By: Nancy on 11/7/2009 |
| | I would like to see a complete page of horror movie quizzes for the horror genre fans! |
|
|
| By: Free quiz seeker on 11/6/2009 |
| | I am searching for an impossible quiz |
|
|
| By: Reema on 11/5/2009 |
| | Great Quiz! The quizmaster laid out this quiz so that even beginners could learn more |
|
|
| By: Hot girl on 11/4/2009 |
| | I love answering Quiz Questions |
|
|
| By: Quiz Game Player on 11/3/2009 |
| | One day I will crack all the Impossible quizzes in the world |
|
|
| By: Personality Quiz Man on 11/2/2009 |
| | I love quizzes. Personality Quizzes are my favorite. |
|
|
