| 1. | A client-server application has become very popular and hundreds of users are accessing the Oracle Server daily. Which networking solution should be implemented to ensure that all users can access the Oracle Server? |
| a. | | Dedicated Server |
| b. | | Directory Naming |
| c. | | Oracle Connection Manager |
| d. | | Heterogeneous Services
|
|
|
|
|
|
|
| 2. | While attempting to connect to a remote server, the following error appeared:
ORA-12533: TNS:illegal ADDRESS parameters
To attempt to resolve the error, the tnsnames.ora file was examined. What should be verified in this file? |
| a. | | That the correct service name exists in the tnsnames.ora file |
| b. | | That the service name of the database was entered correctly in the connect string |
| c. | | That the connect descriptor's' protocol-specific parameters located in the ADDRESS section are correct |
| d. | | That the service name of the database was entered correctly in the connect string
|
|
|
|
|
|
|
| 3. | In a client-server configuration, a user is executing a long-running script that performs many inserts. The process hangs, and the user reboots their machine. The user has called for assistance. What steps should the DBA take to assist the user in the execution of the script? |
| a. | | Apply archived redo log files to recover any inserts that were committed prior to the termination of the transaction |
| b. | | Do nothing. The Oracle Server will automatically perform instance recovery |
| c. | | Do nothing. The PMON background process will roll back the transaction releasing any resources and locks |
| d. | | Restore the database to a point-in-time prior to the abnormal termination of the transaction.
|
|
|
|
|
|
|
| 4. | The following INSERT statement was issued:
INSERT /* +APPEND */ INTO arch.curr_order_hist
SELECT * FROM ord.curr_order;
Which type of INSERT is performed? |
| a. | | Conventional |
| b. | | Direct-Load |
| c. | | Parallel Direct-Load |
| d. | | Serial-Conventional
|
|
|
|
|
|
|
| 5. | Which initialization parameters are not needed when FAST_START_MTTR_TARGET is defined? |
| a. | | LOG_FILE_SIZE_REDO_BLKS |
| b. | | LOG_CHECKPOINT_INTERVAL |
| c. | | TARGET_REDO_BLKS |
| d. | | FAST_START_IO_TARGET |
| e. | | LOG_CHECKPOINT_TIMEOUT |
| f. | | RECOVERY_ESTIMATED_IOS
|
|
|
|
|
|
|
| 6. | A media failure occurred causing NOARCHIVELOG mode database to crash. It was discovered that two of the data files are corrupt. The last whole closed database backup was taken one week ago with a online redo log sequence number of 83. At the time the data files were corrupted, the online redo log sequence number was 85. Although there were few committed transactions after the last backup, as much data as possible has to be recovered. Which recovery process should be used? |
| a. | | Shut down the instance, restore all of the Oracle files from the most recent backup, and restart the instance |
| b. | | Manually restore and recover the two corrupt data files from the most recent backup |
| c. | | Shut down the instance, restore the two corrupt data files from the most recent backup, and restart the instance |
| d. | | Shut down the instance, restore all of the Oracle files from the most recent backup, restart the instance, and open the database using the 'ALTER DATABASE OPEN RESETLOGS' statement
|
|
|
|
|
|
|
| 7. | A team is designing the backup and recovery strategy for a company. Management's priority is to minimize downtime. Which business requirement should they focus on? |
| a. | | MTBF |
| b. | | RMAN |
| c. | | MTTR |
| d. | | Evolutionary Process
|
|
|
|
|
|
|
| 8. | In an Oracle environment, which categories of failure are more likely to require DBA involvement for resolution? |
| a. | | Media |
| b. | | Network |
| c. | | Statement |
| d. | | User process |
| e. | | User error
|
|
|
|
|
|
|
| 9. | A database has several simultaneous long-running insert transactions. The following statement was issued to ensure that multiple server processes are used to roll back uncommitted transactions:
ALTER SYSTEM SET FAST_START_PARALLEL_ROLLBACK = 5;
What is the result? |
| a. | | Up to five rollback processes may be activated simultaneously |
| b. | | The parameter will be ignored because the maximum number of rollback processes is four |
| c. | | The parameter will be ignored because it is set to an invalid value |
| d. | | This parameter will be ignored unless the RECOVERY_PARALLELISM parameter is used
|
|
|
|
|
|
|
| 10. | The following SQL command was issued to perform an online backup of the USER_DATA tablespace:
ALTER TABLESPACE user_data BEGIN BACKUP;
Next, an operating system command was issued to back up user user01.dbf, the file that belongs to the USER_DATA tablespace.
An instance failure was then experienced. Which of the following statements are true? |
| a. | | The user_data01.dbf file needs to be restored from an earlier backup and recovered |
| b. | | The online backup of the USER_DATA tablespace can be ended with an ALTER DATABASE command |
| c. | | The backup of user data01.bbf is unusable for future recoveries if the operating system copy was not completed before the instance failure |
| d. | | The user_data01.dbf file is corrupt because of the instance failure during the online backup of the data file
|
|
|
|
|
|
|
| 11. | Which events occur when a checkpoint occurs? |
| a. | | The CKPT process writes committed redo data to disk |
| b. | | The DBWn processes write altered database buffers to disk |
| c. | | The control file is updated with checkpoint information |
| d. | | The archived redo log files are updated with checkpoint information |
| e. | | The LGWR process writes redo entries from the database buffer to the online redo log files
|
|
|
|
|
|
|
| 12. | Examine the following statement:
ALTER DATABASE BACKUP CONTROL FILE TO 'control01.bkp';
What does the statement generate? |
| a. | | A file containing a SQL statement which will re-create the database |
| b. | | A text copy to the control file |
| c. | | A binary copy of the control file |
| d. | | A file containing a SQL statement which will re-create the control file
|
|
|
|
|
|
|
What others think about Free Oracle OCP Practice Test - Oracle OCP Fundamentals |
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
 |
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
| By: Ayobami Busari on Jun 12, 2009 |
| | this is a good place to learn |
|
|
