Home      Tests New!      Polls      Take a Quiz     Make a Quiz     Login     Contact QuizMoz Go to Home Page  
   
  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
Create a Survey


Now you can Read Books Online Free at ReadCentral.com









 

Featured Quizzes
 Love Compatibility Test
 English Language Test
 Does He Love You Quiz
 Business Phone Etiquette Quiz
 Impossible Quiz
 Personality Quiz
 CAT Preparation Mock Test
 Harry Potter Quizzes
 Keira Knightley Quiz
 Rage Against The Machines Quiz
 FIFA World Cup
 Are you in Love Quiz
 Skeletal System Quiz
 Love Personality Quiz
 Harry Potter Personality Quizzes



 



      Home > Quizzes and Fun Tests > Oracle OCP Practice Tests > Oracle OCP Practice Test - Oracle OCP Fundamental I

 Follow QuizMoz on Twitter  Oracle OCP Practice Test - Oracle OCP Fundamental I

Welcome to the QuizMoz Oracle OCP Practice Test - Oracle 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!!

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
  • 1. Which of the following statements are true regarding the role Oracle Net provides in a client server connection with no middle tier?
    a.Oracle Net is layered on top of the network protocol
    b.Oracle Net must reside on both the client and the server for peer-to-peer communication to occur
    c.On the client side, Oracle Net is responsible for working with the listener to receive incoming connection requests
    d.On the sever side, Oracle Net is responsible for several connectivity issues such as the location of the server, whatever one or more protocol is involved in the connection, and how to handle exceptions and interrupts
    2. Using HTTP, TOM is connecting from a client web browser to an Oracle Server over the Internet. To which stack communication layer does HTTP belong?
    a.OPS
    b.TCP/IP
    c.Protocol
    d.TTC
    3. Examine the first three steps involved when connecting directly from a client to a server:

    1.  A connection request is initiated.
    2.  The service name is resolved to a connection string.
    3.  A request is sent to a listener on the server-side.

    When connecting to a dedicated server, which of the following possibilities could be step four?
    a.The listener hands the connection request directly to a dispatcher, and the client is now connected to a dispatcher
    b.The listener bequeaths the connection request to an existing client connection, and the client connects directly to the server
    c.The listener spawns a new process, and the server inherits the connection request from the listener. The client is then connected to the server
    d.The listener redirects the connection request to an existing process, which connects to a dispatcher. The client then connects to a dispatcher
    e.The listener spawns a new process and passes the location of the server process to the client in a redirect message. The client then connects directly to the server
    4. Which dynamic data dictionary view should be queried to view the dispatcher process address and the status of user connections to the database through dispatchers and servers?
    a.V$CIRCUIT
    b.V$PROCESS
    c.V$SESSION
    d.V$QUEUE
    5. The following error messages were received because the client cannot find the desired database:

    ORA-12198: TNS:could not path to destination
    ORA-12203: TNS:unable to connect to destination

    Which action would be appropriate in helping to resolve the errors?
    a.Verify that the sqlnet.ora file is located in the default location of $ORACLE_HOME\network\admin
    b.Verify that the NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME) parameter is set in the initialization parameter file
    c.Verify that the services name ADDRESS parameters in the connect descriptor of the tnsnames.ora file are correct
    d.Verify that the services name ADDRESS parameters in the connect descriptor of the tnsnames.ora file are incorrect
    6. Using the HTTP protocol, a web browser invokes a Java applet on an Oracle Web Application Server to initiate a connection to an Oracle Server. The Web Server connects to the Oracle Server using TCP/IP. Which product must be installed on the Web Server for this connection to be possible?
    a.IIOP
    b.JavaTTC
    c.Java Net
    d.HTTP
    7. Which modifier is used to change listener parameters in the Listener Control utility environment?
    a.ALTER
    b.CHANGE
    c.SET
    d.UPDATE
    8. During instance recovery, which Oracle Server process is responsible for reading the redo information and automatically initiating the roll forward process when a database is opened?
    a.DBWn
    b.LGWR
    c.SMON
    d.PMON
    9. The roll forward and rollback phases of a database's instance recovery are complete, and the database is in a consistent state. Which of the following statements are true?
    a.The data files are now synchronized
    b.The data files contain only committed data
    c.LGWR has written committed and uncommitted data to the data files
    d.The online redo log files, control files, and data files all have the same checkpoint number
    e.The control file checkpoint number was rolled back to a synchronized pre-crash checkpoint number
    f.All of the above
    10. A database runs in ARCHIVELOG mode, and is backed up every Sunday. The archive logs are copied to tape, and then removed every night. The database consists of 10 redo log groups.
    On Wednesday afternoon the server has an unscheduled shutdown. Upon restarting the database, corruption in the SYSTEM tablespace data file is reported. It was also noticed that there were 17 log switches since Sunday.
    Which solution should be used in order to minimize both down time and data loss?

    a.Restore all the data files from Sunday's backup, and then recover the database by applying the archived logs
    b.Restore the SYSTEM tablespace data file from Sunday's backup, and open the database
    c.Restore the SYSTEM tablespace data file from Sunday's backup, and all the archive log files from Monday and Tuesday. Then recover the database
    d.Take the SYSTEM tablespace offline, restart the database (thus allowing users back onto the database), and recover the SYSTEM tablespace by using the archive logs
    11. Which views can be queried, when performing a user-managed tablespace backup to obtain status information for the backup?
    a.V$BACKUP
    b.V$BACKUP_REDOLOG
    c.V$BACKUP_DATAFILE
    d.V$BACKUP_CORRUPTION
    e.V$DATAFILE_HEADER
    12. Which statement is true regarding checkpoints and recovery?        
    a.A checkpoint defines the highest system change number (SCN)
    b.All redo entries higher or at the SCN are known to be written to the data files
    c.Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery
    d.The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints
    13. Consider this statement:

    ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

    What does the statement generate?
    a.A file containing a SQL statement which will re-create the control file
    b.A binary copy of the control file
    c.A file containing a SQL statement which will re-create the database
    d.A text copy of the control file
    14. After completing an online backup of the CURR_ITEM tablespace, the following statement was issued:

    ALTER TABLESPACE curr_item END BACKUP;

    Which statement is true?
    a.This statement only unfreezes the headers of the data files associated with the CURR_ITEM tablespace
    b.This statement only archives the CURR_ITEM tablespace backup redo
    c.This statement alters the backup mode of all of the data files associated with the CURR_ITEM and unfreezes the headers of these data files
    d.This statement alters the backup mode of all of the data files associated with the CURR_ORDER tablespace and archives the tablespace backup redo
    Think you know more about this quiz!

     
    Please enter your Name and what you would like to tell everyone about Oracle OCP Practice Test - Oracle OCP Fundamental I
     Name:
    Think you know more about Oracle OCP Practice Test - Oracle 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)


    Know the Latest News about Oracle OCP Practice Test - Oracle OCP Fundamental I!

    Follow QuizMoz on Twitter


    What others think about Oracle OCP Practice Test - Oracle OCP Fundamental I
    By: Karl on Aug 29, 2009
      great stuff
    By: Anirban on Apr 15, 2009
      I want to know more..
      

    Quizzes for this month are sponsored by www.ExpertRating.com


     

    Most Popular Quizzes
     Be A MakeUp Artist Course
     Big Brother
     FIFA
     Soccer WAGs Quizzes
     NBA 2010 Quiz
     Science Quiz for Kids
     Medical Terminology Quiz
     Career Quiz for Kids
     Home And Away Quiz
     Harry Potter Quiz
     Harry Potter and the Deathly Hallows
     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.