| 1. | While connecting directly from a client to an Oracle Server, the operating system protocol prevents the connection request from being handed off to a different process and instead uses a redirect session. After a server process is started, the client receives a redirect message that contains the location of a server process. To what is the connection being made? |
| a. | | An Oracle Shared Server |
| b. | | A dedicated server |
| c. | | A dedicated server using an agent |
| d. | | A dedicated server using a dispatcher
|
|
|
|
|
|
|
| 2. | Which Oracle Net Services feature supports authentication methods such as token cards through the use of authentication adapters? |
| a. | | Heterogeneous Services |
| b. | | Firewalls |
| c. | | Oracle Advanced Security |
| d. | | Oracle Connection Manager
|
|
|
|
|
|
|
| 3. | Which component is NOT part of an Oracle Shared Server architecture? |
| a. | | Listener |
| b. | | Dispatcher |
| c. | | Virtual Circuit |
| d. | | PMON Process |
| e. | | SMON process
|
|
|
|
|
|
|
| 4. | Oracle Net Configuration Assistant is a post-installation tool that configures basic network components after installation. Which of the following components are included in the configuration? |
| a. | | Directory Server |
| b. | | Hostname Adapter |
| c. | | Net Service names in a tnsnames.ora file |
| d. | | Connection Manager |
| e. | | External Procedures |
| f. | | Listener names and protocol addresses |
| g. | | Naming methods the client uses to resolve connect identifiers
|
|
|
|
|
|
|
| 5. | JOHN is using the Oracle Net Configuration Assistant to configure his machine to use local naming. He chose TNSNAMES (local naming) as his connection method, specified a database service name, entered the network protocol, and then specified a host name and a listener port. What is the next step he should take? |
| a. | | Test the connection |
| b. | | Configure a listener |
| c. | | Specify a net service name |
| d. | | Specify the Oracle database version
|
|
|
|
|
|
|
| 6. | In the Oracle9i Data Guard architecture, what is the purpose of the Log Transport Services? |
| a. | | To transfer redo log information to one or more destinations |
| b. | | To apply redo log records sent from the primary database to a standby database at the receiving location |
| c. | | To synchronize changes to the control files on all standby databases with changes on the primary database when a log switch occurs |
| d. | | To batch archived log files on the primary database until a defined number of checkpoints have been processed and then to distribute the archives to each standby database(A: per il trasporto dei logfile su rete, è scritto nel parametro service su log_archive_destn)
|
|
|
|
|
|
|
| 7. | A company has four DBAs. The DBA who added a column to the JOB_HISTORY table needs to be found out. The database cannot be offline during work hours. Which LogMiner command can be used to find out which user made the table change? |
| a. | | Wait until after hours, shut the database down, and issue the command EXECUTE DBMS_LOGMNR_D.BUILD to extract the information from the database |
| b. | | SELECT username, operation, sql_redo from V$LOGMNR_LOGS where operation='DDL'; |
| c. | | SELECT username, operation, sql_redo from V$LOGMNR_CONTENTS where operation='DDL'; |
| d. | | The task cannot be done. LogMiner does not track DDL commands in Oracle9i
|
|
|
|
|
|
|
| 8. | what is the least amount of work needed if the database should be recoverable in the future? |
| a. | | Make a complete backup right after opening the database |
| b. | | Copy the data file DF1 back to the backup directory |
| c. | | Back up the data file |
| d. | | Bring tablespace TS1 online
|
|
|
|
|
|
|
| 9. | Which file types must be included in a closed database backup taken with operating system commands? |
| a. | | Data files |
| b. | | Password file |
| c. | | Online redo log files |
| d. | | Initialization Parameter File |
| e. | | Control File
|
|
|
|
|
|
|
| 10. | Five data files, that are spread across multiple disks have to be recovered. Which initialization parameter should be set to speed up redo application? |
| a. | | RECOVERY_PARALLELISM |
| b. | | FAST_START_MTTR_TARGET |
| c. | | LOG_CHECKPOINT_INTERVAL |
| d. | | FAST_START_PARALLEL_ROLLBACK
|
|
|
|
|
|
|
| 11. | The HR_USER tablespace in an ARCHIVELOG mode database is corrupt and must be rebuilt. No committed data should be lost. The following steps were performed to recover the data files belonging to the HR_USER tablespace:
1. Set the corrupt data files offline.
2. Restore the corrupt data files.
3. Ensure the database is in MOUNT mode.
4. Issue the RECOVER AUTOMATIC TABLESPACE apps_user command.
5. Issue the ALTER DATABASE OPEN statement.
Which event occurs between steps 4 and 5? |
| a. | | The Oracle Server prompts the operator for the name of the archived redo log files with which to begin recovery before suggesting which online redo files to automatically apply |
| b. | | The Oracle Server prompts the operator for the archived redo log files' locations before suggesting which online redo files to automatically apply |
| c. | | The Oracle Server automatically applies the necessary logs one at a time, providing a prompt for each file to be accepted or rejected by the operator, until all required archived and online redo log files have been applied to the restored APPS_USER tablespaces data files |
| d. | | The Oracle Server automatically applies the necessary logs until all required archived and online redo log files have been applied to the restored HR_USER tablespace's data files
|
|
|
|
|
|
|
| 12. | The following command was executed in MOUNT mode:
ALTER DATABASE ARCHIVELOG;
Where is the information that the database is now in ARCHIVELOG mode stored? |
| a. | | SPFILE |
| b. | | Archive Log |
| c. | | Control File |
| d. | | System Tablespace
|
|
|
|
|
|
|
