| 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
|
|
|
|
|
|
|
What others think about Oracle OCP Practice Test - Oracle OCP Fundamental I |
| By: Karl on Aug 29, 2009 |
|
 |
| By: Anirban on Apr 15, 2009 |
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
| By: Anirban on Apr 15, 2009 |
|
|
