#62. Click the Exhibit (missing) button and examine the diagram, which illustrates the components performing tasks within an Oracle Shared Sever environment. Which task is being performed by component 4?
#63. You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application?
#65. You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table, or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible?
#66. Oracle 9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing the dbms_redefinition_start_redef table procedure call? (Choose two)
#68. You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist. Which command should you now use to check if any of the files were missing?
#69. You received this error message because Oracle Net Services cannot locate the connect descriptor specified in the tnsnames.ora configuration file: ORA_12154: TNS:could not resolve service name Which three actions would be appropriate in helping to resolve the error? (Choose three)
#70. You experienced a loss of data files in your database. You did not lose any of your control files. You are going to use RMAN to restore and recover the database. Currently, your instance is shut down. Which sequence of commands is correct to restore and recover your database?
gen. 0.071
Forum
Master braindump