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 Guide Oracle Test Practice - Oracle 9i OCP Fundamental I   Hottest Quizzes Free IQ Test  Oracle OCP Guide Oracle Test Practice - Oracle 9i OCP Fundamental I Welcome to the QuizMoz Oracle OCP Guide Oracle Test Practice - Oracle 9i OCP Fundamental I. 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 Guide Oracle Test Practice - Oracle 9i OCP Fundamental I Facts  Average Score for this quiz: 27%  No of times this quiz has been taken: 25  No of people passing this quiz: 6  No of people failing this quiz: 19  Maximum score for this quiz: 100% Coverage : Oracle Architectural Components Oracle Enterprise Manager Oracle Architectural Components Storage Structure and Relationships Maintaining Redo log Files Managing the Control Files Managing Tablespace and Datafiles Managing Database Managing an Oracle Instance Creating a Database Getting Started with the Oracle Server Using Data Dictionary and Dynamic Performance Views  Oracle OCP Guide Oracle Test Practice - Oracle 9i OCP Fundamental I Discussion Forum 1.  Which Oracle 9i initialization file parameters can be used to control the size of the SGA?   a. DB_BLOCK_SIZE b. SHARED_POOL_SIZE c. DB_BLOCK_BUFFERS d. JAVA_POOL_SIZE Please provide appropriate updations Ques Which Oracle 9i initialization file parameters can be used to control the size of the SGA? a. b. c. d. Please describe the changes made by you 2.  Which storage structure provides a way to physically store rows from more than one table in the same data block? a. Cluster table b. Partitioned table c. Unclustered table d. Index-organized table Please provide appropriate updations Ques Which storage structure provides a way to physically store rows from more than one table in the same data block? a. b. c. d. Please describe the changes made by you 3.  Which of the following are considered as types of segments? a. Only LOBS b. Only nested tables c. Only nested tables and index-organized tables d. Only LOBS, nested tables, and index-organized tables e. Nested tables, LOBS, index-organized tables, and boot straps f. All of the above Please provide appropriate updations Ques Which of the following are considered as types of segments? a. b. c. d. e. f. Please describe the changes made by you 4.  What provides for recovery of data that has not been written to the data files prior to a failure? a. Redo log b. Undo segment c. Rollback segment d. System tablespace e. All of the above Please provide appropriate updations Ques What provides for recovery of data that has not been written to the data files prior to a failure? a. b. c. d. e. Please describe the changes made by you 5.  What advantages does the server parameter file (SPFILE) provide when managing initialization parameters? a. The Oracle server maintains the server parameter file b. The server parameter file is created automatically when the instance is started c. Changes can be made in memory and/or in the SPFILE with the ALTER SYSTEM command d. The use of SPFILE provides the ability to make changes persistent across shut down and start up e. The Oracle server keeps the server parameter file and the text initialization parameter file synchronized. Please provide appropriate updations Ques What advantages does the server parameter file (SPFILE) provide when managing initialization parameters? a. b. c. d. e. Please describe the changes made by you 6.  If a database is in ARCHIVELOG mode, which of the following statements are true before the Log Writer (LGWR) can reuse a filled online redo log file? a. The redo log file must be archived b. All of the data files must be backed up c. All transactions with entries in the redo log file must complete d. The changes recorded in the redo log file must be written to the data files Please provide appropriate updations Ques If a database is in ARCHIVELOG mode, which of the following statements are true before the Log Writer (LGWR) can reuse a filled online redo log file? a. b. c. d. Please describe the changes made by you 7.  A company was consolidated into one office building, so the very large EMPLOYEES table no longer required the BUILDING_LOCATION column. The DBA decided to drop the column using the syntax below: ALTER TABLE hr.employees DROP COLUMN building_location CASCADE CONSTRAINTS; Dropping this column turned out to be very time consuming and required a large amount of undo space. What should the DBA do to minimize the problem regarding time and undo space consumption? a. Mark the column as UNUSED and remove the column at a later time when less activity is on the system b. Drop all indexes and constraints associated with the column prior to dropping the column c. Mark the column INVALID prior to beginning the drop to bypass undo and remove the column using the DROP UNUSED COLUMNS command d. Add a checkpoint to the DROP UNUSED COLUMNS command to minimize undo space Please provide appropriate updations Ques A company was consolidated into one office building, so the very large EMPLOYEES table no longer required the BUILDING_LOCATION column. The DBA decided to drop the column using the syntax below:<br>ALTER TABLE hr.employees<br>DROP COLUMN building_location<br>CASCADE CONSTRAINTS;<br>Dropping this column turned out to be very time consuming and required a large amount of undo space.<br>What should the DBA do to minimize the problem regarding time and undo space consumption? a. b. c. d. Please describe the changes made by you 8.  The STARTUP MOUNT command was issued. What happens when the instance is started and the database is mounted? a. The SGA is allocated b. The background process is started c. The existence of the datafile is verified d. The existence of the online redo log file is verified Please provide appropriate updations Ques The STARTUP MOUNT command was issued. What happens when the instance is started and the database is mounted? a. b. c. d. Please describe the changes made by you 9.  Intermittent hardware problems are being experienced with the disk drive on which the control file is located. It is decided to multiplex the control file. While the database is open, the following steps were performed: 1. A copy of the control file was made using an operating system command. 2. A new file name was added to the list of files for the CONTROL FILES parameter in the text initialization parameter file, using an editor. 3. The instance was shut down. 4. The STARTUP command was issued to restart the instance, mount, and open the database. The instance starts, but the database mount fails. Why? a. The control file was copied before shutting down the instance b. An operating system command was used to copy the control file c. The Oracle server does not know the name of the new control file d. A new control file name was added to the CONTROL_FILES parameter before shutting down the instance Please provide appropriate updations Ques Intermittent hardware problems are being experienced with the disk drive on which the control file is located. It is decided to multiplex the control file.<br>While the database is open, the following steps were performed:<br>1. A copy of the control file was made using an operating system command.<br>2. A new file name was added to the list of files for the CONTROL FILES parameter in the text initialization parameter file, using an editor.<br>3. The instance was shut down.<br>4. The STARTUP command was issued to restart the instance, mount, and open the database.<br>The instance starts, but the database mount fails. Why? a. b. c. d. Please describe the changes made by you 10.  The Database Configuration Assistant can be used to create a template using an existing database structure. What will be included in this template? a. Data files b. Tablespaces c. User defined schemas d. User defined schema data e. Initialization parameters Please provide appropriate updations Ques The Database Configuration Assistant can be used to create a template using an existing database structure. What will be included in this template? a. b. c. d. e. Please describe the changes made by you 11.  An Oracle instance is executing in a nondistributed configuration. The instance fails because of an operating system failure. Which background process would perform the instance recovery when the database is reopened? a. PMON b. SMON c. RECO d. ARCn e. CKPT Please provide appropriate updations Ques An Oracle instance is executing in a nondistributed configuration. The instance fails because of an operating system failure. Which background process would perform the instance recovery when the database is reopened? a. b. c. d. e. Please describe the changes made by you 12.  The location of all the tables and indexes owned by one user has to be determined. Which DBA view should be looked into? a. DBA_TABLES b. DBA_INDEXES c. DBA_SEGMENTS d. DBA_TABLESPACES Please provide appropriate updations Ques The location of all the tables and indexes owned by one user has to be determined. Which DBA view should be looked into? 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 Guide Oracle Test Practice - Oracle 9i OCP Fundamental I  Name: Think you know more about Oracle OCP Guide Oracle Test Practice - Oracle 9i OCP Fundamental I 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 Guide Oracle Test Practice - Oracle 9i OCP Fundamental I Discussion Forum Know the Latest News about Oracle OCP Guide Oracle Test Practice - Oracle 9i OCP Fundamental I! What others think about Oracle OCP Guide Oracle Test Practice - Oracle 9i OCP Fundamental I By: MOHSIN on Oct 26, 2009    Good question for practice By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks By: Amol Palaskar on Sep 18, 2009    Nice test Thanks   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.