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 test Practice Test questions- Oracle OCP Fundamental   Hottest Quizzes Free IQ Test  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: 35%  No of times this quiz has been taken: 14  No of people passing this quiz: 6  No of people failing this quiz: 8  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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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: Roger on 11/21/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Alice on 11/20/2009    Its a very good Quiz. It rocks my socks!!!!! By: Roger on 11/19/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Tallitha on 11/18/2009    This quiz is amazing By: Dave on 11/17/2009    I really enjoyed this quiz. I will take a lot of information away with me. Great quiz By: Haris on 11/16/2009    These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength. By: Kath on 11/15/2009    It's a really good quiz. By: Teena on 11/14/2009    I love this quiz Website. This is the best free quiz site. By: Personality Quiz Man on 11/13/2009    I love quizzes. Personality Quizzes are my favorite. By: Bobby Kalsi on 11/12/2009    Try to make it easier to search for a QUIZ Category.. (It should be easier to seach for a quiz category...) By: Tommy on 11/11/2009    Great site. Good learning and fun. By: Hot girl on 11/10/2009    I love answering Quiz Questions By: Erin on 11/9/2009    it was a fun and interseting quiz! By: Laura on 11/8/2009    I appreciate the time and effort that the quiz maker put into the quiz By: Penny on 11/7/2009    NICE WEBSITE, great quiz! By: quiz girl on 11/6/2009    hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge By: Sridhar on 11/5/2009    Its a really good way to brush up things and informative also. By: Aumkar on 11/4/2009    It was enjoyable. By: Tracy on 11/3/2009    Great test. A nice way to gauge one's knowledge By: Free quiz seeker on 11/2/2009    I am searching for an impossible 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.