u011104461的博客

很详细的 kettle 自动发送邮件流程，内带说明文件，包含源代码

1Z0-053 Oracle Database 11g: Administration II QUESTION 1 What are the prerequisites for performing flashback transactions? (Choose all that apply) A. Supplemental log must be enabled B. Supplemental log must be enabled for the primary key C. Undo retention guarantee for the database must be configured D. ”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user Answer: ABD Explanation/Reference: Section: Flashback Operations & Configuration

1. The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery? A. Inactive and current redo log files are required to accomplish recovery B. Online and archived redo files are required to accomplish instance recovery C. All redo log entries after the last checkpoint are applied from redo log files to data files D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files Answer: C

1. You need to load information about new customers from the NEW_CUST table into the tables CUST and CUST_SPECIAL. If a new customer has a credit limit greater than 10,000, then the details have to be inserted into CUST_SPECIAL. All new customer details have to be inserted into the CUST table. Which technique should be used to load the data most efficiently? A. external table B. the MERGE command C. the multitable INSERT command D. INSERT using WITH CHECK OPTION