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 Valentine Quiz   Michael Jackson Quiz   English Language Test   Does He Love You Quiz   Business Phone Etiquette Quiz   Impossible Quiz   Personality Quiz   Free Quizzes   Tiger Woods Wife Cheating Quiz   Keira Knightley Quiz   Rage Against The Machines Quiz   FIFA World Cup 2010   Are you in Love Quiz   Skeletal System Quiz   Love Personality Quiz   NFL Quiz         Home > Quizzes and Fun Tests > Oracle OCP Practice Tests > Oracle OCP test Practice Test questions- Oracle OCP Fundamental Hottest Quizzes   Valentine Quiz  Oracle OCP test Practice Test questions- Oracle OCP Fundamental Welcome to the QuizMoz Oracle OCP test Practice Test questions- Oracle OCP Fundamental. 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 test Practice Test questions- Oracle OCP Fundamental Facts  Average Score for this quiz: 31%  No of times this quiz has been taken: 17  No of people passing this quiz: 6  No of people failing this quiz: 11  Maximum score for this quiz: 67% 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  Oracle OCP test Practice Test questions- Oracle OCP Fundamental Discussion Forum 1.  The local naming method is being used to connect to a remote server and the service name is being provided in the connection request. This service name is mapped to a network address contained in a _________. a. Connect Descriptor b. Connect identifier c. Connect String d. Connected Directory Please provide appropriate updations Ques The local naming method is being used to connect to a remote server and the service name is being provided in the connection request. This service name is mapped to a network address contained in a _________. a. b. c. d. Your Name Please describe the changes made by you 2.  In a client-server application connection with no middle-tier, what are the five server stack components? a. Oracle database, TTC, Oracle Net, OPS, and Protocol b. Oracle database, Oracle Net, OSI, TTC, and Protocol c. Forms/SQL*Plus, OPS, TTC, Oracle Net, and protocol d. Oracle Net, TTC, OPS, OCI, and protocol Please provide appropriate updations Ques In a client-server application connection with no middle-tier, what are the five server stack components? a. b. c. d. Your Name Please describe the changes made by you 3.  The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes required. To process a request for a server process, the following tasks are performed: 1. A shared server picks up the request from the request queue and processes the request. 2. The dispatcher retrieves the response from the response queue. 3. A user sends a request to its dispatcher. 4. The dispatcher returns the response to the user. 5. The shared sever places the response on the calling dispatcher's response queue. 6. The dispatcher places the request into the request queue in the SGA. What is the sequence of performance of these tasks? a. 3, 1, 6, 2, 5, 4 b. 3, 6, 1, 5, 2, 4 c. 3, 1, 2, 3, 4, 5 d. 6, 1, 3, 5, 2, 4 e. 6, 3, 1, 2, 4, 5 f. 6, 3, 1, 2, 5, 4 Please provide appropriate updations Ques The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes required. To process a request for a server process, the following tasks are performed:<br><br>1. A shared server picks up the request from the request queue and processes the request.<br>2. The dispatcher retrieves the response from the response queue.<br>3. A user sends a request to its dispatcher.<br>4. The dispatcher returns the response to the user.<br>5. The shared sever places the response on the calling dispatcher's response queue.<br>6. The dispatcher places the request into the request queue in the SGA.<br><br>What is the sequence of performance of these tasks? a. b. c. d. e. f. Your Name Please describe the changes made by you 4.  Under the Oracle Shared Server architecture, client-user processes ultimately connect to a __________. a)Service b. Listener c. Dispatcher d. Shared server process Please provide appropriate updations Ques Under the Oracle Shared Server architecture, client-user processes ultimately connect to a __________.<br> a)Service b. c. d. Your Name Please describe the changes made by you 5.  A user issued a connection request which was picked up by the listener on an Oracle Shared Server. The listener provided the user process with the address of an existing dispatcher process. What is the next step in this process? a. The user process is handed off to a dedicated server process b. The user process connects directly to the dispatcher c. The dispatcher process places the user request in a response queue d. The user process connects directly to the Oracle Shared Server process Please provide appropriate updations Ques A user issued a connection request which was picked up by the listener on an Oracle Shared Server. The listener provided the user process with the address of an existing dispatcher process. What is the next step in this process? a. b. c. d. Your Name Please describe the changes made by you 6.  MARY used an ALTER DATABASE statement on her database to perform an online control file backup. In which mode is her database operating? a. FAILOVER b. FASTBACK c. ARCHIVELOG d. NOARCHIVELOG Please provide appropriate updations Ques MARY used an ALTER DATABASE statement on her database to perform an online control file backup. In which mode is her database operating? a. b. c. d. Your Name Please describe the changes made by you 7.  Which initialization parameter affects the roll forward phase of recovery by manipulating the frequency at which checkpoints are written? a. FAST_START_IO_TARGET b. FAST_START_MTTR_TARGET c. LOG_CHECKPOINT_TIMEOUT d. LOG_CHECKPOINT_INTERVAL Please provide appropriate updations Ques Which initialization parameter affects the roll forward phase of recovery by manipulating the frequency at which checkpoints are written? a. b. c. d. Your Name Please describe the changes made by you 8.  The ARCn processers are writing online redo log files to one local mandatory destination, one local optional destination, and one remote mandatory destination. The LOG_ARCHIVE_MIN_SUCCEED_DEST parameter is set to 2. What effect does this parameter have on the automatic archival process? a. After the archival of online redo log files to the two mandatory destinations occurs, the online redo logs may be overwritten b. After the archival of online redo log files to the two local destinations occurs, the online redo logs may be overwritten c. No effect because the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value is NOT equal to the number of local mandatory archive destinations d. After the archival of online redo log files to the one local mandatory destination occurs, the online redo logs may be overwritten Please provide appropriate updations Ques The ARCn processers are writing online redo log files to one local mandatory destination, one local optional destination, and one remote mandatory destination. The LOG_ARCHIVE_MIN_SUCCEED_DEST parameter is set to 2. <br>What effect does this parameter have on the automatic archival process? a. b. c. d. Your Name Please describe the changes made by you 9.  The LOG_ARCHIVE_START initialization parameter for NOARCHIVELOG mode database is set to 'TRUE'. The ARCn processes are not automatically copying the online redo log files. While troubleshooting, it was verified that valid archived redo log file destinations are provided using the LOG_ARCHIVE_DEST_n initialization parameters, yet no files are written to these destinations. What should be done next? a. Refresh the current online redo log files b. Switch the database from NOARCHIVELOG to ARCHIVELOG mode c. Issue the 'ALTER SYSTEM ARCHIVE LOG START' statement to activate the ARCn processes d. Shut down and restart the database to activate the ARCn processes Please provide appropriate updations Ques The LOG_ARCHIVE_START initialization parameter for NOARCHIVELOG mode database is set to 'TRUE'. The ARCn processes are not automatically copying the online redo log files. While troubleshooting, it was verified that valid archived redo log file destinations are provided using the LOG_ARCHIVE_DEST_n initialization parameters, yet no files are written to these destinations. What should be done next? a. b. c. d. Your Name Please describe the changes made by you 10.  Which statement about the use of the LOG_ARCHIVE_DEST_n initialization parameters is true? a. When defining multiple archive destinations, at least one LOCATION parameter must be included b. The maximum number of remote archive destinations is ten c. Archive destinations may only be modified at the system level d. Possible archive destinations include the local disk, any remote database, or a remote standby database Please provide appropriate updations Ques Which statement about the use of the LOG_ARCHIVE_DEST_n initialization parameters is true? a. b. c. d. Your Name Please describe the changes made by you 11.  The first step in placing a database into ARCHIVELOG mode has been performed. The second step is deciding whether the online redo log files are to be archived automatically or manually. Which action should be taken to enable archiving at instance startup? a. Immediately after setting the database in ARCHIVELOG mode, in SQL*Plus select automatic archiving using this syntax: ALTER DATABASE SET LOG_ARCHIVE_START=TRUE b. Automatic archiving is the default when ARCHIVELOG mode is set. No further actions are required c. Set the LOG_ARCHIVE_MAX_PROCESSES parameter to n (where n is the number of Archiver processes) in the initialization parameter file d. Set the LOG_ARCHIVE_START parameter to TRUE in the initialization parameter file Please provide appropriate updations Ques The first step in placing a database into ARCHIVELOG mode has been performed. The second step is deciding whether the online redo log files are to be archived automatically or manually. Which action should be taken to enable archiving at instance startup? a. b. c. d. Your Name Please describe the changes made by you 12.  A data file was moved to another physical location because of a media failure, and the ALTER DATABASE RENAME FILE statement was issued. Which file is automatically updated to reflect this change? a. Control b. Alert c. Registry d. Parameter Please provide appropriate updations Ques A data file was moved to another physical location because of a media failure, and the ALTER DATABASE RENAME FILE statement was issued. Which file is automatically updated to reflect this change? a. b. c. d. Your Name 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 test Practice Test questions- Oracle OCP Fundamental  Name: Think you know more about Oracle OCP test Practice Test questions- Oracle OCP Fundamental 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 test Practice Test questions- Oracle OCP Fundamental Discussion Forum Know the Latest News about Oracle OCP test Practice Test questions- Oracle OCP Fundamental! What others think about Oracle OCP test Practice Test questions- Oracle OCP Fundamental By: Tallitha on 3/22/2010    This quiz is amazing By: Dave on 3/21/2010    I really enjoyed this quiz. I will take a lot of information away with me. Great quiz By: QuizMoz Fan on 3/20/2010    I love all the QuizMoz quizzes. The general knowledge quiz is my favorite By: Aumkar on 3/19/2010    It was enjoyable. By: Kath on 3/18/2010    It's a really good quiz. By: Sridhar on 3/17/2010    Its a really good way to brush up things and informative also. By: Penny on 3/16/2010    NICE WEBSITE, great quiz! By: Teena on 3/15/2010    I love this quiz Website. This is the best free quiz site. By: quiz girl on 3/14/2010    hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge By: Lil Wayne Fan on 3/13/2010    Give me more quiz questions about LilWayne By: Alice on 3/12/2010    Its a very good Quiz. It rocks my socks!!!!! By: Roger on 3/11/2010    I love Quiz Games. QuizMoz is an excellent Quiz site By: Erin on 3/10/2010    it was a fun and interseting quiz! By: Hot girl on 3/9/2010    I love answering Quiz Questions By: Roger on 3/8/2010    I love Quiz Games. QuizMoz is an excellent Quiz site By: Laura on 3/7/2010    I appreciate the time and effort that the quiz maker put into the quiz By: Tommy on 3/6/2010    Great site. Good learning and fun. By: Shannon on 3/5/2010    I have never seen such an excellent quiz website before this. By: Kayla on 3/4/2010    I think this is a great quiz full of knowlodge and information. By: Free quiz seeker on 3/3/2010    I am searching for an impossible quiz Hot Links   Hottest Quizzes Valentine Quiz   Free IQ Test   Big Brother 2010   Kids General Knowledge Quiz   2009 General Knowledge Quiz   NBA 2010 Quiz   Science Quiz for Kids   Medical Terminology Quiz   Career Quiz for Kids   Home And Away Quiz   Harry Potter Quiz   US History 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.