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 > Free Oracle OCP Practice Test - Oracle OCP Fundamentals Quiz   Hottest Quizzes Free IQ Test  Free Oracle OCP Practice Test - Oracle OCP Fundamentals Quiz Welcome to the QuizMoz Free Oracle OCP Practice Test - Oracle OCP Fundamentals 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!!  Free Oracle OCP Practice Test - Oracle OCP Fundamentals Quiz Facts  Average Score for this quiz: 31%  No of times this quiz has been taken: 24  No of people passing this quiz: 3  No of people failing this quiz: 21  Maximum score for this quiz: 100% Coverage : Networking Overview Basic Net Client Side Configuration Basic Net Server Side Configuration Oracle Shared Server architecture Basic Oracle Net Architecture Instance and Media Recovery Overview Loading Data Into Database Instance and Media Recovery Structure Configuring the Database in Archiving Mode User Managed Complete Recovery Backup and Recovery Overview User Managed Backup Configuring The Database in Archiving Mode  Free Oracle OCP Practice Test - Oracle OCP Fundamentals Discussion Forum 1.  When attempting to connect to an instance that is down, which Oracle Net feature or component facilitates automatic connect-time fail-over to another instance for the user? a. Oracle Names Server b. Heterogeneous Services c. Oracle Connection Manager d. Dynamic Service Registration Please provide appropriate updations Ques When attempting to connect to an instance that is down, which Oracle Net feature or component facilitates automatic connect-time fail-over to another instance for the user? a. b. c. d. Please describe the changes made by you 2.  What is the new Oracle Shared Server? a. An improved version of multithreaded server configuration b. A connection pooling configuration where several clients are connected to the same server process c. Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected d. A configuration of Real Application Cluster where the client connection is routed to the least busy instance Please provide appropriate updations Ques What is the new Oracle Shared Server? a. b. c. d. Please describe the changes made by you 3.  Which operations are performed during both crash and instance recovery? a. The roll back of the most recent redo log checkpoint b. The roll forward of the current online redo log files c. The roll back of the uncommitted transactions from the data files d. The roll forward of the online data files by applying online redo records e. The roll forward of the uncommitted transactions to the online data files Please provide appropriate updations Ques Which operations are performed during both crash and instance recovery? a. b. c. d. e. Please describe the changes made by you 4.  How can automatic archiving at instance startup be enabled for a ARCHIVELOG database? a. With the database open, issue the 'ARCHIVE LOG START ALL' SQL*Plus command b. With the database shut down, set the LOG_ARCHIVE_START initialization parameter to 'TRUE' c. With the database mounted, issue the 'ALTER DATABASE ARCHIVELOG' SQL statement d. With the database open, issue the 'ALTER SYSTEM ARCHIVE LOG START TO <file_name>' SQL statement Please provide appropriate updations Ques How can automatic archiving at instance startup be enabled for a ARCHIVELOG database? a. b. c. d. Please describe the changes made by you 5.  When performing media recovery, an archived log is lost or corrupt. Which type of recover must be performed? a. Until SCN b. Until time c. Until cancel d. Recover using backup control file Please provide appropriate updations Ques When performing media recovery, an archived log is lost or corrupt. Which type of recover must be performed? a. b. c. d. Please describe the changes made by you 6.  During a recovery operation, data files are restored from backup and DBWn writes committed and uncommitted data to the data files during the roll forward. What happens immediately after a roll forward? a. A rollback b. A commit c. A checkpoint d. Cache recovery Please provide appropriate updations Ques During a recovery operation, data files are restored from backup and DBWn writes committed and uncommitted data to the data files during the roll forward. What happens immediately after a roll forward? a. b. c. d. Please describe the changes made by you 7.  Which files must be synchronized, for a database to open without recovery? a. Archived Redo Log b. Online redo log c. Password d. Data e. Control Please provide appropriate updations Ques Which files must be synchronized, for a database to open without recovery? a. b. c. d. e. Please describe the changes made by you 8.  While performing an online tablespace backup, a power failure occurred. The data files are in a consistent state. Which tasks must be performed to continue the tablespace backup? a. Recover the data files that are in online backup mode b. Unfreeze the header of the data files that are in backup mode c. Make the data files read-only until recovery is complete d. End the backup which will change the status of the data files that are in backup mode to NOT ACTIVE in the V$BACKUP view Please provide appropriate updations Ques While performing an online tablespace backup, a power failure occurred. The data files are in a consistent state. Which tasks must be performed to continue the tablespace backup? a. b. c. d. Please describe the changes made by you 9.  Examine this SQL*Plus session: SQL> INSERT INTO employee (employee_id, last_name, dept_id, salary) 2     VALUES (1893, 'SMITH', 90, 60000); VALUES (1893, 'SMITH', 90, 60000) ERROR at line 1: ORA-02291: integrity constraint (T.FK_DEPT_ID) violated - parent key not found Which category of failure was encountered? a. Instance b. Statement c. User Error d. User Process Please provide appropriate updations Ques Examine this SQL*Plus session:<br><br>SQL> INSERT INTO employee (employee_id, last_name, dept_id, salary)<br>2 VALUES (1893, 'SMITH', 90, 60000);<br>VALUES (1893, 'SMITH', 90, 60000)<br><br>ERROR at line 1:<br>ORA-02291: integrity constraint (T.FK_DEPT_ID) violated - parent key not found<br><br>Which category of failure was encountered? a. b. c. d. Please describe the changes made by you 10.  Which attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database?   a. SYNC or ASYNC to identify the network transmission mode b. LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby c. AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously d. PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database Please provide appropriate updations Ques Which attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? a. b. c. d. Please describe the changes made by you 11.  The following statement was issued: ALTER TABLESPACE users_data READ ONLY; Which statement is NOT true? a. A checkpoint occurs for each data file associated with the USERS_DATA tablespace b. The data files for the USERS_DATA tablespace will need to be recovered if they become corrupt or a media failure occurs c. The control file is updated to identify the data files for the USERS_DATA tablespace as read-only during recovery d. The checkpoint numbers in the data files for the USERS_DATA tablespace are frozen and do NOT need to be synchronized with the checkpoint number in the control file Please provide appropriate updations Ques The following statement was issued:<br><br>ALTER TABLESPACE users_data READ ONLY;<br><br>Which statement is NOT true? a. b. c. d. Please describe the changes made by you 12.  A failure has occurred leaving the control file and several tablespaces unavailable. To correct the problem, the database was restored from an earlier full database backup. All transactions that occurred after this backup have been lost. In which mode is the database configured? a. FAILOVER b. FLASHBACK c. NOARCHIVELOG d. ARCHIVELOG Please provide appropriate updations Ques A failure has occurred leaving the control file and several tablespaces unavailable. To correct the problem, the database was restored from an earlier full database backup. All transactions that occurred after this backup have been lost. In which mode is the database 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 Free Oracle OCP Practice Test - Oracle OCP Fundamentals  Name: Think you know more about Free Oracle OCP Practice Test - Oracle OCP Fundamentals 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) Free Oracle OCP Practice Test - Oracle OCP Fundamentals Discussion Forum Know the Latest News about Free Oracle OCP Practice Test - Oracle OCP Fundamentals! What others think about Free Oracle OCP Practice Test - Oracle OCP Fundamentals By: Kayla on 11/21/2009    I think this is a great quiz full of knowlodge and information. By: Tom on 11/20/2009    I want more quiz questions By: Quiz Game Player on 11/19/2009    One day I will crack all the Impossible quizzes in the world By: general knowledge seeker on 11/18/2009    i love to take tests and quizzes. quizzes are my life. general knowledge questions are good for everyone By: Kath on 11/17/2009    It's a really good quiz. By: Lil Wayne Fan on 11/16/2009    Give me more quiz questions about LilWayne By: Roger on 11/15/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Tommy on 11/14/2009    Great site. Good learning and fun. By: Shannon on 11/13/2009    I have never seen such an excellent quiz website before this. By: Reema on 11/12/2009    Great Quiz! The quizmaster laid out this quiz so that even beginners could learn more By: Personality Quiz Man on 11/11/2009    I love quizzes. Personality Quizzes are my favorite. By: Hannah on 11/10/2009    Enjoyed it, and learned a lot about general knowledge By: Tracy on 11/9/2009    Great test. A nice way to gauge one's knowledge By: Haris on 11/8/2009    These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength. By: Sridhar on 11/7/2009    Its a really good way to brush up things and informative also. By: Tallitha on 11/6/2009    This quiz is amazing By: quiz girl on 11/5/2009    hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge By: Dave on 11/4/2009    I really enjoyed this quiz. I will take a lot of information away with me. Great quiz By: Erin on 11/3/2009    it was a fun and interseting quiz! By: Penny on 11/2/2009    NICE WEBSITE, great quiz!   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.